QUOTE(dexk @ May 3 2016, 09:27 PM)
If you need more complex calculation for deposits/topups, withdrawals and distribution I find the easiest way is to use the XIRR formula in excel.
Are you asking me, or are you telling me ?
IMHO, it really depends on
1. what hes trying to achieve/compare/benchmark
2. what data he has available.
XIRR is useful if hes calculating cash flows, in the case of UT, the timing of his purchases, redemptions, distributions ie : performance of the "investor".
However, if he only has a statement, and has made multiple purchases, but really wants to compare the performance of the "manager", irrespective of his purchases and redemptions, the TWRR calculation would be a better choice.