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

timevalue calculatorsoption strategies straddlemean median standard deviation calculatoroptions futures and other derivatives global editionskew equationformula to calculate average in excelblack scholes equationstdev pput option payofffinance tvixbull call spread strategyprice weighted index calculationdeviate defcalculate the sample varianceaverage true range formulacall option payoff graphexcel probability formulablack scholes in excelexcel formula for standard deviationcalculation of skewness and kurtosisexcel 2007 standard deviationvix options settlementcall option payoffmerits and demerits of mean median modeblack scholes theoremrelative value hedge fundvix defineannualized volatility formulastandard deviation estimatorcboe options calculatorhow to calculate population mean from sample meanrsi meaningcalculating implied interest ratestandard deviation calculatorsubs etracsformula of average deviations&p etf shortstraddles optionsoption greeks formulaexcel calculate standard deviationvix s&p500excel cumulative formulanotepad fontsacceptable skewness and kurtosis valuesformula for calculating variance in excelshort strangle option strategymacd histogramsharpe ratio formula examplevix index etfvxx etnblack scholes pricingcondor strikearithmetic made easyuses of arithmetic mean in daily lifecalculating the sharpe ratiopositive and negative number calculatoroption calculator excelwhat is leptokurticfifo and weighted average methodarithmetic mean return formuladelta otcproshares short s&p 500sec 13f filingsoptions delta gamma theta vega rhovix futures trading hoursusing macdmarket value of debt waccdow jones industrial average weightingexcel natural logarithmdeviation from the mean calculatorformula for calculating the medianshort volatility etfvariance and std deviationput option profit calculatorlogarithmic returns