NumXL 1.67 MARTHA public availability

Volatility Forecast with GARCH

This week, the “Tips & Tricks” newsletter tackles the issue of the volatility forecast using GARCH Modeling techniques. Starting with S&P 500 ETF monthly prices, the paper illustrates the few steps it takes to process the raw data; specify a model; fit or to calibrate the model coefficients values; validate the assumptions of the underlying model; and, finally, to construct a 12-month volatility forecast. We did all of the steps using NumXL, right in Excel.

For details or to download the document and/or the spreadsheet for this tutorial, go-to tips NumXL Cookbook: Volatility Forecast with GARCH on our website.

Leave a Reply

Your email address will not be published. Required fields are marked *

We are glad you have chosen to leave a comment. Please keep in mind that comments are moderated according to our comment policy.