FundSuperMart v18 (FSM) MY : Online UT Platform

Lowyat.NET forums

Lowyat.NET Kopitiam Garage Sales

Lowyat.NET Rules and Regulations FAQ Help Search Members

Welcome Guest ( Log In | Register )

Lowyat.NET -> Finance, Business and Investment House

Bump Topic Add Reply RSS Feed

5 Pages < 1 2 3 4 5 >Bottom

Outline · [ Standard ] · Linear+

FundSuperMart v18 (FSM) MY : Online UT Platform, UT DIY : Babystep to Investing :D

views

polarzbearz	Jul 13 2018, 06:49 AM Return to original view \| Post #41
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(Ramjade @ Jul 12 2018, 11:31 PM) Two words. POEMS SG. No need priority/platinum member rubbish. Open to everyday people like you and me. Is there any other charges since the fund fee is 0%? Checked the website a bit and seems like its for Prepaid Cash upfront account (like fsm) and must have 1 transactions per quarter right? Anything else?
Card PM	Report Top Like Quote Reply

polarzbearz	Jul 15 2018, 04:03 PM Return to original view \| Post #42
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(watabakiu @ Jul 15 2018, 03:16 AM) There seems to be a myriad of investments to choose from, and I am just bewildered at the options available! Considering that I am a total no0b, which instruments should I go for? UT/bonds/PRS?? In case this helps: 1) Limited disposable income 2) Medium-to-long term investment 3) No need for liquidity - the investment money is not meant to be dipped 4) Minimum entry investment - and minimum/ no fees for subsequent top-ups 5) No very frequent monitoring of investment performance please! With the above, I believe PRS would be a good start, especially if you are between 20-30 years old this year which entitles you another rm1000 one off incentive from the government as long as you have gross contributions of at least rm1000 in a single prs fund before end of 2018. If you are currently paying taxes, you'll also be saving some bucks in the forms of tax relief.
Card PM	Report Top Like Quote Reply

polarzbearz	Jul 21 2018, 02:06 PM Return to original view \| IPv6 \| Post #43
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(Jebsee @ Jul 20 2018, 01:36 AM) im finding average return, and i have no clue and btw it is about my assgnmnt Use the excel templates in page 1. Either mine or pink spider ones will do.
Card PM	Report Top Like Quote Reply

polarzbearz	Jul 31 2018, 11:07 PM Return to original view \| IPv6 \| Post #44
Gracie Senior Member 4,816 posts Joined: Apr 2007	» Click to show Spoiler - click again to hide... « QUOTE(polarzbearz @ Jun 10 2018, 12:03 AM) !!!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: » Click to show Spoiler - click again to hide... « [attachmentid=9849802] !!!EXPECT BUGS - THIS IS A PRE-RELEASE TESTING VERSION!!! You have been warned Been really busy so didn't have much time to mess around with the excel, but manage to squeeze sometime to try adding a few new stuff: connecting to stock ticker updates (via Yahoo for now, so literally worldwide stocks) to fetch last-done price. The only challenge for stock trading is calculating the transaction service charge - for now I just do manual formula to calculate the % since stock trading is more tricky and too lazy to build in logics. There's a few other pricing sources which I tried to explore, most are using table format and it's too troublesome to fetch value (i.e. Public Mutual, HLA, etc.). Also, differentiated between Portfolio Overall IRR (active+inactive funds) vs. Current IRR (only active funds). Still working on JSON Currency Updater My target is to release it when FSMOne Malaysia is released (before end of year) This post has been edited by polarzbearz: Jul 31 2018, 11:08 PM
Card PM	Report Top Like Quote Reply

