Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)
|
There might be a way to combine some of the formulas, but these should meet your criteria looking at the last 3 periods.
Column A: Bull 1
X:=1;
C > O AND C > Ref(O,-X) AND O < Ref(C,-X) AND Ref(C,-X) < Ref(O,-X)
Column B: Bull 2
X:=2;
C > O AND C > Ref(O,-X) AND O < Ref(C,-X) AND Ref(C,-X) < Ref(O,-X)
Column C: Bull 3
X:=3;
C > O AND C > Ref(O,-X) AND O < Ref(C,-X) AND Ref(C,-X) < Ref(O,-X)
Column D: Bear 1
X:=1;
C < O AND C < Ref(O,-X) AND O > Ref(C,-X) AND Ref(C,-X) > Ref(O,-X)
Column E: Bear 2
X:=2;
C < O AND C < Ref(O,-X) AND O > Ref(C,-X) AND Ref(C,-X) > Ref(O,-X)
Column F: Bear 3
X:=3;
C < O AND C < Ref(O,-X) AND O > Ref(C,-X) AND Ref(C,-X) > Ref(O,-X) Edited by user 8 years ago
| Reason: Not specified
|
1 user thanked MS Support for this useful post.
|
|