yes,....for As of 8:30PM, 21 Dec 2018 we can no longer get NAV prices from the old link at https://www.fundsupermart.com.my/main/fundi....tpl?id=MYKNGGF This means that if you're using the old Windows or Mac versions of this spreadsheet, it will no longer retrieve the latest prices since that page is no longer there.

possible solution, check out post 15983, page 800 by Idyllrain
https://forum.lowyat.net/topic/4193169/+15980#entry91305801

China = 30%
Gold = 25%
US = 45%
[ Equity portion ]

Individual may adjust their risk by increasing the fixed income portion up to their desired tolerance level.

Say for example you want a 40 ( FI ) : 60 ( Eq ) risk profile; then you put 40% in FI + 18% in China + 15% in Gold + 27% in US. This is how you 'play' unit trust.

Xuzen.

real man plays specific country!

Geographical are for pussies!

His networth hits 1 mil. Remember? 

MoM drops 3.7% due to some rebalancing activity.

Worst performing fund is still Principal ASEAN Dynamic Fund - MYR

My used-to-be-simple excel became a monster now  

So far it can:-
- mass update/track FSM Malaysia/FSM Singapore/FSM Hong Kong/Worldwide stock markets/manual portfolio without API support i.e. StashAway (just..type..manually)
- multi-Currency support + mass update - track fund performance in home currency (MYR?) and native currency (e.g. HKD for HK funds, USD for NYSE stocks, ...). Also support cases when "trade" currency are different than fund native currency (FSM HK's favourite....  )
- decimal point config for calculations (FSM MY use 2 decimal, FSM HK use 4 decimal) 
- flexible reporting by changing currency
- stock dividends support
- snapshot (to track performance)
- auto lines grouping (usually broken after pasting new rows hence need to regroup)
- portfolio age

Have been adding stuff here and there since 2015 but didn't really have the time to make it user friendly (except for myself ) hence didn't publish it.
Plus I have no idea how to support existing users to migrate over (painlessly). Anyone interested to take over the "deployment"? 

2015


2020


AIYH Btw I've updated the previous release with idyllrain's patch here.

This is the new URL to download the fresh template - if you could help me to replace my previous link ^^ (just add 'b' behind the bitly)
Old Link: https://bit.ly/polarzbearzPortfolioSummary2
New Link: http://bit.ly/polarzbearzPortfolioSummary2b

The new link is still previous stable version (2.2) haha.. I just applied the patch for new FSMONE interface so people don't need to manually replace codes. shared previously by idyllrain

For the new (complex) version I haven't released yet as I'm not sure how to support it (given the complexity) but if you guys are interested I can release it for own navigation / exploration.

Which new excel? Both the 2.2b and my WIP complex version already can fetch from fsm one.
For selling/switching out fund, NEVER delete it otherwise you lose trace of your profit/loss in the past. Cut and move it to "inactive" section (details in "INSTRUCTION")

Hi All, I've decided to do a quick clean-up and finally release the v3.1 excel spreadsheet for those adventurous enough to explore.
Should be no issues as I've personally been "testing"(using) it myself for the past 2 years (albeit only added Currency Updater yesterday)

Download Link:
2.2B Stable Version:   http://bit.ly/polarzbearzPortfolioSummary2b  (this is the previous stable version patched for FSMOne)
3.1 Latest Version (this one): http://bit.ly/polarzbearzPortfolioSummaryv31a
FSM Conversion Tool (only compatible with v3.1):  http://bit.ly/polarzbearzPortfolioSummaryConversionToolv31a 
Just a few important notes to list down:

1. If you're currently using my previous v2.2 stable, you can use the "Polarzbearz's FSM-to-Spreadsheet Conversion Tool" and go to the section for "2.2 to 3.1 FILE CONVERSION". Otherwise, you can re-import and convert latest FSMOne historical data using the same tool.
   
   
   
2. If you're using the Stock Updater feature, get your stock codes from Yahoo Finance, applicable for all markets (NYSE, KLSE & HKEX). Example: Xiaomi Corporation -> https://finance.yahoo.com/quote/1810.HK/ (Stock code is '1810.HK' to be input into Excel)
   
   
   
3. If you want to use Currency Updater, there's a few step required to first get yourself an API key via https://app.exchangerate-api.com/, and update "Reference Data" >> cell D5 (API key)
   
   
   
4. This file contains sample data in "Investment Details", "Portfolio Snapshot", "Fund Snapshot", "Fund Snapshot Exclusion", "Fund Factsheet". UPDATE/REMOVE as required before proceeding!!!!
   
   
   
5. No changes should be required for "Currency", "Fund Info", "Fund Allocation", "Portfolio Summary", "Fund Pivot (Profit)", "Fund Pivot (IRR)" as these are all automated updates. Do not touch anything unless you know what you're doing
   
   
   
6. As this is a free tool, no guarantees whatsoever will be provided. Best-effort-basis support will be given to those who needs it, but would be best if you are comfortable navigating around Excel
   
   
   
7. This version is only fully tested on Microsoft Excel 2016 and above (incl. Office 365), on Windows 10 PC. Unfortunately I don't have a Mac to test it so you'll be on your own
   
   
   

This will probably be my last release, if anyone's interested feel free to take it forward - it's open source

Many thanks to idyllrain as he've been helping out alot throughout the implementation especially when it comes to initial setup for price-fetcher update (since my programming knowledge's rottening )

Enjoy!

Sep 2020 was a suckish month. Oct 2020 rebounded.

Uncle Sam naik! Cina pun naik! Bolehland pun naik! Klau emas naik, manyak syiok! 

Xuzen

p/s Forget Lee Sook Yee, we have a new hot babe in town.

3-years volatility is 20.1 is low? 

No worries, I'm not fancy of Malaysia centric funds.

Its rare this days to find a good performing malaysia large cap fund. So its good that he shared this with us. Maybe this is something that we can keep our eye open to in case malaysia starts to come out of this economic crisis. But I dont think that would happen until KLCI goes above 1600...

Malaysia large cap is more or less boring

Anyone withdrawing all the fund before Nov 3 ?

Then you stay invested?

But if US catches flu, the rest of world won't be spared too right?

This is whar I learnt from PM UTC, they said to lock profit is to switch bond fund when market condition is not favourable.
Boleh pakai kah? Well, it's your money and you're at the driving seat not UTC or I.

Public Healthcare-Global Equity Fund will invest at least 30% of its net asset value in healthcare-related stocks and collective investment schemes, with the balance in other sectors with resilient growth and long-term structural trends

can get in FSM
UNITED GLOBAL HEALTHCARE FUND - CLASS A - MYR ACC
https://www.fundsupermart.com.my/fsmone/fun...Class-A-MYR-Acc

AFFIN HWANG WORLD SERIES - GLOBAL HEALTHSCIENCE FUND - MYR
https://www.fundsupermart.com.my/fsmone/fun...cience-Fund-MYR

How about Affin Hwang World Series – Global Disruptive Innovation Fund?

At last, Principal ASEAN Dynamic Fund - MYR swings into green territory!