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

different formulas in excelvariance shortcut formulaannualized volatilityblack scholes graphnormal distribution excel templatemomentum formulasblack scholes calculator putvelocity shares etfrsi conditionexponential moving average algorithmproshares ultradiscounted dividend model excelweighted average cost of capital calculatorvix option pricesultra vix etfput and calls for dummiesformula distblack scholes formulaportfolio sharpe ratiostd deviation calculationmeaning of kurtosiscalculate the mean variance and standard deviationcfe cboerelative standard deviation calculatorvstoxx volatility indexvix trading hoursoptions profit and loss calculatorvix options tradinghow to calculate cumulative in exceloption payoff calculatorcalculating variance excelexcel probability formulashow to calculate volatility for black scholesapple share price history graphblack scholes model equationsum of x squared calculatortvix tickerstandard deviation calculator in excelformula for finding sample meanhow to solve kurtosisblack scholes pricing model calculatorcalculating skewema buutannual rate of return calculator excelannualized volatility formulablack scholes option pricings&p 500 spreadsheetadvantages and disadvantages of a spreadsheetimplied volatility calculationblack scholes assumptionshow to create excel formulasformula of sample variancecalculating stock volatilitywhat is straddle optionstandard deviation formula in financevariance formula in excelhow do i buy the vixhow to read macd indicatorcftc cot datacumulative probability excelstandard error of skewnesshow to calculate annualized volatilityprotective collar option3x vix etfyahoo finance sp500strangle tradeexcel 2007 standard deviationmacd buy signal3x leveraged etf listhow to delta hedgewhat is hedge fund with example