Calculate rolling 5 yr returns.? Use table in data sheet - ImportData.? The sheet Calculate Rolling Bench Return has the values to be looked and calculated - each bmk-cusip will be looked-up in ImportData and a rolling 5 yr return will be calculated for each of 12 month - using the MonthYear as the range.?
Example: 1YR = first 12 month of this cusip:
<colgroup> <col style="width: 61pt" width="81" /></colgroup> | **B00819449** |
? For instance, from 06/30/2003 to 05/31/2004 will be the first 12 month period for this cusip - B00819449.? So the calculated value goes into the 1YR column.? Then the next? 12 month, ....etc.? until all five (5) 12 month for this cusip is calculated
2YR column = second 12 month, .....