Hi All
Please can anyone help me creat a macro that can do the following:
given a data set
a b c
01-Jan 2010 5 10 15
01-Feb 2010... 9 5 10
01-March.... 4 6 4
on this set, I can calculate 3 cummulative return, next month I will add May and then wish to calculate 3 cummulative retun up to May,
My actual data set is muc larger and I actually want to calculate cummalitve returns for 3 6 9 12 24 months, and adding an additional month at the start of a new month,
Any ideas out there?
Please can anyone help me creat a macro that can do the following:
given a data set
a b c
01-Jan 2010 5 10 15
01-Feb 2010... 9 5 10
01-March.... 4 6 4
on this set, I can calculate 3 cummulative return, next month I will add May and then wish to calculate 3 cummulative retun up to May,
My actual data set is muc larger and I actually want to calculate cummalitve returns for 3 6 9 12 24 months, and adding an additional month at the start of a new month,
Any ideas out there?