Hi all,
I am trying to calculate weekly and monthly returns using daily share price data.
In its simplest form, the calculations should be:
- Current Week / Last Week - 1
- Current Month / Last Month - 1
I added in columns for Year, Month, Week, and Day to facilitate using some IF formulas paired with VLookups but got stuck.
There seem to be two complicating factors:
The data spans multiple years (i.e. there is not only one week 2, there is a week 2 in every year of data)
Not every week has the same number of days (holidays, etc.)
I've attached some sample cells. Any help you could give me would be hugely appreciated.
Bookmarks