Now that I’ve been trading the short VXX strategy and its variations for almost a year; I felt very motivated to try and estimate some worst case scenarios before 2009 when VXX was created. To do so, I did some rough quick and dirty calculations using the historical VIX Futures settlement prices as well as a simple OLS regression.
First, I used the following formula to determine the “Estimated VXX Price”. It is just a weighted average of the front month and second month futures’ settlement prices where the weighting is based on expiration.
For example, if it is the beginning of a 30-day term, then DTE is also equal to 30 so that the Estimated VXX Price is just equal to the 100% of the front month futures’ settlement price.
Next, I calculated the price return of the Estimated VXX Prices and used an OLS regression against the actual VXX returns. In essence the return formula for my Estimated VXX Return would be:
The regression estimates I calculated were then:
Intercept | VXX Futures Estimated Return | |
---|---|---|
Coefficient | -0.003 | 0.786 |
Standard Error | 0.000 | 0.008 |
t-Value | -8.093 | 92.518 |
Lower 95% Confidence | -0.004 | 0.769 |
Upper 95% Confidence | -0.002 | 0.803 |
R-Squared | 0.811 | |
Adjusted R-Squared | 0.811 |
Since the R-Squared is relatively high for my estimated model, I can use the estimated coefficients to calculate ball-park returns for VXX before 2009. I’ve created the top-10 worst return days before 2009 as well as top-10 worst return days of actual VXX returns post-2009. Note that what I refer to as worst return days is days with the largest positive return in VXX since my strategy is to generally be short.
Date | VIX Spot | VIX F1 | VIX F2 | VIX Return | VXX Inferred Return | Ratio |
---|---|---|---|---|---|---|
10/15/2008 | 69.25 | 58.18 | 42.70 | -2.37% | 37.57% | 1.1903 |
02/26/2007 | 11.15 | 11.44 | 12.54 | 64.22% | 20.66% | 0.9747 |
09/20/2006 | 11.39 | 11.29 | 11.29 | 7.55% | 18.54% | 1.0089 |
12/21/2005 | 10.81 | 10.18 | 10.18 | -4.81% | 17.96% | 1.0624 |
08/15/2007 | 30.67 | 28.81 | 25.18 | 0.52% | 16.34% | 1.0646 |
10/21/2008 | 53.11 | 52.80 | 43.80 | 31.14% | 13.25% | 1.0059 |
08/16/2006 | 12.41 | 12.29 | 12.29 | -1.37% | 11.17% | 1.0102 |
10/31/2007 | 18.53 | 19.06 | 20.30 | 25.26% | 11.06% | 0.9722 |
06/12/2006 | 20.96 | 18.21 | 18.21 | 13.60% | 10.78% | 1.1510 |
08/08/2007 | 21.45 | 20.16 | 20.25 | 23.45% | 10.53% | 1.0640 |
Date | VIX Spot | VIX F1 | VIX F2 | VIX Return | VXX Inferred Return | Ratio |
---|---|---|---|---|---|---|
02/26/2007 | 11.15 | 11.44 | 12.54 | 64.22% | 20.66% | 0.9747 |
10/31/2007 | 18.53 | 19.06 | 20.30 | 25.26% | 11.06% | 0.9722 |
01/16/2009 | 46.11 | 49.65 | 48.53 | 22.86% | 9.48% | 0.9287 |
06/05/2008 | 18.63 | 19.91 | 22.13 | 26.46% | 8.74% | 0.9357 |
11/06/2007 | 21.39 | 22.45 | 22.92 | 23.84% | 8.37% | 0.9528 |
05/26/2006 | 14.26 | 14.90 | 14.90 | 30.86% | 7.29% | 0.9570 |
07/12/2006 | 14.49 | 14.44 | 15.58 | 22.77% | 6.50% | 1.0035 |
01/13/2009 | 43.27 | 46.67 | 46.81 | 13.57% | 6.46% | 0.9271 |
06/25/2008 | 21.14 | 22.61 | 22.75 | 13.20% | 6.43% | 0.9350 |
01/06/2009 | 38.56 | 39.53 | 39.55 | 12.53% | 6.38% | 0.9755 |
Date | VIX Spot | VIX F1 | VIX F2 | VIX Return | VXX Actual Return | Ratio |
---|---|---|---|---|---|---|
06/23/2016 | 17.25 | 16.68 | 17.63 | 49.33% | 23.66% | 1.0345 |
08/17/2011 | 31.58 | 32.73 | 27.95 | 35.12% | 20.70% | 0.9649 |
08/03/2011 | 23.38 | 22.00 | 21.85 | 35.41% | 19.98% | 1.0627 |
11/08/2011 | 27.48 | 28.90 | 28.35 | 31.59% | 18.86% | 0.9509 |
08/21/2015 | 28.03 | 19.90 | 18.63 | 45.34% | 17.62% | 1.4085 |
08/20/2015 | 19.14 | 17.33 | 17.33 | 46.45% | 17.59% | 1.1048 |
06/26/2015 | 14.02 | 14.53 | 15.48 | 34.45% | 17.06% | 0.9652 |
09/08/2016 | 12.51 | 13.38 | 15.93 | 39.89% | 16.05% | 0.9353 |
12/10/2015 | 19.34 | 19.33 | 19.13 | 26.11% | 14.99% | 1.0008 |
06/10/2016 | 17.03 | 17.53 | 18.43 | 23.14% | 14.80% | 0.9718 |
Date | VIX Spot | VIX F1 | VIX F2 | VIX Return | VXX Actual Return | Ratio |
---|---|---|---|---|---|---|
08/17/2011 | 31.58 | 32.73 | 27.95 | 35.12% | 20.70% | 0.9649 |
11/08/2011 | 27.48 | 28.90 | 28.35 | 31.59% | 18.86% | 0.9509 |
06/26/2015 | 14.02 | 14.53 | 15.48 | 34.45% | 17.06% | 0.9652 |
09/08/2016 | 12.51 | 13.38 | 15.93 | 39.89% | 16.05% | 0.9353 |
12/10/2015 | 19.34 | 19.33 | 19.13 | 26.11% | 14.99% | 1.0008 |
06/10/2016 | 17.03 | 17.53 | 18.43 | 23.14% | 14.80% | 0.9718 |
10/31/2011 | 29.96 | 29.95 | 28.20 | 16.05% | 14.49% | 1.0003 |
02/22/2013 | 14.17 | 14.85 | 15.70 | 34.02% | 13.70% | 0.9542 |
09/12/2016 | 15.16 | 15.33 | 16.93 | 17.74% | 13.23% | 0.9892 |
02/18/2011 | 16.43 | 18.60 | 19.80 | 26.60% | 12.13% | 0.8833 |