Backtest of VXX Volatility ETN From 2004 Including Yearly Fees

Friday, February 28th, 2014 | Vance Harwood

Volatility based Exchange Traded Funds and Notes (ETF / ETN) have only been on the market for a few years (see volatility tickers for the full list of USA based funds).  The oldest one, Barclays’ VXX only started trading in late January 2009.   Because of their relative youth we don’t have actual trade data on how they would have performed through critical periods—for example the 2008/2009 crash.  Fortunately the CBOE provides historical data starting in March 2004 for the VIX futures that underlie the VXX, so it’s possible to objectively simulate how it would have performed from that point forward.

Some aspects of the VXX simulation are tricky.  For example some VIX future expiration months did not trade in the 2004 to 2008 time frame so those values need to be interpolated / extrapolated.  The prospectus does not spell out whether closing or settlement values of the futures are used for the index calculations (they use settlement values), and the calculation using the daily rolled and rebalanced futures is not straightforward.  Even the final step, figuring out the daily fees is not a trivial exercise.

The chart below shows the reverse split adjusted results (as of Dec 2013).


Clearly VXX would have performed horribly over the 2004 to 2013 time frame with a brief respite in 2008/2009.  If you had invested $1000 in VXX in March 2004 you would now have $1.80 left of your initial investment—a 99.8% decline.   The long volatility funds have a structural tendency to decline because they hold VIX futures that are historically in contango 70% to 80% of the time, for more on this process see How Does VXX Work? and The Cost of Contango.

If you are interested in purchasing the results of the VXX  simulation back to March 2004  I have made a spreadsheet available for purchase (see bottom of post) that includes the simulated values with the annual fee (0.89%).  The maximum deviation in my results from the Barclays’ published closing indicative values since the product started trading is less than +-0.04%.

The chart below shows VXX’s performance (in black) relative to a few other volatility based Exchange Traded Products.


Among the long funds, the 2X leveraged short term TVIX from VelocityShares fares even worse than VXX, declining 99.99999%.  Barclays’ medium term VXZ only declines 78%.  The daily inverse funds do better with VelocityShares’ medium term ZIV going up 43% and its short term XIV going up 13 fold—however not without some serious dips along the way.

Earlier in this post I mentioned that computing VXX’s fee was surprisingly difficult.   The appropriate equation is not present in any ETP prospectus I have seen—instead you are treated to prose that would make an IRS agent proud.

Exchange Traded Products typically state their fees on an annual basis (e.g., 0.89%), but in practice they deduct a fee each day from the assets under management.   In computing the fees it’s tempting to start with the daily value of the underlying index (SPVXSTR in the case of VXX) but the actual calculation starts with the final indicative value of the ETP from the previous trading day.  It multiplies the previous value by the index gain at close for the current day (one if it is a non-trading day) and then applies the fee.  The applicable formula is:


While it’s interesting to simulate how a security would have behaved in the past it’s only one of many possible outcomes.  If VXX had existed in 2004, it’s likely the VIX futures that underlie it would have been affected—at least in small ways.   Looking forward the uncertainties multiply—there’s no guarantee that VIX futures will behave the same way through upcoming corrections and market crashes and with the open interest on VIX futures growing 40% a year we can anticipate that someday they, and indirectly VXX will be influencing the behavior of the S&P 500 itself.


More information on the VXX simulation spreadsheet see this readme.

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 Return to Six Figure Investing link.    Click on this link to reach the page where can download the spreadsheet.  Please email me at if you have problems, questions, or requests.

Backtests for Popular Long & Short Volatility Exchange Traded Products

Friday, February 28th, 2014 | Vance Harwood

