Subscribe to DSC Newsletter

Hello everyone! I am currently doing my thesis and I want to know how can I make an appropiate or "good guess" for GARCH (1,1) parameters (omega, alpha, beta) inorder for the microsoft excel SOLVER function can find the values. I am stuck...anyone got any suggestion. Thank you for your time...........

Views: 5971

Reply to This

Replies to This Discussion

I had the same question. I began with a crude estimate of (omega, alpha, beta) = (0.02, 0.90, 0.08) -- they sum to 1. From this I was able to generage a GARCH model of S&P500 historical volatility that closely matched the VIX. I thought that quite impressive, since the GARCH model used just the S&P500 daily close and the VIX is based entirely on option chain bid-ask prices. I shared a spreadsheet with you of this, below. But again, I would like to figure out, in general, the technique for determining the omega, alpha, beta values. If you find out anything, please let me know. Thanks, Mike G.
Very impressing analysis. But you need to be sure that you have a martingale series of errors terms, i.e., that you have cleaned up all seasonality factors from the series before you Garch it. I will try your series in eviews to see if the GARCH parameters are reasonable.
Haim Shalit,

Thank you for the reply here. I reviewed the math of martingale series at Wikipedia but do not know how to apply the theory to the price data as you suggest. Would it be possible for you to briefly describe what is to be done and provide a reference so that I can learn the technique you alluded to?

Many thanks,
Thank you very much for you time and your advice. It worked as charme. I got the values and they are very close to the values extracted from EVIEWS. Thank once again.....


I have not used EVIEWS. Is it correct that the EVIEWS software generated (somehow) values of omega, alpha and beta that are close to the choices I landed on as a first approximation?

Thanks for your feedback,
Mike Gutmann
Hi Michael,
I am new member and i want to know how i can implement GARCH in my thesis, caan you please tell me the procedure of it? i am working to study the volatality of KSE pakistan, so please guide me how i will prepare data and measure coefficients etc.


Yasin Mahmood
I think you should try with Logarithmic return not absolute return
There is a very large body of literature on estimating GARCH. Generally you can use the two-step estimator as an approximation, or just do the first step to yield starting values for your iterative optimization. Looking through my bookshelf, I found a brief description in Greene’s Econometric Analysis using OLS and a more thorough treatment in Tsay’s Analysis of Financial Time Series using ML.
Joseph Foutz,

What textbook do you recommend as both introduction to GARCH as well as enough material to make use of GARCH; i.e., understand the theory behind the generation of omega, beta and alpha? Or is it as simple as the econometricians running OLS passes to fit the data? Sorry, I'm quite new to econometrics.

Mike Gutmann
I’ve cited Greene and Tsay already. Arup (below) cites Hamilton, which I used in a time series class. It’s a pain to read. And odd – example, where anyone else on earth would say “matrix form” he says “state space form” – which by some miracle doesn’t actually boggle the mind when he starts talking about state space models… Hamilton does not even BEGIN to address actually computing anything he talks about, but he represents the state of how things are taught. I think Tsay is your best bet on GARCH. Greene is also good. All three should be available at reasonably well equipped academic libraries. Gujarati doesn’t really cover GARCH, but he’s my all time favorite econometrics text author.

Also, manuals to commercial statistics programs can be your friend even if you don’t use that system. They cite basically everything you need to know about the theory of the model and how to estimate it. My favorite, of course, comes from my favorite statistics package – Stata – but sadly StataCorp doesn’t put the manuals online. The JMulTi docs are frequently good. Thinking of JMulTi, you might find it to be a nice (and free) alternative to doing some of this stuff in Excel, or verifying that your Excel calcs are in the ballpark.
Many thanks for the detailed recommendations. I'm following up with the Tsay text and JMulTi.
hamilton. its a monster though, must warn you :)
Christian Gourieroux: arch models and financial applications is another good book


On Data Science Central

© 2020   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service