Hello -
I need to create a VBA loop that applies a weekly (7-day iteration) to a selected "end date." The goal is lag the end date by 1-week and copy and paste data from a matrix I created in order to generate a time series of signals, which I call ranks, until the start of the data set. For instance, the data set is currently based on a start date of 02/1/2004 and an end date of 11/12/2013, which should generate a time series of 468 points. The sheet is attached.
Start and End date on the "risk" tab control the dates for the entire sheet. As such, the loop needs to offset the end date on that tab to begin the weekly iterations. The end date would be offset by 7 days, 14 days, 21 days and so on until the start date. The result is that each time the loop starts a new week rows 20 and 21 from the "ranking model" tab are copied and pasted into a new tab.
Each iteration of the loop (weekly change) will copy and paste rows 20 (positioning rank) and 21 (currency) and create a historical time series of the rankings. The goal is to generate a historic time series of these rows by copying and pasting them into a seperate tab. The data feeds are APIs from Bloomberg so I imagaine it take a bit of time to run through each iteration and copy and paste the data. I am a VBA novice so any thoughts about how to configure this loop and create a time series of the aforementioned rows (data points) is greatly appreciated.
Bookmarks