I have generated the end of day trading day values for the most  popular long and short volatility Exchange Traded Products (ETPs) for March 26th, 2004 through January 27th, 2014

  • TVIX    VelocityShares Daily 2x VIX Short-Term ETN
  • UVXY  ProShares Ultra VIX Short-Term Futures ETF
  • VXX     Barclays S&P 500 VIX Short-Term Futures ETN
  • VXZ     Barclays S&P 500 VIX Mid-Term Futures ETN
  • XIV     VelocityShares Daily Inverse VIX Short-Term ETN
  • ZIV     VelocityShares Daily Inverse VIX Medium-Term ETN
  • SVXY  ProShares VIX Short-Term Futures ETF
  • VIXY  ProShares  Short VIX Short-Term Futures ETF

These ETP histories are required if you want to backtest various volatility strategies through the quiet times from 2004 to 2007, or the 2008/2009 crash.  The chart below shows the simulated values with a logarithmic vertical axis so that you can see a reasonable amount of information for each fund.



The table below shows how much $1000 invested in each of these funds on March 26th, 2004 would have been worth on October 15th, 2013:
Symbol $ Value
TVIX $0.00012
UVXY $0.00014
VXX $2.10
VXZ $217
ZIV $1565
XIV $17865


The algorithms for generating these ETPs values are documented in the prospectuses for the various volatility ETNs and ETFs.    Barclays’ VXX/VXZ fund prospectus is a good example.   See Volatility tickers for the current universe of  USA based volatility ETPs and their associated reference indexes.    The futures settlement data required for these calculations is available on this CBOE website—in the form of 100+ separate spreadsheets.  To make the calculation of the indexes underlying the ETPs tractable  I created a master spreadsheet  that integrates the futures settlement data into a single sheet.  See this post for more information about that spreadsheet.

My simulated values very closely track the published indicative values (IV) of the funds except for VelocityShares’ TVIX—which has had severe tracking problems since early 2012.  Barclays provides a full set of IV values for VXX and VXZ—my simulation tracks them within +-0.04% and +-0.025% respectively.   Sampled IV values for the other funds give error terms of  +-0.2% for Proshares UVXY,  and for VelocityShares XIV and ZIV +-0.2% and +- 0.01% respectively.   My TVIX simulation tracks sampled IV values within +2%/-4%.

These ETP prices reflect the contribution of 91 day treasury bills on their overall performance.   Thirteen week Treasuries yields averaged 0.05% in 2013,  but in February 2007 they yielded over 5%— things have changed a bit…   The simulated ETP values do  include applicable fees which vary from fund to fund.   The fee calculation is surprisingly difficult.  For more on that see Backtest on VXX Including Annual Fees

I am making these 6 simulation spreadsheets (values only, no formulas)  available for purchase, individually, or as a complete package. The VXX package is also available here.   If you cannot see purchase information immediately below then please click this link to the stand-alone post and look at the bottom of the page.

For more information on the spreadsheets see readme.

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 “Return to Six Figure Investing” link.    Click on this link to reach the page where can download the spreadsheet.  Please email me at if you have problems, questions, or requests.

Next VXX Reverse Split—April 2015?

Wednesday, February 12th, 2014 | Vance Harwood

For a security doomed to decrease in value over time Barclays’ VXX does amazingly well.  Its volume averages over 29 million shares per day and its assets under management have stayed above $1.0 billion for the last couple of years.  Not bad for a product that has averaged a 64% annual loss since its inception in January 2009.

It was only 13 months between the last two reverse splits, but that was a strong bull market phase with very little volatility—which is especially bad for volatility products like VXX.  I’m expecting volatility to kick up some in the next year, so I’m estimating it will take 18 months this time around before Barclays’ needs to reverse split this product again.

According to its prospectus Barclays can reverse split VXX any time after it closes below $25 and that reverse splits will always be at a four to one ratio.

Event Dates Reverse Split Ratio Inception / close price right before reverse split (split adjusted)  Months since inception /last split
Inception 30-Jan-2009 100 (6,400)
1st Reverse Split 8-Nov-2010 4:1 13.11 21
2nd Reverse Split 4-Oct-2012 4:1 8.77 23
3rd Reverse Split 8-Nov-2013 4:1 12.84 13
4th Reverse Split April 2015 (est) 4:1 13.00 (estimated) 18 (estimated)

