How Does VXX’s Daily Roll Work?
Vance Harwood | Jan 20, 2015 02:47AM ET
All volatility Exchange Traded Products (ETPs) use indexes that track a mix of two or more months of the VIX futures Calculating this mix is not trivial and has resulted in a lot of bleary eyes—including my own. My intent with this post is to help you understand, and if you desire accurately compute the key indexes used in iPath S&P 500 (ARCA:VXX) Vix Short Term Fut and other short term volatility funds using Excel or similar tools.h3 Why do we need a roll anyway?/h3
If we could directly buy the VIX none of this would be necessary. Unfortunately no one has figured a cost effective approach so we are forced to use the next best thing—VIX Futures. Like options, VIX futures have fixed expiration dates so volatility indexes need a process of rotating their inventory of futures in order to have consistent exposure to volatility. This rotation process is evident in the open interest chart below—the next to expire futures being closed out and the next month of futures being opened.
Indexes and Funds—are different things
Before we dive into the details of how these issues are dealt with, I’d like to address one source of confusion. ETP’s are not obligated to follow the approach detailed in the indexes. They are allowed to use other approaches (e.g., over-the-counter swaps) in their efforts to track their indexes. When ETPs are working properly, their prices closely track the index they specify in their prospectus minus their fees that are deducted on a daily basis.
Because indexes are theoretical constructs they can ignore some practical realities. For example they implicitly assume fractional VIX futures contracts exist and that the next day’s position can be put in place at market close—even though calculating that position requires market close information. I’m sure these issues cause headaches for the fund managers, but to their credit the funds usually closely track their index.
h3 The Index Calculation/h3The details for the index (ticker VXX’s prospectus , pages PS-21 through PS-22. The math is general enough that it covers both the short term index that VXX uses and the midterm index VXZ uses—which adds to its complexity. The equations use Sigma (?) notation, which probably makes it challenging for people that haven’t studied college level mathematics. I will present the math below using high school level algebra. Except for interest calculations all references to days are trading days, excluding market holidays and weekends.
Get The News You Want
The short term volatility indexes used by all USA volatility ETPs utilize the same roll algorithm—at the end of each trading day they systematically reduce the percentage of the overall portfolio allocated to the nearest to expiration contracts (which I call M1) and increase the number of the next month’s contracts (M2).
The mix percentages are set by the number of trading days remaining on the M1 contract and the total number of days it’s the M1 contract (varies between 16 and 25 days). So if there are 10 days before expiration of the M1 contract out of a total of 21 the mix ratio for M1 will be 10/21 and 11/21 for M2. At close on the Tuesday before the Wednesday morning M1expiration there’s no mix because 100% of the portfolio is invested in M2 contracts.
It is important to understand that the mix is managed as a portfolio dollar value, not by the number of futures contracts. For example, assume the value at market close of a VIX futures portfolio was $2,020,000, and it was composed of 75 M1 contracts valued at 12 and 80 M2 contracts at 14. To shift that portfolio to a 9/21 mix for M1 and 12/21 for M2 you should take the entire value of the portfolio and multiply it by 9/21 to get the new dollar allocation for M1, $865,714 (72.14 contracts) and 12/21 times the entire portfolio value to get the dollar allocation for M2, $1,154,286 (82.45 contracts).
Value weighting gives the index a consistent volatility horizon (e.g. 30 calendar days)—otherwise higher valued futures would be disproportionally weighted.
This next section is for people that want to compute the index themselves. Yes, there are people that do that. If you are interested in the supposed “buy high, sell low” theory of roll loss you should check out the “Contango Losses” topic at the bottom of this post.
h3 The Variables/h3Lower case “t” stands for the current trading day, “t-1” stands for the previous trading day.
The index level for today ( IndexTRt ) is equal to yesterday’s index (IndexTRt-1) multiplied by a one plus a complex ratio plus the Treasury Bill Return TBRt. The index creators arbitrarily set the starting value of the index to be 100,000 on December 20th, 2005.
The number of trading days remaining on the M1 contract is designated by “dr” and the total number of trading days on the M1 contract is “dt.”
M1 and M2 are the daily mark-to market settlement values, not the close values of the VIX futures. The CBOE provides historical data on VIX futures back to 2004 here .
h3 The Equations/h3When dr is not equal to dt:
When dr = dt (the day the previous M1 expires):
Yes, this equation could be simplified, but then it wouldn’t fit as nicely into the equation below which uses a little logic to combine both cases.
The equation assumes that the entire index value is invested in treasury bills.
h3 Contango Losses/h3- An interesting corner case occurs when you assume that the M1 and M2 prices are completely stable and in a contango term structure for multiple days—for example, M1 at 17 and M2 at 18. In that situation the equation simplifies to:
- This special case illustrates that there is no erosion of the index value just because it’s selling lower price futures and buying higher priced futures—in fact it goes up because of T-bill interest. It’s the equivalent of exchanging two nickels for a dime—no money is lost. For more on this see: The Cost of Contango—It’s Not the Daily Roll .
Trading in financial instruments and/or cryptocurrencies involves high risks including the risk of losing some, or all, of your investment amount, and may not be suitable for all investors. Prices of cryptocurrencies are extremely volatile and may be affected by external factors such as financial, regulatory or political events. Trading on margin increases the financial risks.
Before deciding to trade in financial instrument or cryptocurrencies you should be fully informed of the risks and costs associated with trading the financial markets, carefully consider your investment objectives, level of experience, and risk appetite, and seek professional advice where needed.
Fusion Media would like to remind you that the data contained in this website is not necessarily real-time nor accurate. The data and prices on the website are not necessarily provided by any market or exchange, but may be provided by market makers, and so prices may not be accurate and may differ from the actual price at any given market, meaning prices are indicative and not appropriate for trading purposes. Fusion Media and any provider of the data contained in this website will not accept liability for any loss or damage as a result of your trading, or your reliance on the information contained within this website.
It is prohibited to use, store, reproduce, display, modify, transmit or distribute the data contained in this website without the explicit prior written permission of Fusion Media and/or the data provider. All intellectual property rights are reserved by the providers and/or the exchange providing the data contained in this website.
Fusion Media may be compensated by the advertisers that appear on the website, based on your interaction with the advertisements or advertisers.