go far far away you both

I want my dream girl only

Reduce your workload mar

I see everyone changing their dream girl avatar, then it's like time to update mine. So long already still wearing santa hat

I found the root cause (this happens when we have different locale setting. Example: my excel doesn't parse "RM 1,234.00" into Number 1234.00, it is treated as text string. But if we are using Malaysia Locale setting; RM 1,234.00 will be treated as numeric value 1234,00.

Working on it now

Released v1.1 of the Conversion Tool, can be downloaded via clicking here.

Change log:


woonsc you can try again and see if the problem persists

Tested on your sample data and working fine for me (excel 2013)

Do you have enough rows to "hold" those values? There's no formula in the first few columns, just formatting. Unless you dont have enough rows in the spreadsheet to hold the values (do it fund by fund, not one shot everything)

Which one? The amount in fund allocation sheet? Itu memang u need to manually maintain.

My spreadsheet not that smart to read the values automatically yet
But sekali u maintain with fixed reference (ie ='Investment Details'!$J$8), it'll auto update itself in the future (provided that you add new rows in the future using the right method)

Alamak!! That is a huge oversight on my side. Thanks so much woon for spotting it. I didn't even realize it as I was too focused on the formula on Portfolio Summary instead.

This can be fixed by changing
Eff. EQ: =$B$2/$B$56*E2 into =$B2/$B$56*E2
Eff. FI: =$B$2/$B$56*E3 into =$B2/$B$56*E3
Eff. CS: =$B$2/$B$56*E4 into =$B2/$B$56*E4

So sorry guys
Will push the update when I get home tonight, can't do it in office (dropbox is blocked)

It's already existing & included in every release (via LYN); as well as CHANGELOGS in the excel spreadsheet itself

If you use my suggested method to {Add new fund} or {Add new rows to existing fund}, you DON'T have to touch the formula at all (MUST FOLLOW EXACT STEPS) - i.e. paste above certain row.

If you using manual conventional way to "Insert New Row" - that's where you gotta becareful and look at those formulas.

I really recommend all of you whom are not familiar with excel to use the copy-and-paste method. It's more straightforward, and less prone to errors.

Regions chart is in my plan, but was pushed down to lowest priority due to other stuff

If you don't mind, maybe you can help me with tagging countries to regions; and how "specific" do we need to go on regions (i.e. ASEAN, xxx asia, etc) or just a simple ones like " Asia Pacific | European Union | Americas | Others" ?

I'm honoured

Released v1.6 for the Spreadsheet, can be downloaded via clicking here. So sorry for the quick-version changing but this one I must push it out, due to a critical bug in the formula (when copy&paste) as discovered by woonsc. I'll slow down on the releases if there are no more bugs spotted (hopefully not )

So sorry for this mishaps

Change log:


Please do continue to help to spot & destroy the bugs, as I might have really missed things out when developing / testing it

Itu too many la, not regions liao, some is already country-specific.

I'm thinking to achieve it without doing major "renovation" to the core structure; something like utilising existing country list and "group" them in their respective region.

Example - by grouping existing country list into more general regions:

[/code]

I think you can copy the allocation only, but you'll need to do verifications after you copy. Make sure you copy the entire table, do not delete the worksheet or otherwise the Chart sheet will definitely have !#REF error.

The new version with new chart etc. won't be out so fast

I wanna rest

For now I'll only focus on fixing bugs and make this version stable

This post has been edited by polarzbearz: Feb 4 2015, 08:28 PM

20 hours mana cukup. at least 1 month (except got bugs lar)

my portfolio ROI & IRR macam super-inflated and fake one, because of short term (started mid jan)

ROI 158% or IRR 158%?

XIRR is effectively IRR taking into consideration the factor of "time".

You can easily customize the spreadsheet
That's the reason I didn't password protect those worksheets and open it for everyone to edit; I only password protect the "CHANGELOGS" to prevent frauds

but like pink spider said, calculating is ROI is very tricky - how you define "Cost of Investment"? do you include funds received from selling the units OR should you exclude them? it's not as straightforward to calculate ROI as compared to ROI for other stuff -i.e. one time purchase, then sell it off at a go

an example would be:

Invest RM1000, zero service charge, NAV at RM0.50; total holdings 2000 units; current portfolio value = RM0.50 x 2000 = RM1000

Sell 1000 units at RM0.55 NAV, gained RM550 from it (actual profit = RM50); current portfolio value = RM0.55 x 1000 = RM550 (another paper profit of RM50); total profit = RM100

so RM100 / RM1000? or RM100 / RM500? technically speaking your current investment is only RM500, since you cashed out the another half already.




I might be wrong tho

This post has been edited by polarzbearz: Feb 5 2015, 01:27 PM