Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/29/2004(UTC) Posts: 1,394 Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
If you have the Power Pivots Plus Add-on here is a way to get the first signal without having to use the Prev Function and slowing down your explorations
Symbols
Long Entry
LE:=H>Ref(HHV(H,20),-1);
LX:=Ref(H>Ref(HHV(H,20),-1),-1);
SE:=L<Ref(LLV(L,20),-1);
SX:=Ref(L<Ref(LLV(L,20),-1),-1);
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B>0 AND Ref(B,-1)<=0
Short Entry
LE:=H>Ref(HHV(H,20),-1);
LX:=Ref(H>Ref(HHV(H,20),-1),-1);
SE:=L<Ref(LLV(L,20),-1);
SX:=Ref(L<Ref(LLV(L,20),-1),-1);
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B<0 AND Ref(B,-1)>=0
Long Exit
LE:=H>Ref(HHV(H,20),-1);
LX:=Ref(H>Ref(HHV(H,20),-1),-1);
SE:=L<Ref(LLV(L,20),-1);
SX:=Ref(L<Ref(LLV(L,20),-1),-1);
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B=0 AND Ref(B,-1)>0
Short Exit
LE:=H>Ref(HHV(H,20),-1);
LX:=Ref(H>Ref(HHV(H,20),-1),-1);
SE:=L<Ref(LLV(L,20),-1);
SX:=Ref(L<Ref(LLV(L,20),-1),-1);
B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!");
B=0 AND Ref(B,-1)<0
|