2
$\begingroup$

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!

Improve this question
$\endgroup$

1 Answer 1

Reset to default
2
$\begingroup$

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)

Improve this answer
$\endgroup$
3
  • $\begingroup$ 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. $\endgroup$
    – Terco
    Jul 1, 2012 at 17:34
  • $\begingroup$ @Terco: Just do a Google search for "Black Scholes Excel" and use the variables as stated in the paper - it is not that complicated! $\endgroup$
    – vonjd
    Jul 2, 2012 at 6:54
  • 1
    $\begingroup$ Stutzer's paper indeed has everything you need. It just takes a bit of time to put things together. $\endgroup$
    – Terco
    Jul 2, 2012 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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