Certain overlapping sure got.

Eastspring GEM also has some HK/China and ASEAN stocks which Affin Hwang Asia Quantum and CIMB Dynamite Income might/can have.

But up to 40% of Eastspring GEM are exposed to "pure" EM markets like middle east, Africa, Emerging Europe, Russia, Latin America etc which the other 2 funds are not exposed to

jutamind u trying to build a portfolio?

Today Asian markets red red

Don't wait for Saturday 0.5% discount, top up now!

woonsc as requested, updated my spreadsheet with "more friendly" user guide.

Download link is still the same:



Download here >>> Polarzbearz's Portfolio Summary with Pinky's IRR Calculation
Make sure you read the instructions as many of the cells has formula in it. You can freely modify, update, or change it to suit your need (and even share with others if you don't mind )

Original credit goes to Pink Spider for the original worksheet (Pinky's Portfolio Worksheet with IRR Calculation)

And special thanks to Pink Spider and yklooi for inspiring: see post#795 and post#817

U have to!

The RM100 was profit for Fund A
The RM100 was profit for your portfolio

IRR is about the PAST, all transactions must be taken into account.
Done!

I asked fundsupermart few days ago, they claimed is system error , and will be reverted back to 2% . SO for those who RSP with 0.8 % --- congrats !

1. Noted

1. This one cannot automate apparently. Still figuring how how to let excel "auto update" the grouping
2. As explained by pinky, when we perform selling, we define how many units we are selling, not define how much cash we want to cash out. So, transaction amount effectively captures "Amount of Unit Sold", which must be a negative value when we are selling (Reduce number of units). This is also explained in the cell's explanation pop up

and lastly for the error; this is because you copied Entire Row; instead of carefully selecting the Table's Cells. You CANNOT copy entire row and paste it below. Must select it manually within the table's range.

errr which line? screenshot might help a bit here

Grey colour lines are the total lines right? Got other grey colour lines meh (except certain cells that are highlighted as they are formulas).

Those detailed lines will not have affect to the calculation, as long as transaction amount and unit price is 0 so can leave it here and update next time when got new entries.

The line 5, you can delete if you want to (no impact). But you can also leave it there so that it's easier for you to add new lines in the future, as long as Transacted Amount is zero, it won't be added to the units / value calculation.

If you don't mind, can you provide part of historical data from FSM vs. the excel sheet so that I can try to find the root cause? But nevertheless, you can always use the Manual Adjustment field in the Units (for purchase only).

Where do you see the difference? Is it in total (grey line); or one of the detail line?
If it's total line, check the total units' formula and make sure it have included all the rows (the formula might not capture the newly inserted row if the used insert method is different).
If it's detail line, the below example might help:

this one i not sure liao.

I made sure that the units calculation (in details row) is rounded to two decimals, so there should not be an issue (and since you mentioned that detailed lines unit are accurate). Even if there are issues with detailed row units, we can manually adjust it.

As for the total row, I just stick with the original formula (basic SUM formula) without changes.

If you're comfortable changing the Total Units formula, try this:

Change the original formula from (example)


to this formula (example, change the range to suit yours)


Can't really test it out cause I don't have much historic transactions with FSM yet.

But just to double confirm again - the detailed row's Calculated Unit is accurate, for every lines you recorded, yes?

when you enter -1.26 unit in column J, are you entering it in details row or total row?
--- if details row: what is the transaction type? buy/switchbuy; sell/switchsell; dividend; platform fee?
------- if buy/switchbuy: this should not be happening, make sure the formulas in column K are not overriden.

------- if others: unit adjustment is only applicable for purchased units because: (when we buy, rounding calculation of units differ from fund houses; but when we sell, we sell exactly X units after deducting redemption fee; and for dividend, we enter units gained directly so no adjustments are required; and for platform fee; we are only entering it as a cost in RM with no impact or relation with units)
--- if total row: currently Manual Unit Adjustment hasn't been enabled for the total row yet.

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?

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.

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!

Yup which is why I would like to check and see if there are other rounding issues, by comparing FSM data vs input into spreadsheet+calculations.
I've sent you a PM with my email address.

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.

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! U can hide the rows, but u cannot delete ANY row.