QUOTE(Kaka23 @ Sep 10 2011, 10:00 PM)
How do you guys track your returns of all the trusts that you bought? Well.. it will be straight forward in excel file when you only buy then sell off all..
But how to track when you buy, but sell of partially or switch to other funds?
er.. also simple mar switching
STEP 1 - The SWITCH out of fund A
(units out * NAV switched = Sales) LESS (units out * average cost per unit)
Thus U know the net profits of "SELLING" off of Fund A's units
STEP 2 - The SWITCH into Fund B
Your cost would be the Sales above. Take this and divide by your units received and you'll have the average cost per unit
NOTE: I'm assuming U know how to use Excel

+ U do track you re-invested units growth
PS: Added this for your easy visualization
This post has been edited by wongmunkeong: Sep 10 2011, 10:28 PM