MySQL 计算连续涨跌

【问题】

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