Question: An Excel spreadsheet containing over 900 days of daily data on a number of different exchange rates and stock indices can be downloaded from the
An Excel spreadsheet containing over 900 days of daily data on a number of different exchange rates and stock indices can be downloaded from the author€™s website:
www-2.rotman.utoronto.ca/ˆ¼hull/RMFI/data. Choose one exchange rate and one stock index. Estimate the value of ï¬ in the EWMA model that minimizes the value of
.png){kind=small}
where vi is the variance forecast made at the end of day i ˆ’ 1 and ï¢i is the
variance calculated from data between day i and day i + 25. Use the Solver
tool in Excel. To start the EWMA calculations, set the variance forecast at
the end of the first day equal to the square of the return on that day.
-)
Step by Step Solution
3.29 Rating (167 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
500-B-C-F-R-A-M (881).xlsx
300 KBs Excel File