Hello,
I am using excel to model an investing system.
My system relies on measuring the performance of a stock over the past 10 months (i.e. the closing price on the last trading day of the latest month minus the closing price on the last trading day of the month 10 months ago).
Obviously, this is easy to do using monthly price data. However, I need to use DAILY price data (so that I can calculate profit/loss on a daily basis).
Using Daily price data, how do I get Excel to calculate the 10 month (or other duration) performance as described above?
I can't simply use a fixed number of days (i.e. 200 days), as the number of days varies from month to month.
Please help.
Bookmarks