Hi all, want to ask some advice. I'm using Polarbearz spreadsheet and keying in all my FSM transaction as of date. No issues with buying and selling transaction. but when comes to dividend from the Fund, the number of units does not tally with the amount.

For eg, 18 Apr 2017, CIMB fund gave a div of RM 131.62 @ 0.3393 NAV price. My transaction history shows 387.91 units added. I keyed in the transaction type as Dividend, Transaction Amt = RM 131.62, NAV = 0.3393 but the final unit comes out as 131.62 units.

Should i use the Transaction manual adj to change the units qty?

ok.. that works...

cos i saw in the notes saying not to manually change anything in that column.

with equity markets rising above pre-crash period... do u guys think this is due more towards fluff & easy liquidity instead of actual common sense? all my funds are in +15 to +20 return so far... am thinking of paring down 50% and hold in the CMF first... is this advisable?

somehow, all readings should be showing towards a slow economy, but market just goes against this..