Dollar-Volume-Weighted Category Returns
One of the problems with using a wide range of ETFs and CEFs to calculate daily category return is that some ETFs and many CEFs are not very liquid, trading very few dollars in a day. The less liquid these funds are, the more likely they are to deviate away from the “true” underlying value, resulting in returns that are frequently higher and lower than the real market category under the microscope.
To combat this, I've introduced dollar-weighted calculations. This process works in the following way:
-
For each fund, calculate the total number of dollars traded over the time interval, that is, the sum of the closing price times the volume for each day.
-
Calculate the sum of all dollars traded over the time interval in the entire category.
-
For each fund, calculate a weight based on its percentage of dollars traded relative to the entire category.
-
The final category return is the sum of the product of each fund's weight and actual return.
This gives us a number that more accurately represents what the actual dollar-driven return on the category was. Here's the current results:
| Category | Day | Week | Month | YTD | Mil. Dol. Traded | Week Corr. to SPY |
| Latin America | -1.15% | 0.22% | 2.14% | 10.86% | 9 | 88.84% |
| Emerging Markets | -0.97% | -0.10% | 1.47% | 5.64% | 68 | 62.89% |
| MSCI | -0.86% | -0.89% | 0.72% | 11.16% | 110 | 94.35% |
| Small Cap | -0.73% | -0.87% | -0.19% | 5.73% | 4 | 78.82% |
| Real Estate | -0.73% | -0.37% | 0.61% | 2.75% | 10 | NaN |
| Russia | -0.65% | -2.50% | -7.62% | -13.50% | 4 | 95.38% |
| Transports | -0.63% | -0.84% | 0.50% | 10.22% | 59 | 63.86% |
| Asia | -0.49% | 0.06% | 1.28% | 9.03% | 3 | 87.13% |
| Commodities & Resources | -0.45% | -1.44% | -1.65% | 9.47% | 21 | 78.48% |
| China | -0.40% | 1.89% | 1.40% | -4.78% | 74 | 88.51% |
| Europe | -0.40% | -2.01% | -1.51% | 3.43% | 7 | 85.16% |
| Biotech | -0.34% | -2.24% | 0.63% | 7.24% | 22 | 95.10% |
| Retail | -0.34% | -1.10% | -2.76% | 2.25% | 97 | 65.15% |
| Japan | -0.29% | -0.98% | -2.29% | 0.03% | 22 | 91.78% |
| Mid Cap | -0.24% | -0.21% | 2.18% | 10.67% | 19 | 87.05% |
| Large Cap | -0.19% | -0.40% | 2.07% | 6.75% | 1 | 91.42% |
| Call/Write | -0.18% | -0.44% | 0.72% | 5.46% | 1 | 0.99% |
| Consumer Goods & Services | -0.17% | -0.97% | 0.11% | 5.72% | 4 | 70.14% |
| Convertible | -0.13% | -0.13% | 1.04% | 3.11% | 2 | 33.22% |
| Healthcare | -0.12% | -1.23% | 1.09% | 8.92% | 5 | 76.34% |
| Dividend | -0.07% | -0.24% | 1.89% | 5.59% | 4 | 87.56% |
| Energy | 0.04% | 0.28% | 2.36% | 16.80% | 61 | 82.74% |
| Currency | 0.08% | 0.04% | 0.39% | 3.97% | 2 | 59.56% |
| Infrastructure | 0.32% | 0.80% | 4.53% | 17.33% | 3 | 76.36% |
| Utilities | 0.38% | -0.29% | 1.95% | 10.00% | 7 | 66.87% |
| Short | 1.17% | 0.67% | -3.04% | -8.28% | 34 | -91.54% |
- Michael J Bommarito II's blog
- Add new comment
- 554 reads
Recent comments
4 weeks 5 days ago
9 weeks 2 days ago
9 weeks 3 days ago
11 weeks 6 days ago
12 weeks 12 hours ago
12 weeks 5 days ago
14 weeks 1 day ago
16 weeks 56 min ago
18 weeks 21 hours ago
19 weeks 4 days ago