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 Monday, November 14, 2016 9:41:22 PM(UTC)  | Reason: Not specified

Currently this is not possible (without a DLL) as it would require the REF variable to increase dynamically while summing up the condition. This is something we will be looking at as we re-work the formula language in future versions. That said, in this particular example I think the condition is rare enough that you will not see it exceed this number too often.