Historical Backtest on VQT

I have backtested Barclays’ VQT 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 including the 0.95% annual fee from March 29, 2004, until June 30th, 2014.   I have included the reported IV values from Barclays through January 2017. The results of the simulated values compared to actual values are shown in the chart below.  My results match samples from the published SPVQDTR underlying index within 0.35%.

Simulated VQT vs Actuals


VQT is a way to have exposure to the general market and profit from major market panics.   For details on VQT see:

For more information on the spreadsheets, I have for sale see this readme.

If you purchase the spreadsheet 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.


First posted on

9 thoughts on “Historical Backtest on VQT”

  1. Really, very good information. By the way where can I get VQT Historical Prices from 2004 in excel format o similar in order to backtest my portfolio. Many thanks for your help

    • Hi, I offer the VQT simulation data from March 2004 on for sale, but I have not put the info for sale yet on my website. For the data only (dates & prices) I charge $40. If you want the full spreadsheet with all formulas and indexes required to compute VQT’s value I charge $200. If you are interested in either send me an email at [email protected] letting me know which one you would like to buy. I’ll email the spreadsheet and you can pay me via paypal. Please let me know if you have any questions.
      Best Regards, Vance

  2. hi Vance,
    do you notice what happened to XVZ today?
    about an hour after market open, it doesn’t move anymore and locked at 57.25
    do you have any idea about this?
     

    • Hi Hendra, I looked at the charts and didn’t see anything unusual. XVZ is lightly traded, so it can be a long time between trades. I’m expecting XVZ to bottom soon and start back up.

      — Vance

      • yes Vance, you’re correct
        it’s because XVZ’s volume
        thanks for your respond
        keep posting useful articles as usual!!

  3. I wonder if VQT was optimized for the 2008 downturn/VIX explosion. We won’t really know until a major out-of-sample VIX spike and market correction occurs.

    • Hi Andrew, I expect it was. But it did handle the 2nd half 2011 troubles nicely. I like the way it tracks 20 day vs 5 day volatility. Feels like a more general and robust approach compared to XVZ’s hard coded VIX/VXV ratios triggers.
      — Vance

Leave a Comment