help with garch understanding

[officemynotisthis]

Hello all,

I need some help, i have been recommended that i use GARCH to estimate volatility and (predict) volatility. I managed to find a spreadsheet that could serve the purpose, but i need some help as to what each column is doing exactly to truly understand this.

 

[Ken Abbott]

Hard to do from scratch. First you need to understand Box-Jenkins analysis, then you need to comprehend the notion of time-varying volatility.

 

[officemynotisthis]

I have a simple understanding of Box Jenkins and time varying volatility, however i hope as you explain i can ask any questions i dont understand....help permitting