Calculating the VIX in Excel

Authors

Tom Arnold, University of RichmondFollow
John H. Earl, Jr., University of RichmondFollow

DOI

10.3905/jot.2008.708835

Abstract

The VIX, based on a weighted average of S&P 500 Index options that straddle a 30-day maturity, has become a popular volatility index. This manner of calculating the VIX emerged in September of 2003 and is documented with an example by the CBOE. In this article, the calculation of the VIX is reproduced in a Microsoft Excel template to automate and to some degree simplify the calculation. Further, one can also apply other option series to calculate a VIX-type analysis for the underlying security, which is of great benefit because the calculation is independent of option-pricing model biases.

Document Type

Article

Publication Date

6-30-2008

Publisher Statement

© 2008 Pageant Media Ltd. This article first appeared in The Journal of Trading 3, no. 3 (June 30, 2008): 39–45.

Please note that downloads of the article are for private/personal use only.

Recommended Citation

Arnold, Tom, and John H. Earl. “Calculating the Vix in Excel.” The Journal of Trading 3, no. 3 (June 30, 2008): 39–45. doi:10.3905/jot.2008.708835.