red is fun to poke, eh?

Actually u don't even need to put NAV price for the reinvested distributions. In fact, if u like to keep track of AVERAGE COST, putting NAV price might even mess it up.

Just manually insert the units received.

Let me paint u a scenario...

Let's say Fund ABC distributes dividend on 23-Jan-2015.
The dividend is reinvested on the same day.
And the share market for some funny reasons, was suspended that day. So, share prices all unchanged from 22-Jan-2015 closing prices.
Thus, the AGGREGATE VALUE for Fund ABC's holdings would remain the same as the previous day
Fund TOTAL assets (means total units in circulation x NAV price) unchanged, betul?

So, assuming RM1.0000 NAV on 22-Jan-2015
Distribution 10 sen per unit held
U hold 1000 units, thus total holding RM1,000

On 23-Jan-2015
NAV would go down to RM0.9000
U get 1,000 units x 10 sen / RM0.9000 = 111.11 units
You now hold 1,111.11 units
Holding value: 1,111.11 x RM0.9000 = RM1,000.00

Then when u update 23-Jan-2015 NAV price AND insert your additional units received, u get back the same portfolio value

Unker Looi start again, we take baseball bat steering lock wallop him

This post has been edited by Pink Spider: Jan 24 2015, 11:40 AM

Walaoeh

semakin canggih liao

I only check the main worksheet, by trying out different transactions

your charts I cannot/dunno check

When u switch out (all units) of Fund A and make a profit of RM1K, it will be recorded as a profit for Fund A (forever).

Let's say total switched out from Fund A is RM11K...

RM11K becomes your cost for Fund B, zero profit.

And the RM1K profit from Fund A is locked as PORTFOLIO profit.

polarzbearz if u are doing it right, there shouldn't be ANY rounding difference at all.

I also started my worksheet halfway, i.e. I created my worksheet, and then copy and paste all transactions from FSM's historical transactions. My units is exactly the same as FSM summary.

Maybe it's best that jutamind share his historical data with polarzbearz and let him do some testing?

Excel got 2 functions called "hide" and "grouping"

Normally I list my funds in alphabetical order.

After I've fully switched out from a fund, I'd move it from my "current holdings" list to "disposed holdings" list, and then group them all together and hide it, under 1 header - "disposed holdings" so that should I need to refer back any time, it's just a click away.

I think u can't match mine for volume

*check check*

274!

Err...

U cannot move the switched out funds to another worksheet, cos it will mess up your portfolio IRR calculation.

In order to calculate portfolio IRR, u need ALL transactions from Day 1 to-date in one place, on the same columns.

What u can do is to reorganise, group and hide.

This post has been edited by Pink Spider: Jan 25 2015, 12:16 PM

Aiyo, I'm on mobile, don't have polarzbearz's worksheet with me. I dunno what is column what and what

Just bear this in mind...

In order to have the correct portfolio IRR, u need EACH AND EVERY HISTORICAL TRANSACTIONS (the individual transaction value + date)! U can hide the rows, but u cannot delete ANY row.

This post has been edited by Pink Spider: Jan 25 2015, 12:33 PM

Wanna be lazy try tipu u also susah

Nah, here's how I treat disposed funds (see attached screenshot)

1. All the historical transactions are still there <- this is an ABSOLUTE MUST!
2. Last "summary" row for the fund, "total units" cell is zero because I've fully switched out
3. No more date, no more amount.
4. XIRR for that fund, covers rows 438 to 446
5. Profit/(loss) for that fund, also covers rows 438 to 446

I kept this fund's transactions totally hidden away from sight, but they're all there, covered by portfolio XIRR calculation and profit/(loss) calculation.

U cannot just keep 1 row with the profit/(loss) from that fund, portfolio XIRR calculation needs each and every transaction details (value + date).

This post has been edited by Pink Spider: Jan 25 2015, 12:51 PM

Or, u could chose to omit transactions from a galaxy far far away...u got Public Mutual transactions too? Or your UTs are all with FSM?

If FSM only, u could just copy and pasta everything from FSM historical transactions listing.

choi!

macamlah aku dan polarzbearz dah nak mati

Then u better omit them from your IRR worksheet

If dunno analyse profits, profits lower than FD rates, might as well dump all UTs and park in FD

I don't wanna answer u directly, give u an example...

Mr A invested since 2008...his profit is 20%
Mr X invested since 1998...his profit is 22%

Whose portfolio is more profitable? And by how much extent?

LOL

I kesian polarzbearz

Please elaborate more

What extent/things do we open your eyes?

iFast Singapore under Singapore Press group

iFast Malaysia is affiliate/associate of RHB Group

U can go see RHB Bank Berhad annual report under Group Structure chart

Interesting from CIMB Asia Pac Dynamite Income Ponzi 2.0 Dec-14 fact sheet:


http://www.cimb-principal.com.my/fund_pdf/...und_MYR_FFS.pdf

This post has been edited by Pink Spider: Jan 26 2015, 11:34 PM