CBOE Volatility Index (VIX) Futures data 2004 &8211; 2017

Updated: Mar 10th, 2017 | |

The CBOE posts historical volatility futures quotes, but not in a particularly helpful organization. Each expiration month has a separate spreadsheet, which currently adds up to > 100 different spreadsheets from May 2004 to now. Adding to the difficulties, there are four expiration months in the early years that didn&8217;t exist at all that led to a lot of missing data and a reverse split along the way.

I have created a spreadsheet that integrates all of the data from March 2004 through February 2017 into a single master sheet and interpolates / extrapolates missing data. This spreadsheet makes it much easier to analyze topics like volatility contango/backwardation over time, computing the rolling averages used by almost all the existing volatility ETNs/ ETFs, and looking at term structures.  The master spreadsheet for a small subset of dates is shown below.

Volatility Worksheet 2004-2011, click to enlarge

The spreadsheet includes the required futures data up through February 2017.  It is a straightforward task to incorporate data up until the present date.  That process is documented in the spreadsheet itself.  While this futures data can be used to compute the values of the various volatility indexes (e.g., SPVXSTR) that calculation is not included in this spreadsheet.  That product is described here.

A readme sheet with detailed instructions is included with the download.  Email ([email&160;protected]) and phone (970-481-7426) support is included with purchase.   Go to the very bottom portion of this post to buy this spreadsheet.

SFI Volatility Futures Worksheets
Product Options
OptionPriceDownloadFile Size
1XLSX format$100.00SFI_Volatility_Futures_Worksheet-no_indexes-wd_C4-6Mar17.xlsx 14.37MB
Shipping Rate: F
Order SFI Volatility Futures Worksheets XLSX format @ $100.00

Your credit card statement will show the following description on this transaction: "PAYPAL*VH2SOLUTION". After you have paid look for a "Return to Six Figure Investing" link. This will take you to a page where you can download the product.

Related Posts

Friday, March 10th, 2017 |
  • Pingback: Historical Futures Data | NYSE, New York Stock Exchange()

  • Alex

    Hi Vince,
    Great job all around. Just a comment on your spreadsheet regarding columns to interpolate M6 and M7 : For these two you interpolated vols using M4 and M5 but actually M8 is available (VXX2004). VXX2004 has had open interest since Mars 2004.

    It would be preferable to use the interpolation formula that takes into account Ti+2 and Ti-1 rather than Ti-1 and Ti-2.

    By using M4 and M5 to interpolate M6 and M7 you actually create a &8220;fake contango&8221; or an exaggerated contango effect. VXX is very much in backwardation so your M6 and M7 should actually trade at higher levels than M4 and M5.

    I used Ti+2 and Ti-1 to interpolate M6, so M6 = f(M5, M8)
    And I used Ti+1 and Ti-1 to interpolate M7, so M7 = f(M6, M8).
    where M8 are real traded values.

    If you want to check your first line will be
    20.36 (M6)
    20.62 (M7)
    20.94 (M8 real point)

    Great idea to interpolate VXJ2004 !! i have the same results here.

  • Hi Alex,
    I discovered that the M8 data was available for interpolation after I had done the initial snapshot shown in the post and I forgot to update the graphic. My current results match the ones you posted. It&8217;s great to have someone checking the math. Most people don&8217;t know what the hell you&8217;re doing&8230;

    Best Regards,


  • Alex

    Anyway interpolation is only what it is so there are several ways to go about it. But since you&8217;ve been so diligent I just wanted to point out M8 and this case of having ti-1 and ti+2 repeats A LOT of times up to April 2008&8230;so it could potentially impact your VXZ backtest significantly.

    I&8217;ll check the other maths but if you match Barclays you&8217;re golden. And you&8217;ve got the fees calcs right !

  • Peter Gammon

    I know this is old, but have you updated the spreadsheet to be up to date?

  • Hi Peter, Currently I have it updated with data / expiration dates through March 2016. If you&8217;re interested I can bring it up to the present&8211;although then it&8217;s up to you.

    &8212; Vance

  • Peter Gammon

    Hi Vance,

    After perusing your site (very good, btw, so I&8217;ve recommended it to others) I notice that you have some specific spreadsheets that help with backtesting.

    What makes sense for me is the one that is applicable to UVXY. Is &8220;3 UVXY Simulation $30.00 SFI ETP backtest UVXY values E1 18Dec14 336.40KB&8221; also updated to today&8217;s data?

    Thank you

  • Hi Peter, I&8217;ve updated the UVXY file on the products tab of my site to be current up to 9-March-2016. If you purchase this I&8217;ll do an update to bring it up to the current date and email it to you.

    &8212; vance

  • Peter Gammon

    Hey Vance, Sorry for the (hopefully final) question: so this product will simulate, albeit very accurately, what UVXY would have closed at each day by providing a table of values back to 2004? I realized my worry about getting &8220;up to date&8221; info was moot as I obviously can get that for free at many sites (e.g. Yahoo). While a graph would be nice to look at, I&8217;m much more interested in a table of values. I want to understand how UVXY would have behaved in period such as 2008 and 2009 (lengthy periods of almost consistent high vol).


  • Hi Peter, Yes, product provides simulated daily close since March 2004.

    Best regards, vance