The first and second splits of VXX occurred after about 22 months, but 2012 did not provide a volatility bump like 2010 and 2011, so the 3rd reverse split was only 13 months after the 2nd one.   The chart below, both log and linear scaled, shows VXX’s sordid split adjusted price history.

VXX split adjusted

Given its horrid track record, it’s fair to ask why people keep investing in VXX.  I had assumed it was mostly retail investors, but a recent quarterly Nasdaq report indicates otherwise:



Over fifty percent of VXX’s ownership (as of 30-Sept-13) was institutional.   Barclays is number one on the list, with  5 million shares outstanding.  They of all people should know this ETN is a dog.

A closer look at the institutions and activity on this list (e.g., Goldman Sachs, Susquehanna, UBS, Deutsche Bank), suggests that most of these holdings are transient, related to the activities of Exchange Traded Product (ETP) issuers, market makers, and Authorized Participants (AP).  These are the people that facilitate / use arbitrage to keep ETP prices close to their index values—and make money in the process.  For more on this see this very good IndexUniverse article.

I suspect retail investors on the other hand are trying to hedge their equity holdings with VXX because it is one of the few securities that reliably goes up when the market is panicking.  Unfortunately this strategy rarely works well.  Unless your timing is very good  owning enough VXX to effectively hedge your portfolio is prohibitively expensive.

For more see:

How Does VXX Work?

Thursday, July 17th, 2014 | Vance Harwood

VXX and its sister fund VXZ were the first Exchange Traded Notes (ETNs) available for volatility trading in the USA.  To have a good understanding of what VXX is ( full name: Barclays Bank PLC iPath S&P 500 VIX Short-Term Futures ETN) you need to know how it trades, how its value is established, what it tracks, and how Barclays makes money running it.

How does VXX trade? 

  • For the most part VXX trades like a stock.  It can be bought, sold, or sold short anytime the market is open, including pre-market and after-market time periods.  With an average daily volume of 50 million shares its liquidity is excellent and the bid/ask spreads are a penny.
  •  It has a very active set of options available, with five weeks’ worth of Weeklys and close to the money strikes every 0.5 points.
  • Like a stock, VXX’s shares can be split or reverse split— 4:1 reverse-splits are the norm and can occur once VXX closes below $25.  For more on VXX reverse splits see this post.
  • VXX can be traded in most IRAs / Roth IRAs, although your broker will likely require you to electronically sign a waiver that documents the various risks with this security.   Shorting of any security is not allowed in an IRA.

How is VXX’s value established?

  • Unlike stocks, owning VXX does not give you a share of a corporation.  There are no sales, no quarterly reports, no profit/loss, no PE ratio, and no prospect of ever getting dividends.  Forget about doing fundamental style analysis on VXX.
  • The value of VXX is set by the market, but it’s closely tied to the current value of an index (S&P VIX Short-Term Futurestm) that manages a hypothetical portfolio of the two nearest to expiration VIX futures contracts.  Every day the index specifies a new mix of VIX futures in that portfolio.  For more information on how the index itself works see this post or the VXX prospectus.
  • The index is maintained by the S&P Dow Jones Indices and the theoretical value of VXX if it were perfectly tracking the index is published every 15 seconds as the “intraday indicative” (IV) value.  Yahoo Finance publishes this quote using the ^VXX-IV ticker.
  • Wholesalers called “Authorized Participants” (APs) will at times intervene in the market if the trading value of VXX diverges too much from the IV value.  If VXX is trading enough below the index they start buying large blocks of VXX—which tends to drive the price up, and if it’s trading above they will short VXX.  The APs have an agreement with Barclays that allows them to do these restorative maneuvers at a profit, so they are highly motivated to keep VXX’s tracking in good shape.

