Using the CBOE’s VIX futures historic data and interpolations/extrapolations for contracts that were not traded I developed a continuous time series for 7 months of VIX futures settlement values. I then used that data, plus treasury bill data to compute the indexes that underly the popular long and short volatility Exchange Traded Products (ETPs) in the USA.
This product includes two spreadsheets, one that includes the formulas to properly format the VIX futures data and to generate the total returns (TR) and excess returns (ER) volatility indexes such as SPVXSTR, SPVXSP, and SPVXMP. The other spreadsheet included with the product uses those volatility indexes to simulate the prices of popular volatility ETPs (e.g., VXX, 1.5X UVXY, TVIX, XIV, -0.5X SVXY, ZIV, 2X UVXY, -1X SVXY) starting in March 2004.
The VIX Futures spreadsheet includes the required futures and treasury data up through July 23rd, 2019. The spreadsheet is setup such that the user can bring the spreadsheet up to the present date in a straightforward and well-documented process.
The default presentation is to compile the settlement prices but the spreadsheet is configurable to generate daily open, high, low, close, volume, open interest and EFP (Exchange For Physical) numbers.
The spreadsheet also generates the monthly settlement prices for VIX futures contracts back to 2004.
Given the size and complexity of this product a reasonable amount of consulting time is bundled with the package. Please contact me at [email protected] for details.
If you purchase this product you will be directed to paypal where you can pay via your paypal account or a credit card. Please email me at [email protected] if you have problems, questions, or requests.