polarzbearz	Jul 31 2018, 11:17 PM Return to original view \| IPv6 \| Post #45
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(wongmunkeong @ Jul 31 2018, 11:14 PM) wohoo! it's great to have a fellow developer who's into investing/growing wealth too. Connected skills them - IT, process flows, logic & investing heheh technically speaking - grad as developer/SE but didn't ended up in developer career now only code for fun
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 10 2020, 11:40 PM Return to original view \| Post #46
Gracie Senior Member 4,816 posts Joined: Apr 2007	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 » Click to show Spoiler - click again to hide... « 2020 » Click to show Spoiler - click again to hide... « --------------------------------------- For stable version 2.2: 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 Note: this is not the fancy 2020 version above. It's merely a small patch so people don't have to manually edit codes This post has been edited by polarzbearz: Oct 11 2020, 06:16 PM matyrze, wongmunkeong, and 4 others liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 11 2020, 11:16 AM Return to original view \| Post #47
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(ironman16 @ Oct 11 2020, 10:48 AM) why i cant download the latest version? i click the new link but it link me to the old file .... 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. This post has been edited by polarzbearz: Oct 11 2020, 11:17 AM
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 11 2020, 11:41 AM Return to original view \| Post #48
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(ironman16 @ Oct 11 2020, 11:29 AM) the new excel cant auto get the NAV from FSM??? ## how u ppl do with the old fund? delete it ? Let say i hold Kenanga Growth for 2 year and recently just switch to United Malaysia, u ppl just delete all the Kenanga Growth record or turn off the auto fetch data from FSM??? 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")
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 11 2020, 06:30 PM Return to original view \| Post #49
Gracie Senior Member 4,816 posts Joined: Apr 2007	This post will be decommissioned soon - I am moving my releases to my blog page as it's easier / cleaner to manage. Feel free to add it to your bookmark for easy reference in the future. » Click to show Spoiler - click again to hide... « » Click to show Spoiler - click again to hide... « QUOTE(polarzbearz @ Jun 10 2018, 12:03 AM) !!!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: » Click to show Spoiler - click again to hide... « [attachmentid=9849802] !!!EXPECT BUGS - THIS IS A PRE-RELEASE TESTING VERSION!!! You have been warned » Click to show Spoiler - click again to hide... « QUOTE(polarzbearz @ Oct 10 2020, 11:40 PM) 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 » Click to show Spoiler - click again to hide... « 2020 » Click to show Spoiler - click again to hide... « --------------------------------------- For stable version 2.2: 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 Note: this is not the fancy 2020 version above. It's merely a small patch so people don't have to manually edit codes 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.2C Stable Version: https://bit.ly/polarzbearzPortfolioSummary2c (this is the previous stable version patched for 2020 FSMOne) 3.1C Latest Version (this one): https://bit.ly/polarzbearzPortfolioSummaryv31c FSM Conversion Tool (only compatible with v3.1): https://bit.ly/polarzbearzPortfolioSummaryConversionToolv31c Just a few important notes to list down: 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. 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) 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) This file contains sample data in "Investment Details", "Portfolio Snapshot", "Fund Snapshot", "Fund Snapshot Exclusion", "Fund Factsheet". UPDATE/REMOVE as required before proceeding!!!! 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 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 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! ------- Patch notes: QUOTE v3.1c [1 Nov 2020]: Hotfix for FSM Malaysia price fetcher since their new layout basicalaly broke the script. Read more : https://forum.lowyat.net/index.php?showtopi...post&p=98758263 QUOTE v3.1b [23 Oct 2020]: Sneaked in a small change to add additional major stock exchanges (NASDAQ, SGX, LSE) and also added one generic "Others" for other worldwide stock exchanges. As long as it is listed in Yahoo Finance, you can fetch the price. Read more : https://forum.lowyat.net/index.php?showtopi...post&p=98646070 This post has been edited by polarzbearz: Nov 27 2020, 12:57 PM matyrze, Takudan, and 7 others liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 13 2020, 03:53 PM Return to original view \| Post #50
Gracie Senior Member 4,816 posts Joined: Apr 2007	» Click to show Spoiler - click again to hide... « QUOTE(GrumpyNooby @ Oct 12 2020, 04:29 PM) PRS Campaign 2020: Receive RM40 Touch 'n Go eWallet Reload PIN Terms and Conditions: 1. Campaign period: 12 October 2020 till 11 December 2020. 2. Participating PRS Providers for this campaign include Affin Hwang Asset Management Berhad, Principal Asset Management Berhad, Kenanga Investors Berhad, RHB Asset Management Sdn Bhd and Manulife Investment Management Berhad. 3. New or existing PRS investors who invest a minimum of RM3,000 in ONE PRS Fund from any of the 5 participating PRS Providers in a SINGLE transaction during the promotion period are eligible for One (1) RM40 worth of Touch ‘n Go eWallet Reload Pin. 4. The investment amount of RM3,000 can include PPA account opening fee of RM10 for new PRS investors, or PPA annual fee of RM8 for existing PRS investors. 5. All cash payments and completed forms must reach us by 11am, 11 December 2020. 6. Purchase orders together with cash payments and completed forms received after 11am, 11 December 2020 will be voided. 7. This promotion does not apply to transactions involving Intra Switch Buy and Inter Switch Buy. 8. Each person is only entitled to One (1) RM40 worth of Touch ‘n Go eWallet Reload Pin. 9. FSMOne will have the final decision and reserves the right to substitute a prize which it reasonably determines as being of equal value. Any further correspondence will not be entertained. Collection: The Touch ‘n Go eWallet Reload Pin will be emailed to you latest by January 2021. Please refer to the terms and conditions of the Touch ‘n Go eWallet Reload Pin. Campaign link: https://www.fundsupermart.com.my/fsmone/art...llet-Reload-PIN For those whom want to participate this, make sure its RM3000 lump sum investment within campaign period. I had YTD RM2000++ and was asking if I can top-up RM1000 to qualify, and the answer was no.
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 15 2020, 06:20 PM Return to original view \| Post #51
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(papyrous @ Oct 15 2020, 02:12 PM) Hi, Thanks for this. I'm mostly on mobile and notice no VBA macros would work on android/iOS, am wondering if its possible to create a Google spreadsheets version, that might work for mobile updating and being kept online Thanks for your suggestion. Good one... But no plans yet at the moment
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 20 2020, 12:32 PM Return to original view \| Post #52
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(tehoice @ Oct 20 2020, 12:02 PM) Many thanks for this useful tool. appreciate it. You're more than welcome! Hope you enjoy it
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 20 2020, 10:02 PM Return to original view \| Post #53
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(wongmunkeong @ Oct 20 2020, 08:03 PM) me three XD SGX listed + PRS (0% ma +XX% tax relief) me four My UT portfolio is almost clean now except PRS (0% fees plus tax relief why not ) and moved most onto long term stocks (hold until god knows when )
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 20 2020, 11:55 PM Return to original view \| Post #54
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(wongmunkeong @ Oct 20 2020, 10:05 PM) https://www.youtube.com/watch?v=kyomDza-hS8 Watch this - U definitely will be able to test easily via spreadsheets with simple nested IFs ORs ANDs i've tested this using Yahoo Finance's historical SPY data - truth, long enough holding & investing in basket like ETF, even worst timer ever if bought at highest yearly BUT kept holding & buying yearly, still makes $ I'm the "lazy and boring" type I hope 40 years later when I look back at my portfolio I won't regret what I'm doing now
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 23 2020, 04:17 PM Return to original view \| Post #55
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(polarzbearz @ Oct 11 2020, 06:30 PM) [GO BACK TO ORIGINAL RELEASE POST] Hi all, at someone's requested I've decided to add a few more stock exchanges support (SGX, LSE, NASDAQ) and also a generic "Others" for all other world stock exchanges - as long as it's listed on Yahoo Finance, it will work. For those whom are interested - you can either re-download the template (same link in previous post quoted above) or follow manual DIY steps below (very simple actually) QUOTE Patch notes: v3.1b [23 Oct 2020]: Sneaked in a small change to add additional major stock exchanges (NASDAQ, SGX, LSE) and also added one generic "Others" for other worldwide stock exchanges. As long as it is listed in Yahoo Finance, you can fetch the price. Manual DIY steps (v3.1 or above): » Click to show Spoiler - click again to hide... « Step 1: Go to "Investment Details" sheet > scroll down and find button "UPDATE CURRENT FUND PRICE ONLY" and Right click > Assign Macro > Edit Step 2: A code editor window should appear, do a search (Ctrl+F) and find below code: CODE ElseIf fundSource = "KLSE" Or fundSource = "HKEX" Or fundSource = "NYSE" Then Step 3: Replace that entire line with below code: CODE ElseIf fundSource = "KLSE" Or fundSource = "HKEX" Or fundSource = "NYSE" Or fundSource = "NASDAQ" Or fundSource = "SGX" Or fundSource = "LSE" Or fundSource = "Others" Then Step 4: Close the code editor Step 5: Go to "Reference Data" sheet > right click and unprotect sheet > go to column C and input below values respectively in C11, C12, C13, and C14 (one value per row) CODE NASDAQ SGX LSE Others Step 6: Go to Name Manager (under 'Formulas'. Or just press Ctrl + F3) > look for 'refData_Source' > change value old value CODE ='Reference Data'!$C$2:$C$10 new value CODE ='Reference Data'!$C$2:$C$14 Step 7: Protect the "Reference Data" sheet again without password (prevent accidental edits) You are done! This post has been edited by polarzbearz: Nov 11 2020, 01:31 AM TOS, wongmunkeong, and 1 other liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Oct 23 2020, 06:15 PM Return to original view \| Post #56
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(TOS @ Oct 23 2020, 05:25 PM) Ah, I think for the new value for Step 6, it should be C2 to C14, since you added 4 more new values? Your posted old and new values are the same. Oops! Copy-paste error. Indeed it should be C2 to C14 on step 6. Updated my post This post has been edited by polarzbearz: Oct 23 2020, 06:16 PM TOS liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 1 2020, 02:46 AM Return to original view \| Post #57
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(T231H @ Nov 1 2020, 12:17 AM) seems like FSM MY has a new website make over and some changes to the Sales charges rate too... new website means need to update my script again aaaaaaaaaa
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 1 2020, 03:43 PM Return to original view \| Post #58
Gracie Senior Member 4,816 posts Joined: Apr 2007	Original Post - Release 3.1 QUOTE(polarzbearz @ Oct 11 2020, 06:30 PM) [GO BACK TO ORIGINAL RELEASE POST] Original Post - Patch 3.1b » Click to show Spoiler - click again to hide... « QUOTE(polarzbearz @ Oct 23 2020, 04:17 PM) Hi all, at someone's requested I've decided to add a few more stock exchanges support (SGX, LSE, NASDAQ) and also a generic "Others" for all other world stock exchanges - as long as it's listed on Yahoo Finance, it will work. For those whom are interested - you can either re-download the template (same link in previous post quoted above) or follow manual DIY steps below (very simple actually) Manual DIY steps (v3.1 or above): » Click to show Spoiler - click again to hide... « Step 1: Go to "Investment Details" sheet > scroll down and find button "UPDATE CURRENT FUND PRICE ONLY" and Right click > Assign Macro > Edit Step 2: A code editor window should appear, do a search (Ctrl+F) and find below code: CODE ElseIf fundSource = "KLSE" Or fundSource = "HKEX" Or fundSource = "NYSE" Then Step 3: Replace that entire line with below code: CODE ElseIf fundSource = "KLSE" Or fundSource = "HKEX" Or fundSource = "NYSE" Or fundSource = "NASDAQ" Or fundSource = "SGX" Or fundSource = "LSE" Or fundSource = "Others" Then Step 4: Close the code editor Step 5: Go to "Reference Data" sheet > right click and unprotect sheet > go to column C and input below values respectively in C11, C12, C13, and C14 (one value per row) CODE NASDAQ SGX LSE Others Step 6: Go to Name Manager (under 'Formulas'. Or just press Ctrl + F3) > look for 'refData_Source' > change value old value CODE ='Reference Data'!$C$2:$C$10 new value CODE ='Reference Data'!$C$2:$C$14 Step 7: Protect the "Reference Data" sheet again without password (prevent accidental edits) You are done! QUOTE(polarzbearz @ Nov 1 2020, 02:46 AM) new website means need to update my script again aaaaaaaaaa QUOTE(yklooi @ Nov 1 2020, 09:12 AM) ya-lar,...existing EXCEL's macro interface cannot access it to get the NAVs idyllrain, can you help us here again? QUOTE(WhitE LighteR @ Nov 1 2020, 09:53 AM) Omg. Fixed it via hotfix 3.1c. Original post updated for re-download of template, and for those who are YOLO, below are the manual DIY steps as usual: Manual DIY steps for hotfix 3.1c (minimum v3.1 or above): » Click to show Spoiler - click again to hide... « Strongly recommend to back-up a copy of your file before you do anything - especially if you are not familiar with programming. Step 1: Go to "Investment Details" sheet > scroll down and find button "UPDATE CURRENT FUND PRICE ONLY" and Right click > Assign Macro > Edit Step 2: A code editor window should appear, do a search (Ctrl+F) and find below code: CODE ElseIf fundSource = "FSMMY" Then Step 3: Slowly delete the contents in between the above line until you reach the below code: CODE ElseIf fundSource = "FSMHK" Then At this point, your code editor should look something like this: Step 4: Now that area is pretty darn clean, paste the below code in between those 2 lines. CODE Set XML = CreateObject("winhttp.winhttprequest.5.1") XML.Open "POST", "https://www.fsmone.com.my/rest/fund/find-price-history?paramSedolnumber=" & fundName & "&paramMonths=1" XML.Send ' Get JSON response jsonStr = XML.responseText Set json = JsonConverter.ParseJson(XML.responseText) '(v3.1) textCurrency = json("data")(1)("fundCurrencyCode") '(v3.1c) textTxAmt = json("data")(1)("bidPrice") '(v3.1c) textPrice = json("data")(1)("bidPrice") '(v3.1c) rawDateMilliseconds = json("data")(1)("showDate") '(v3.1c) textDate = Format(DateAdd("h", 8, Epoch2Date(rawDateMilliseconds)), "dd-mmm-yyyy") ' convert to dd-mmm-yyyy and offset GMT+8 '(v3.1) ' Troubleshooting check 'MsgBox "textCurrency: " & textCurrency & _ " \| textTxAmt: " & textTxAmt & _ " \| textPrice: " & textPrice & _ " \| rawDateMilliseconds: " & rawDateMilliseconds & _ " \| textDate: " & textDate & _ " \| (textTxAmt / textPrice): " & (textTxAmt / textPrice) loadingForm.Repaint '(v2.3) CREDITS TO idyllrain @ Lowyat.net WsInvD.Range("tblInvestmentDetails[Date]")(c.Row - 1).Value = textDate WsInvD.Range("tblInvestmentDetails[NAV Price]")(c.Row - 1).Value = textPrice WsInvD.Range("tblInvestmentDetails[NAV Curr.]")(c.Row - 1).Value = textCurrency If WsInvD.Range("tblInvestmentDetails[NAV Curr.]")(c.Row - 1).Value = WsInvD.Range("tblInvestmentDetails[Tx. Curr.]")(c.Row - 1).Value Then 'MsgBox "NAV Curr = Tx Curr" WsInvD.Range("tblInvestmentDetails[Ex. Rate]")(c.Row - 1).Value = "" Else 'MsgBox "NAV Curr != Tx Curr" WsInvD.Range("tblInvestmentDetails[Ex. Rate]")(c.Row - 1).Value = (textTxAmt / textPrice) End If ' successful update counter +1 successfulUpdate = successfulUpdate + 1 logs = logs & vbNewLine & vbTab & Left(i & Space(7), 7) & Left(fundSource & Space(12), 12) & Left(fundName & Space(15), 15) & vbTab & Left("OK!" & Space(10), 10) '(v3.3) It should look something like this: Step 5: Close the code editor You are done! This post has been edited by polarzbearz: Nov 11 2020, 01:31 AM fense, wongmunkeong, and 2 others liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 1 2020, 05:40 PM Return to original view \| Post #59
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(idyllrain @ Nov 1 2020, 04:55 PM) Looks like a pretty simple fix. The instructions does not apply to Polarzbearz v3.x and above files. If you're using that file, Polarzbearz posted a fix in the post above. Downloads Windows: [attachmentid=10663044] Mac OS: [attachmentid=10663029] Instructions for Windows If you prefer not to start fresh, and if you are still using the older version of Polarzbearz's file. You can use these instructions to update your copy to work with the new FSM site. MAKE A COPY OF YOUR FILE BEFORE YOU DO THIS! Just in case... » Click to show Spoiler - click again to hide... « Instructions[list=1] [] Right click on the "Update Current Fund Price" button, and choose "Assign Macro" [] Select the macro with the name "GetFundPrices" and click on "Edit" [] On the main screen you'll see the subroutine that says "GetFundPrices" [] This subroutine goes all the way down here [] Now for all the lines of code that is shown on the left side of this screenshot, either comment it out or delete it. [] Finally, go to the "File" menu, "Save" and then choose "Close and Return to Excel" Ahh you reminded me... I forgot about the stable version needs to be patched too Sneaked it in as well
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 3 2020, 08:41 PM Return to original view \| Post #60
Gracie Senior Member 4,816 posts Joined: Apr 2007	QUOTE(Pewufod @ Nov 3 2020, 03:55 PM) isnt fsm buying online ? QUOTE(adele123 @ Nov 3 2020, 08:37 PM) Buying insurance policy via fsm, is still buying via agent. I dont know what is the sales process. When i mean buy online is, direct buy online, no commission. Im guessing, it's abit concept like car insurance. When renew with takaful directly, they charge 0% commission. But when renewing via agents, +10% to the price. So when buying insurance via FSM, they get commission as well but paid back to us partially (half? Or less? Or more?) via cashback. But buying insurance directly, say, with tokiomarine ONLINE, then 0% commission. (I haven't tried personally though, I bought via FSM cause of the plan customisation )
Card PM	Report Top Like Quote Reply

« Next Oldest · Finance, Business and Investment House · Next Newest »

5 Pages < 1 2 3 4 5 >Top

Add Reply Options

Change to:

0.0658sec

0.41

7 queries

GZIP Disabled
Time is now: 2nd December 2025 - 04:28 AM

All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)

Removal Request

Powered by Invision Power Board © 2025 IPS, Inc.