I've got a portfolio with a mix of buy and total sell and some with a mix of buy and partial sell.
For the buy and total sell, a simple ROI calculation will work BUT given there are also a mix of buy and partial sell TWR seems to make sense.
However, the ROI and the TWR calculation aren't matching up?
Opening deposit = $1081.04
Full sale = $964.47
Earnt = $-116.57
ROI = -10.8%
Opening deposit = $2091.11
Full sale = $1746.55
Earnt = $-344.56
ROI = -16.5%
Combining both = ($-116.57 + $-344.56)/($1081.04 + $2091.11)
= -14.5%
Where-as a Time Weighted Return = ((1+ -10.8%) * (1+ -16.5%)) - 1
= -25.5%
What am I missing?
