I have a range of historical data points for tradable securities that update daily. At the end of the day today the price of the security will be recorded and the data points will all be pushed down one row to make room for the next day at the top. Time/Date Yield CHG =Now 0.372 0.002 Prior Trading day 0.370 -0.005 Prior Trading day 0.375 0.005 Prior Trading day 0.370 0.003 Prior Trading day 0.367 0.002 ... and so on... 0.365 .... I'm trying to track how many consecutive days a security is moving one direction or the other, up or down. In this example it would be 1 day up, obviously. Next week it could be up or down X days in a row... Is there an efficient way to track these changes as time progresses and the spreadsheet updates? Thanks.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Up Days/ Down Days

Thread starter MarcJohn
Start date Jun 2, 2014

MarcJohn

New Member

Jun 2, 2014

I have a range of historical data points for tradable securities that update daily. At the end of the day today the price of the security will be recorded and the data points will all be pushed down one row to make room for the next day at the top.

Time/Date	Yield	CHG
=Now	0.372	0.002
Prior Trading day	0.370	-0.005
Prior Trading day	0.375	0.005
Prior Trading day	0.370	0.003
Prior Trading day	0.367	0.002
... and so on...	0.365	....

I'm trying to track how many consecutive days a security is moving one direction or the other, up or down. In this example it would be 1 day up, obviously. Next week it could be up or down X days in a row...

Is there an efficient way to track these changes as time progresses and the spreadsheet updates?

Thanks.