What does VXX track?

  • Ideally VXX would track the CBOE’s VIX® index—the market’s de facto volatility indicator.  However since there are no investments available that directly track the VIX Barclays chose to track the next best choice: VIX futures.
  • Unfortunately using VIX futures introduces a host of problems. The worst is horrific value decay over time.  Most days both sets of VIX futures that VXX tracks drift lower relative to the VIX—dragging down VXX’s value at the average rate of 5% per month (65% per year).  This drag is called roll or contango loss.
  • Another problem is that the combination of VIX futures that VXX tracks does not follow the VIX index particularly well.  On average VXX moves only 55% as much as the VIX index.
  • Most people invest in VXX as a contrarian investment, expecting it to go up when the equities market goes down.  It does a respectable job with the VXX averaging percentage moves -2.94 times the S&P 500, but 16% of the time VXX has moved in the same direction as the S&P 500.  The distribution is shown below:

VXX% moves / SPX% moves

VXX% moves / SPX% moves (SPX daily moves of less than +/-0.1% are excluded)


  • With lethargic tracking to the VIX, erratic tracking with the S&P 500 and heavy price erosion over time, owning VXX is usually a poor investment. Unless your timing is especially good you will lose money.  For a backtest of VXX starting in 2004, see this post.

How does Barclays make money on VXX?

  • Barclays collects a daily investor fee on VXX’s assets—on an annualized basis it adds up to 0.89% per year.  With current assets at $1.15 billion this fee totals around $10 million per year.  That’s certainly enough to cover Barclays’ VXX costs and be profitable.  But even if it was all profit it would be a tiny 0.1% percent of Barclays’ overall net income— which was $10.5 billion in 2012.
  • From a public relations standpoint VXX is a disaster.  It’s frequently vilified by industry analysts and resides on multiple Worst ETF Ever lists.  You’d think Barclays would terminate a headache like this or let it fade away, but they haven’t done that even though 3 reverse splits—which suggests that Barclays is making more than $10 million a year with the fund.
  • Unlike an Exchange Trade Fund (ETF), VXX’s Exchange Traded Note structure does not require Barclays to specify what they are doing with the cash it receives for creating shares.  The note is carried as senior debt on Barclays’ balance sheet but they don’t pay out any interest on this debt.  Instead they promise to redeem shares that the APs return to them based on the value of VXX’s index—an index that’s headed for zero.
  • If Barclays wanted to fully hedge their liabilities they could hold VIX futures in the amounts specified by the index, but they almost certainly don’t because there are cheaper ways (e.g., swaps) to accomplish that hedge.  If fact it seems likely Barclays might assume some risk and not fully hedge their VXX position. According to IndexUniverse’s ETF Fund Flows tool, VXX’s net inflows have been $5.99 billion since inception in 2009—and it is currently worth $1.15 billion.  So $4.8 billion dollars has been lost by investors and an equivalent amount by Barclays if they were hedged at 100%.   If they were hedged at say 90% they would have cleared a cool $480 million over the last 4 years in addition to their investor fees.  Barclay’s affection for VXX might be understandable after all.

VXX is a dangerous chimeric creature; it’s structured like a bond, trades like a stock, follows VIX futures, and decays like an option.  Handle with care.

For more information:

When You Think Your Exchange Traded Fund is Broken…

Monday, June 3rd, 2013 | Vance Harwood

