> I posted a message earlier and have received a partial solution.
> I want to keep track of how much stock prices go up or down with a running
> total of how much they go up or down over several days until the direction
> For example, if price go up 10 on Mon, 20 on Tues, 30 on Thurs and down 10
> on Fri I want my running total column to show a positive number of 60 and
> then a red number of 10 and continue adding the amount of the total of the
> down days until the market shows an up day.
> The formula I am now using total the first and second day but does not do a
> running total count if there are more than two up or down days in a row.
> Your help is appreciated.