Here you go...
MMA 10/45
If(OscP(10,45,E,%)>0,1,-1)
do the same for 12/50 .....15/60 .... 3/30 .... 5/35 .....8/40
MMA TOTAL (Note space between MMA 3/30 must be retained)
Fml("MMA 3/30")+Fml("MMA 5/35")+Fml("MMA 8/40")+Fml("MMA 10/45")+Fml("MMA 12/50")+Fml("MMA 15/60")
The exploration formula is :
Column A
CLOSE
Column B
Ref(C,-1)
Column C
Ref(C,-2)
Column D
Fml("MMA 3/30")+Fml("MMA 5/35")+Fml("MMA 8/40")+Fml("MMA 10/45")+Fml("MMA 12/50")+Fml("MMA 15/60")
Column E
Ref(Fml("MMA 3/30")+Fml("MMA 5/35")+Fml("MMA 8/40")+Fml("MMA 10/45")+Fml("MMA 12/50")+Fml("MMA 15/60"),-1)
Filter source
Formula
When (colD,>,0) AND When (colE,<=,0)
Anything in bold type are notes not part of the formula.