G
Guest
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
changes.
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.
=IF(SIGN(H3)=SIGN(H4),H3+H4,H3)
Thanks
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
changes.
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.
=IF(SIGN(H3)=SIGN(H4),H3+H4,H3)
Thanks