Volatility ETP O/H/L/C Backtests

Description

I have generated Open/High/Low Close day values for the most popular long and short volatility Exchange Traded Products (ETPs) starting in  March 26^th, 2004 through the end of the most recent quarter (see this table for specific dates) using the VIX futures historical data that underlies these funds.  In addition to the currently trading products: VXX, VXZ,  1.5X UVXY, -0.5X SVXY, VIXM, VIXY, SVIX, UVIX, ZIVB, and BITX) this dataset also includes simulations for these discontinued or releveraged funds:  XIV, -1X SVXY, 2X UVXY, TVIX, ZIV).

None of the volatility ETPs started trading before January 2009, so there is no market price data available before that (e.g., during the 2008 market crash).  This simulation includes ETP simulated open, high, low, and end-of-day closing prices from March 2004 through October 2013 and includes publicly available OHLC data through the most recent quarter.  See this table for specific dates.   The VXX publicly available OHLC data has been corrected to better handle the inclusion of VXXB data.  The VXZ data has been corrected also but it has a gap in 2018 data.

For more information on this product see:

• Open / High / Low /  Close Simulations for Popular Volatility Exchange Traded Products
• 1.5X UVXY & -0.5X SVXY Open/High/Low/Close values

A less expensive end-of-day version of this product is also available, see: End-Of-Day Simulations for Popular Volatility Exchange Traded Products

I offer a quarterly update service for this spreadsheet.