VIX Term Structure Historical Data

This page is a guide to downloading VIX term structure historical data from CBOE website. VIX term structure, as officially used by CBOE, is calculated from S&P500 option prices and it is not the same as VIX futures curve (see the difference explained here). If you are looking for VIX futures historical data, see instructions here.

How to Download VIX Term Structure Data from CBOE Website

You need to have an account on , which is free.

The page for downloading VIX Term Structure historical data is here:

On that page you can find several tabs at the top:

To download VIX term structure historical data in Excel format, choose “Submit a Query”.

On that page you need to select your data preferences.

Historical Data Preferences

First you need to select type of query – choose particular S&P500 options expiration months either by expiration date or month number (1st expiration on a given date, 2nd, 3rd etc.), or constant maturity (calculated by interpolating multiple months, like when calculating the VIX index).

Then you need to set range of dates. Available history goes back to November 2010.

If you have selected the expiration dates query type, the page will load individual expiration months after you have selected the dates range. You can select one or more months.

In the final step select frequency of data. Available frequencies are daily, weekly, monthly, 1 hour, 1 minute, and 15 seconds. Note that if you select 1 minute or 15 seconds, there will be a lot of rows and you will probably have to run many queries if you want longer history or multiple expiration months.

Downloading the Data

Then you click the “Submit” button and you are taken to another page (“My Results”), which lists all your recent queries. Wait a minute or two for the data to be ready and then you can download the file. The file is a .zip, which contains a .xls (old Excel) file.

Related pages

yahoo stocks dowannualization calculatoreuropean option calculatormsft stock historyblack scholes put option calculatorrsi definitionskewness definition in statisticsannualized standard deviation excelwacc debtdelta greeksstraddle positionblack scholes greekfx function in excelvixy.comweighted average costingrho calculationpercentile calculator excel2x vix etfblack sholehistorical volatility calculationhow to calculate covariance from variancekurtosis examplesbuying vix callshow to short the vixlognormal volatilityrate of return calculator for stockssimple excel formulasstatistics formula calculatortrading vixhow to calculate excel formulascboe volatilitystandard deviation formula for excelyahoo indicescboe vix term structureusd yen etfshort strangle option strategycalculate implied interest rates&p etf listexcel formulas minustheta formulavix index definitionaverage true range formulacalculate annualized volatilitycalculating skewnessvariance formula derivationwhat is standard deviation in mathsoption strategy calculatorhow to trade with macdstock sharpe ratiolatest 13d filingshow to draw break even chart in exceloptions trading greekslogarithmic returnsvix future priceblack scholes explaineddirectional options tradingstock rsi calculatoreasy standard deviation calculatordirectional strategy hedge fundsprice weighted indexesyahoo downloaderstraddle calculatorotm optionsvix etf 3xhow to calculate daily volatility of a stockonline black scholes option calculatormarket sharpe ratiomacd buy signalblack scholes delta calculatorannualization formulasharpe ratio excelwhat is black scholes option pricing modeldelta gamma vegamsft yahoo finance