Excel Continuous Running Total

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


0
Scotty (9)
3/22/2007 12:46:13 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
1525 Views

Similar Articles

[PageSpeed] 16

=SumIf(A2:A30,">0",A2:A30)
=SumIf(A2:A30,"<0",A2:A30)
-- 
Best wishes,

Jim


"Scotty" wrote:

> 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
> 
> 
0
JimJackson (21)
3/22/2007 12:54:05 PM
Reply:

Similar Artilces: