Rank: Advanced Member
Groups: Registered, Registered Users Joined: 6/6/2005(UTC) Posts: 424 Location: connecticut,USA
|
Refer to post: http://forum.equis.com/viewtopic.php?p=14802
[code:1:0212b840ae]Column A
Sig:=If(Cum(1)=5,Ref(C,-1)+(Pwr((Abs((C-Ref(C,-4))/Sum(Abs(ROC(C,1,$)),4)))*((2/3)-(2/31))+(2/31),2))*(C-Ref(C,-1)),PREV+(Pwr((Abs((C-Ref(C,-4))/Sum(Abs(ROC(C,1,$)),4)))*((2/3)-(2/31))+(2/31),2))*(C-PREV));
Sig>Ref(Sig,-1) AND Ref(Sig,-1)<Ref(Sig,-2)
Column B
Sig:=If(Cum(1)=5,Ref(C,-1)+(Pwr((Abs((C-Ref(C,-4))/Sum(Abs(ROC(C,1,$)),4)))*((2/3)-(2/31))+(2/31),2))*(C-Ref(C,-1)),PREV+(Pwr((Abs((C-Ref(C,-4))/Sum(Abs(ROC(C,1,$)),4)))*((2/3)-(2/31))+(2/31),2))*(C-PREV));
Filter
colA OR colB[/code:1:0212b840ae]
|