Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just saw the question How to calculate the most realistic historical option prices with additional publicly available parameters and I am interested in the step before that.

How can I calculate historical ATM option prices for the SP500 using VIX prices and other publicly available data? Can I just use VIX as implied volatility? can I go slightly out of the money (to 2% or 5%)?

Any links to examples or code will be appreciated!

share|improve this question
up vote 1 down vote accepted

I don't know if I understand your question correctly but the procedure how to calculate ATM option prices with publicly available implied volatility indices (like VXO) for the vol parameter can be found in the mentioned paper on pages 5-7:

How Students Can Backtest Madoff’s Claims by Michael J. Stutzer (2009)

share|improve this answer
I was hoping to get an example or some (R,C,Excel) code to do it. It is the first time I try it so I don't understand all the variables yet. – Terco Jul 1 '12 at 17:34
@Terco: Just do a Google search for "Black Scholes Excel" and use the variables as stated in the paper - it is not that complicated! – vonjd Jul 2 '12 at 6:54
Stutzer's paper indeed has everything you need. It just takes a bit of time to put things together. – Terco Jul 2 '12 at 15:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.