Date Ranges on Simulation Spreadsheets

This table gives the date ranges covered by the spreadsheets that I have for sale. For a complete list of products see this page.

For active securities, I am very willing to update spreadsheets up to the end of the most recently completed calendar quarter upon request at [email protected]

DescriptionStart DateEnd DateNotes
VIX Futures Extended Data (VX OHLC +more), no indexes 26-Mar-200416-Jan-2024
VIX Futures, no Indexes26-Mar-200416-Jan-2024
VIX Futures, including volatility Indexes (e.g., similar to SPVXSTR & SPVXSP)26-Mar-2004
16-Jan-2024
ETP Backtests, End of Day Close (VXX,VXZ, UVXY, SVXY,VIXY,TVIX,ZIV,XIV, VIXM,UVIX,SVIX,ZIVB26-Mar-200416-Jan-2024Recent additions UVIX, SVIX, ZIVB
ETP Backtests, Open, High, Low, Close (VXX,VXZ, UVXY, SVXY,VIXY,TVIX,ZIV,XIV)26-Mar-200416-Jan-2024After 13-Oct-2013 OHL data is actual trade data, not simulated data
UVIX, SVIX backtests, SHORTVOL, LONGVOL30-Nov-200516-Jan-2024Free
VXX Backtest, End of Day Close26-Mar-20045-Jan-2023Includes all trade data from VXX’s inception in 2009 through end date
VXX Backtest, Open, High, Low, Close26-Mar-20045-Jan-2023After 13-Oct-2013 OHL data is actual trade data, not simulated data
UVXY Backtest, End of Day Close26-Mar-20045-Jan-2023Includes full end of day simulations of 1.5X and 2X products
UVXY Backtest, Open, High, Low, Close26-Mar-20045-Jan-2023Includes full end-of-day simulations of 1.5X and 2X products. After 13-Oct-2013 OHL data is actual trade data, not simulated data
SVXY Backtest, End of Day Close26-Mar-20045-Jan-2023Includes simulations of -0.5X and -1X products as well as XIV.
SVXY Backtest, Open, High, Low, Close26-Mar-20045-Jan-2023Includes simulations of -0.5X and -1X products as well as XIV. After 13-Oct-2013 OHL data is actual trade data, not simulated data
VIXY Backtest, End of Day Close26-Mar-20045-Jan-2023
VIXY Backtest, Open, High, Low, Close26-Mar-20045-Jan-2023After 13-Oct-2013 OHL data is actual trade data, not simulated data
VXZ Backtest, End of Day Close26-Mar-200425-Jan-2022Includes all trade data from VXZ’s inception in 2009 through end data, except for some dates in 2018
VXZ Backtest, Open, High, Low, Close26-Mar-200425-Jan-2022After 13-Oct-2013 OHL data is actual trade data, not simulated data
VIXM Backtest, End of Day Close26-Mar-200411-Jul-2022
VIX3M & VIX6M Style Index Calculations2-Jan-199016-Jan-2024
VIX3M Style Index Calculations2-Jan-199010-Apr-2023
VIX6M Style Index Calculations2-Jan-199010-Apr-2023
TVIX Backtest, End of Day Close26-Mar-200429-May-2020No longer listed on NYSE, trading OTC
TVIX Backtest, Open, High, Low, Close26-Mar-200429-May-2020No longer listed on NYSE, trading OTC
After 13-Oct-2013 OHL data is actual trade data, not simulated data
ZIV Backtest, End of Day Close26-Mar-200429-May-2020No longer listed on NYSE, trading OTC
ZIV Backtest, Open, High, Low, Close26-Mar-200429-May-2020No longer listed on NYSE, trading OTC.
After 13-Oct-2013 OHL data is actual trade data, not simulated data

First posted on

Click here to leave a comment

2 thoughts on “Date Ranges on Simulation Spreadsheets”

Leave a Reply to Vance Harwood Cancel reply