PS Cycle Progression - Formula?

[rahul100]

Hi

If i wanted to cre\ate this in excel can someone please tell me how to interpret this, its one on the indicators built into MS

Sum(If(C>Ref(C,-1),1,0),5)<Sum(If(C<Ref(C,-1),1,0),5)

Sum(If(C>Ref(C,-1),1,0),5)>Sum(If(C<Ref(C,-1),1,0),5)

Thanks in advance

 

[lalthan]

1. If(C>Ref(C,-1),1,0) - If current close is greater than previous close then 1 else zero.
2. Sum of 1 for last 5 periods (i.e. sum of either 1 or 0 from point 1 result)
3. If(C<Ref(C,-1),1,0) - If current close is less than previous close then 1 else zero
4. Sum of 3 for last 5 periods (i.e. sum of either 1 or 0 from point 3 result)
Then
check if 2 < 4 or 2 > 4

 

[Leo123]

Is there anyone who can code the code into ninja trader?

Thanks