An account has a single cash flow during the month, so there are two sub periods for performance to generate a TWRR. Although we can link the returns to get the full month return, it isn't as easy to derive a single weight that would maintain the integrity of a weighted average calculation. So, the preference is to calculate attribution for each sub period and link. However, we still face a scenario where many indices aren't available daily, so how do we get index return periodicity to match the account returns? This poses a number of questions:
- Can we assume linear performance for the benchmark?
- Do the cons of making assumptions around indexes outweigh the benefits? Should we be driven by the least common denominator? In other words if index data is only available monthly then attribution should only be produced monthly. This then means you need to explain the difference between the published return and attribution analysis.
- Can we manipulate portfolio weights so that we can use monthly analysis and linked returns?
However, if we employ a transaction-based approach, then we don't have to segment the month nor do we have to worry about index details for the sub periods. By using the beginning sector weights, plus weighted flows (just as we do with Modified Dietz) we can accomplish our objective. The returns, too, have to take into consideration the intra-month activity to ensure accuracy.