Out-of-Sample estimation Garch(1,1) issues
Posted: Sat Nov 22, 2014 7:06 am
Hi everyone,
I would be very grateful for any help on this matter. My dataset is 2514 observations on the s&p500 and basically I want to estimate an out of sample conditional variance for a Garch (1,1) model. I have estimated the model based on the first 1999 observations and want the conditional variance for the remaining 513 observations (I want to compare the forecasted set to the observed values for value at risk implications).
From what I have understood, I can go on the forecast tab (static, and put in the last 513 observations for range) to get the forecasted conditional volatility based on the first 1999 observations. I am interested to get these forecasted values into an excel spreadsheet, however, when I go on proc -- "make Garch variance series" i get "NA" for the values i want to forecast....
Can someone please help me/point me in the right direction? Any help would be very much appreciated.
I have attached the workfile if that helps.
I would be very grateful for any help on this matter. My dataset is 2514 observations on the s&p500 and basically I want to estimate an out of sample conditional variance for a Garch (1,1) model. I have estimated the model based on the first 1999 observations and want the conditional variance for the remaining 513 observations (I want to compare the forecasted set to the observed values for value at risk implications).
From what I have understood, I can go on the forecast tab (static, and put in the last 513 observations for range) to get the forecasted conditional volatility based on the first 1999 observations. I am interested to get these forecasted values into an excel spreadsheet, however, when I go on proc -- "make Garch variance series" i get "NA" for the values i want to forecast....
Can someone please help me/point me in the right direction? Any help would be very much appreciated.
I have attached the workfile if that helps.