When you thing your ETF/ETN is broken...
Frequently I see people complaining that their Exchange Traded Fund (ETF) or Exchange Traded Note (ETN) is broken. Occasionally they’re right, but most of the time they’re not.  Before complaining, here are some things to look at:

  1. Are you looking at the right index?
    • All Exchange Traded Products (ETPs) track an index, which is identified in their prospectus, and in the fund’s fact sheet.   Don’t assume what the index is.  For example, the index that VXX tracks is not the CBOE’s VIX® , and UVXY the 2X volatility fund is not designed to track 2X the VIX.
    • None of the volatility funds track the VIX, they all use other indexes, because the VIX itself is not investable.  Some funds (e.g., UVXY, CVOL) do a semi-decent job of tracking the VIX in the short term, but nobody does a good job in the medium to long run.  In fact it’s a killing field.
    • Investigate the index once you’ve determined what it is.  It’s often not easy; sometimes even getting quotes on indexes is hard.  But similar to the hunter’s credo of eating what they kill, investors should understand what they trade.
  2. Is the fund leveraged/geared (e.g., 2X, 3X), or an inverse fund?
    • Leveraged or inverse funds typically do a good job of delivering their target performance on a daily basis, but usually fall far short with longer time frames.  The reason is compounding error, or path dependency.  It erodes the value of these funds in choppy markets.
    • For example if a non-leveraged fund (e.g., SPY) goes up 10% one day and down 9.09% the next it ends up even.   However the 2X fund (SSO) and the inverse fund (SH) both end up down 1.8%
      • 2X Fund: (10*(2*10%)=12, 12*(2*-9.09%) = 9.82
      • -1X Fund: (10* (-10%) =9,  9 *(+9.09%) = 9.82
  3. What are the timestamps of the quotes you are looking at?
    • Unless your fund is very active the quote you’re using might be older than you think.  For example the fund’s closing value might reflect a trade that happened hours before market close.  If you look at an intra-day chart of your fund including volume you should be able to see when the trades occurred and the quotes updated.  Typically the intraday indicative value (“IV”) quote is a more accurate way of getting the actual fund value. It’s updated every 15 seconds during market hours.
    • The IV quote tickers are not standardized.  Yahoo finance uses a “^” prefix and a “-IV” suffix to get the IV value (e.g., ^VXX-IV).  For more on IV quote symbols see Trading ETFs Without Getting Fleeced.
  4. Are the markets you’re comparing closing at the same time?
    • VIX futures markets at the CBOE Futures exchange trade for 15 minutes after the equities markets close.   The volatility ETPs are based on volatility indexes that are based on futures settlement values.  Eli from VIX Central points out that these settlement values can come out well after 4:15.  The final IV update for the day appears to reflect these late settlements—giving us the real closing value for the volatility funds.
  5. Is the trading value of the funds diverging significantly from its index or IV value?
    • If this is the case, your fund might be broken, but before we pursue that there are a couple thing to check:
      • Are the markets for the underlying assets closed (e.g., Asian or European stocks)?  If so those indexes can’t update so some divergence during USA trading hours should be expected.
      • Are the securities for the underlying assets illiquid or rarely traded (e.g., high yield corporate bonds)?  If so the trading value might reflect the market’s estimation of what those assets are worth, rather than the last trade, or published bid/ask quotations.

If you’ve checked through all the items above and things still look wrong your fund may indeed be broken.  Historically the only pathology for ETF/ETNs is to have their share creation process halted or somehow limited.  Some of the stated reasons for doing this are:

  1. Market closures (e.g., the Egyptian stock market closed for 2 months in 2011: EGPT, )
  2. Regulatory hurdles, where permission to issue new shares is delayed UNG, UNL, DNO
  3. Issuer “internal limits on the size of ETNs”, TVIX
  4. Commodity  position limits, where the exchanges won’t allow the funds to accumulate more contracts UNG
  5. Self-imposed market cap limits AMJ

In all these cases the share redemption process has been left intact.  In practice if share creation is stopped and redemption is working the ETP’s price can rise higher than the index, but not drop significantly lower than the index.   Both UNG and TVIX were expensive object lessons for the people that didn’t understand this.

NYSE EURONEXT has a good webpage that lists all the funds that currently have suspended or put limits on share creation.

Credit Suisse’s TVIX has restarted limited share creation processes, but its requirements are so expensive the market makers still allow the fund to climb as much as 15% higher than its IV value—I consider that broken.