【问题】
Hello i'm trying to create a rally Up rally DOWN stock indicator. i have thre columns :
Date Price Result
1/1/2015 3 1 here start from 1
2/1/2015 4 2
3/1/2015 347 3
4/1/2015 464 4
5/1/2015 35 5
6/1/2015 363 6
7/1/2015 -5 1 here restart from 1 because it is negative
8/1/2015 -3 2
9/1/2015 -5 3
10/1/2015 37 1 here restart from 1 because it is positive
11/1/2015 896 2
12/1/2015 36 3
13/1/2015 -636 1
14/1/2015 -353 2
15/1/2015 -242 3
I want to calculate positive continues days values and add to RESULT and negative continues days values and add to RESULT.
For example if 1/1/2015 is positive then RESULT = 1
if 2/1/2015 is positive then RESULT = previous Result + 1