1) Sheet4 B38 should be portfolio value
2) Sheet4 Column B should equal investment detail column D
3) Also existing worksheet there’s a mistake. CIMB = E6, AMB Income Trust = D11. Different column la.

ABS is short for absolute. absolute amount, turn -ve to +ve. the intention of polarbear is to calculate your initial cost investment, the actual money invested, take the SC amount away. to calculate the 'entrance' value, which pinky did not have in his spreadsheet. anyway, best to pm polarbear. this is turning into an excel discussion.

also, part of the intention of the spreadsheet is to avoid you keying in too much info, just the relevant one which is price and investment amount. even the units doesn't need to be inserted manually by the user. though such intention results in alot of question asking and polarbear is still relatively unfamiliar with certain investment thingy...

Add transaction type “Unit Split”. Then units column, add another if. If(transaction type=”unit split”, unit manual adj,…)

This is the best way I can think of since unit split can come in different ratios.

Those who experience unit split, will have to manually key in additional units (as viewable from monthly statement by FSM)