Term Structure of Statistics
1. Calculate the following term structures statistics (Days 1 to 252) for the SX5E index. Provide graphs similar to the ones in this chapter.
Hint To make life easier, use the OFFSET function in Excel, illustrated in Figure 3-47. (This function returns an array, not a number in a single cell.)
2. Create a scatter plot of rolling 21-day returns versus (annualized) 21-day volatilities (see formulas that follow). That is, one compares a specific 21-day return to the volatility of that same 21-day period in question. Provide graphs similar to the ones in this chapter.
3. Calculate the autocorrelation of squared returns up to 300 lag days. Provide graphs similar to the ones in this chapter.
Use the CORREL() function in Excel along with the OFFSET() function.
