XVZ Backtest from March 2004

Updated: May 30th, 2017 | |

I have now backtested Barclays&8217; XVZ ETN back to when VIX volatility futures first started to trade in March 2004.  I have made two versions of the spreadsheet available for purchase below.  One with results data only and the other version with formulas and required indexes included.  I have included the simulated daily closing values with and without the 0.95% annual fee from March 29, 2004 until January 2nd, 2013.  The results of the simulated values compared to actual values are shown in the chart below.  My results match the published SPDVIXTR underlying index within 0.001%.


XVZ appears to be a good way to hedge your portfolios during market corrections / crashes, unfortunately, it tends to decline during bull markets.   For details on how to do this see:

For a detailed analysis of the inner workings of XVZ see Under the Hood of Barclays&8217; XVZ

For more information on the spreadsheet see this readme.

My thanks to Omar Qureshi for finding the defect in my spreadsheet that had blocked me for days.

If you purchase the spreadsheet you will be eventually be directed to paypal where you can pay via your paypal account or a credit card. When you successfully complete the paypal portion you will be shown a &8220;Return to Six Figure Investing&8221; link.    Click on this link to reach the page where can download the spreadsheet.  Please email me at [email&160;protected] if you have a problem, question, or request.

If you don&8217;t see the purchase information below click on this link.

XVZ backtest-1
XVZ backtest Mar-04 through Feb-12
Product Options
OptionPriceDownloadFile Size
1XLSX format$50.00XVZ backtest Mar04 through Dec14-data only 679.99KB
2XLSX format$150.00XVZ backtest Mar04 through Dec14-full spreadsheet 1.12MB
Shipping Rate: F
Order XVZ backtest Mar-04 through Feb-12

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.

Tuesday, May 30th, 2017 |
  • vance3h

    I was able to get historical VXV data back to 2002.


  • Dkarbayev

    Hi, i find your research interesting. Before I buy your BT, my questions are:    1) how did you get historical data on VXV since 2004, as CBOE provides data since 12/4/2007?     2) does you spreadsheet have all the formulas for computing SDVIXTR fully disclosed?


  • vance3h

    Hi Dias, The VXV data was provided to me by another investor. The VXV data from March 2004 on is provided in the full spreadsheet. If you buy the full spreadsheet, not just the data you get the full formulas and indexes used in the computation. My version of the index that compares very closely to SDVIXTR is the column labeled $ Sim XVZ.

    &8212; Vance