!!!THIS IS A PRE-RELEASE TESTING VERSION!!! The main objective is to collect feedback/suggestions before a stable version is released.
sample report

Change log (high level) :
- supports FSM Malaysia, FSM Singapore, and FSM Hong Kong (note: sg not tested)
- supports Cross currency transaction, cross currency NAV, and group currency consolidated reporting. Max 10 currency for now. MYR is the base currency.
- support dynamic decimal places calculation (FSM my uses 2 decimal, HK uses 4 decimal)
- leveraged pivotchart for most part to ensure maximum compatibility / easy to use / flexibility
- updated charts

For those that are curious / good with excel / want to help out, please see below the latest excel (pre-release) with incomplete functionalities. Some of them are still being developed (i.e. MAC compatibility within same excel; auto currency table update; codes tweaking/cleaning, etc.) so do expect some bugs in this version. The conversion tool is also updated to cater to this new excel version so that you can either (a) import from FSM Malaysia or (b) import from previous stable excel (v2.2)

Since this is a pre-release test version, only the conversion tool has complete step-by-step instruction/guides... for now.
LYN Portfolio IRR calculator - pre-release - 3.0-alpha.xlsm
polarzbearz Spreadsheet Conversion Tool - FSM-to-Excel, Excelv2.2-to-v3.0.xlsm
One of the biggest manual activity is to update the 'fund snapshot date' due to an oversight in previous version. But good thing is, albeit painful in the beginning, you will retain all of your historical data instead of starting from scratch. The problem in previous v2.2 design is the inconsistencies of date usage.
- In "Portfolio Snapshot", it is capturing the date when snapshot happens
- but in the "Fund Snapshot", it is capturing the date when the fund was last updated in FSM.

This may give some problem in the charting section. Below are the simplified steps:


!!!EXPECT BUGS - THIS IS A PRE-RELEASE TESTING VERSION!!! You have been warned

Can you please describe more on the issue? Since not much details are provided I will take a guess
- if you are referring to the portfolio irr / portfolio roi / portfolio profit value / fund irr / fund roi charts: make sure that you have already updated the Portfolio Snapshot and Fund Snapshot sheet. You may import from your old excel (see the conversion instructions)
- if you are referring to the fund allocation / country region / type chart, please make sure that you update the Fund Allocation chart with the %. Also check Fund Info sheet just to make sure that fund names are picked correctly there without errors

btw, I'm not bro   

Assuming your portfolio snapshot, fund snapshot already updated correctly and pasted correctly as per instructions in the Conversion Spreadsheet, did you press "Refresh All" under Data connection?

Or easier, try clicking the 'UPDATE+SNAPSHOT' button

Wow...u guys are good.
My ROI is just +2.7%  MoM  :confused:
Japan is still in the red 

Port unchanged:


irr plot: