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

cost of ending inventory formulaoptions straddlegeometric mean on excelsell put option graphtheta option greekuses of skewnessvixy prosharesvix index real timeblack scholes xlsyahoo historical datasample variance formula proofcall put option graphexcel skewnesssq root of 12futures rollover datesvix historical averageema or smaltcm trading strategiesoex options chainkurtosis meansstraddle exampleannualized standard deviationmedian disadvantagesmodelo black scholesultra short vixmacd interpretationvix futures contractthe greeks financehow to calculate bep in excelvix explainedoptions rhosample mean formula excelnotional value of optionhow to calculate cumulative in excelgeometric mean rate of return calculatorlong short equity hedge fundslist of 13f securities0-100 calculatoroption theta formulayahoo vixexcel exponential moving averagehow to calculate ema in excelproshares ultra vixinterpret skewness and kurtosisskewness equationtrading days calculatordescriptive stats in exceldefinition of kurtosiscboe vix historical dataxl formulaskurtosis meaningwhat is skewness and kurtosis in statisticsoptions greekswacc formulargamma function exceladvantages and disadvantages portfolio managementbsm option pricing modelhow to find 13f filingsbearish positionaverage inventory cost methodrsi indicator pdfinvest in vixvariance formula in excelyahoo historical pricespx marketkurtosis examplesrsi overbought oversoldcalculating covariance exampleetf vixhedge fund overviewsquare root of 3.24descriptive statistics calculatordax index methodologyvariance and standard deviation in financenormdist excelexcel formula to calculate average percentagelogarithm calculator step by stepstdev.p