You can either:

1) Back-track your purchase date & purchase price and list them all in detailed row (line item 2) - doing this gives you your actual IRR rate, which is the main purpose of Pink's worksheet
2) enter it as lumpsum from today's date, but your IRR calculation only starts from now. I don't think this is the way

This will only have differences for IRR, and there won't be much diff for portfolio summary.

Should be ok gua

Cross checked my formula's against yours and its "usability" (to add new funds) before I published it
I think can post here . Myself / others using it can help also

Should be no issue, as I have now included pictured-guide on how to add new funds. Maybe will update again to show how to add "new row" in the fund (but its the same, copy and insert copied cells nia )

Tips: You can use the same method as how you "add new fund". But instead of selecting all the Transaction Cells (Line item 2) and Current Cells (Line Item 1);

select only Transaction Cells (Line Item 2) and copy it, and insert it by right clicking on the Current Cells (Line Item 1). It should populate above the calculated row; with formulas intact

That one I donno liao, summoning pink spider to help

I hasn't reached that stage (dividen) yet; so even myself do not know how to enter it into investment details (a.k.a Pink's Worksheet)

hohoho

U all sort it out first, when finalised already baru summon me to amend Post #1

i think no need to amend in Post#1.
I think, once polarzbearz amended the file in the Dropbox...the links in Post #1 never changed thus anyone download from post #1 will get the revised version.

i think after having read some post from user like woonsc and adele seems like need to do too many adding and inserting of lines and after that needs to make some changes to the formula...NOT that user friendly for old uncles and newbies....
anyway to put the "results" on the top lines and then format all those lines below it...so that can keep on continue input on the lines without having to insert lines?
just a thought..

RM50? One bucket beer dah habis

My Excel mana ada calculate cost punya

Mine is all like this:

Buy (100)
Buy (100)
Sell 50
Buy (500)
Distribution 0
Current value ~ total units x current NAV

What is your RM1,293.66?

FSM uses weighted average method to calculate cost

I never bothered with the cost, so don't ask me for specifics

=SUM(ABS(SUM(D26:D31)),F26:F31)

Why don't you try open both account? Most of the fund (Eq/Bond) in FSM SG do charge platform fee per quarterly while FSM MY do not have platform fee. Another main different is you can enjoy 0% SC from FSM SG via RSP to all funds while FSM MY charge 2% on equity fund.

Here's the latest promotion from FSM SG:
Let’s Sale Away – 0% Sales Charge On All Funds!
2015 is a year of many celebrations, where we celebrate our 15th year anniversary alongside Singapore’s 50th birthday. For the last week of January, enjoy some perks when you invest with us.
https://secure.fundsupermart.com/main/article/--10038

Released v1.3, can be downloaded via first post. Special thanks to Pink Spider again for this version - for all the formulas and sample scenarios to help me understand better

Change log:
p/s: as usual, let me know if spotted any errors ya

I diam diam je

choi!

macamlah aku dan polarzbearz dah nak mati