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
- 1996 reads
Recent comments
14 weeks 4 days ago
19 weeks 3 days ago
23 weeks 2 days ago
29 weeks 15 hours ago
33 weeks 3 days ago
43 weeks 2 days ago
44 weeks 3 days ago
1 year 1 day ago
1 year 6 weeks ago
1 year 24 weeks ago