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

1553 Pages « < 1179 1180 1181 1182 1183 > » Bottom

Outline · [ Standard ] · Linear+

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

views

xcxa23	Nov 1 2020, 09:01 AM Show posts by this member only \| IPv6 \| Post #23601
Look at all my stars!! Senior Member 2,649 posts Joined: Nov 2010	nope, mine still at 1.25%
Card PM	Report Top Like Quote Reply

coolguy99	Nov 1 2020, 09:07 AM Show posts by this member only \| IPv6 \| Post #23602
Look at all my stars!! Senior Member 7,349 posts Joined: Aug 2015	For the PRS TnG promo, is it applicable for money from the CMS or it needs to be fresh fund?
Card PM	Report Top Like Quote Reply

SUSyklooi	Nov 1 2020, 09:12 AM Show posts by this member only \| IPv6 \| Post #23603
Look at all my stars!! Senior Member 8,188 posts Joined: Apr 2013	QUOTE(polarzbearz @ Nov 1 2020, 02:46 AM) new website means need to update my script again aaaaaaaaaa ya-lar,...existing EXCEL's macro interface cannot access it to get the NAVs idyllrain, can you help us here again?
Card PM	Report Top Like Quote Reply

Amanda85	Nov 1 2020, 09:46 AM Show posts by this member only \| Post #23604
Scuderia Ferrari Senior Member 2,232 posts Joined: May 2006 From: Petaling Jaya	QUOTE(xcxa23 @ Nov 1 2020, 09:01 AM) nope, mine still at 1.25% i am silver too but my last transaction on 30/10 was 1.5%
Card PM	Report Top Like Quote Reply

GrumpyNooby	Nov 1 2020, 09:49 AM Show posts by this member only \| IPv6 \| Post #23605
10k Club All Stars 12,387 posts Joined: Feb 2020	-deleted- This post has been edited by GrumpyNooby: Jan 7 2021, 11:33 AM
Card PM	Report Top Like Quote Reply

WhitE LighteR	Nov 1 2020, 09:53 AM Show posts by this member only \| Post #23606
WhitE LighteR Is Black~ All Stars 10,340 posts Joined: Jan 2003	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? Omg.
Card PM	Report Top Like Quote Reply

!@#$%^	Nov 1 2020, 10:14 AM Show posts by this member only \| IPv6 \| Post #23607
Safe Trader All Stars 17,496 posts Joined: Feb 2006 From: KL	QUOTE(GrumpyNooby @ Nov 1 2020, 09:49 AM) Doesn't matter the source of fund. The eligibility is to buy or top up a PRS fund listed under FSMOne platform in a single transaction of RM 3k. gopayz considered as cash payment?
Card PM	Report Top Like Quote Reply

MUM	Nov 1 2020, 10:25 AM Show posts by this member only \| IPv6 \| Post #23608
10k Club All Stars 14,855 posts Joined: Mar 2015	QUOTE(!@#$%^ @ Nov 1 2020, 10:14 AM) gopayz considered as cash payment? reading this sentence, " FSMOne’s unit trust offerings will be made available on the telco’s soon to be launched e-wallet called GoPayz. (as per May 2019 article) To simplify customer experience, transactions of FSMOne’s unit trusts may be done digitally either via the GoPayz app or on its website" https://www.fsmone.com.my/funds/research/ar...Insurance=false thus i think have to go to Gopayz apps/website to check if they offer the same TnG ewallet reload pin..... (with Gopayz and Tng...are competitor ) This post has been edited by MUM: Nov 1 2020, 10:25 AM
Card PM	Report Top Like Quote Reply

!@#$%^	Nov 1 2020, 10:35 AM Show posts by this member only \| IPv6 \| Post #23609
Safe Trader All Stars 17,496 posts Joined: Feb 2006 From: KL	QUOTE(MUM @ Nov 1 2020, 10:25 AM) reading this sentence, " FSMOne’s unit trust offerings will be made available on the telco’s soon to be launched e-wallet called GoPayz. (as per May 2019 article) To simplify customer experience, transactions of FSMOne’s unit trusts may be done digitally either via the GoPayz app or on its website" https://www.fsmone.com.my/funds/research/ar...Insurance=false thus i think have to go to Gopayz apps/website to check if they offer the same TnG ewallet reload pin..... (with Gopayz and Tng...are competitor ) yeah, guess i’ll drop them an email MUM liked this post
Card PM	Report Top Like Quote Reply

SUSTOS	Nov 1 2020, 11:13 AM Show posts by this member only \| IPv6 \| Post #23610
Look at all my stars!! Senior Member 8,667 posts Joined: Aug 2019 From: Penang <-> Singapore	QUOTE(encikbuta @ Nov 1 2020, 07:26 AM) aaaww, i was wishfully hoping they also upgraded existing Silver members to Gold, hehe. P/S: they didn't iFAST did very well and their stocks surge in Singapore quite a lot this year. So, some profits to share with their customers. After all, they earned enough from our commissions and charges.
Card PM	Report Top Like Quote Reply

xcxa23	Nov 1 2020, 11:34 AM Show posts by this member only \| IPv6 \| Post #23611
Look at all my stars!! Senior Member 2,649 posts Joined: Nov 2010	QUOTE(Amanda85 @ Nov 1 2020, 09:46 AM) i am silver too but my last transaction on 30/10 was 1.5% looks like the offer only 1.75 to 1.50 macam not fair to others categories
Card PM	Report Top Like Quote Reply

WhitE LighteR	Nov 1 2020, 12:16 PM Show posts by this member only \| Post #23612
WhitE LighteR Is Black~ All Stars 10,340 posts Joined: Jan 2003	QUOTE(xcxa23 @ Nov 1 2020, 11:34 AM) looks like the offer only 1.75 to 1.50 macam not fair to others categories Probably did so to shut up all those that says eut min charge is 1.5% LoTek and TOS liked this post
Card PM	Report Top Like Quote Reply

GamaX320	Nov 1 2020, 12:21 PM Show posts by this member only \| IPv6 \| Post #23613
Enthusiast Senior Member 822 posts Joined: Sep 2012	Anyone using ios device why the app can’t view fund fact pdf
Card PM	Report Top Like Quote Reply

abcn1n	Nov 1 2020, 01:42 PM Show posts by this member only \| Post #23614
Look at all my stars!! Senior Member 2,379 posts Joined: Sep 2017	QUOTE(GrumpyNooby @ Nov 1 2020, 12:43 AM) The 1.5% sales charge will commence starting 1/11/2020? Don't see any changes to the sales charge except that if you want to top up your existing funds, it has become as if you are investing for the first time. For eg: Principal greater china fund, minimum top up is $200 as per what is stated but they don't let you do that , instead you have to top up $500 (as if you are buying it for the first time). The website has problems.
Card PM	Report Top Like Quote Reply

xcxa23	Nov 1 2020, 03:18 PM Show posts by this member only \| IPv6 \| Post #23615
Look at all my stars!! Senior Member 2,649 posts Joined: Nov 2010	QUOTE(WhitE LighteR @ Nov 1 2020, 12:16 PM) Probably did so to shut up all those that says eut min charge is 1.5% ahh.. i see lets see if eut fight back
Card PM	Report Top Like Quote Reply

IdiotGuY88	Nov 1 2020, 03:31 PM Show posts by this member only \| Post #23616
Getting Started Junior Member 55 posts Joined: Oct 2011 From: Selangor	the new website i dont like the watchlist page, i prefer old watchlist UI, can compare performance to see, 1week, 1mth, 3mth, 6mth that kind of info biastee, helo96, and 2 others liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 1 2020, 03:43 PM Show posts by this member only \| Post #23617
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

idyllrain	Nov 1 2020, 04:55 PM Show posts by this member only \| Post #23618
Getting Started Junior Member 78 posts Joined: Apr 2008	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? 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: My_Portfolio_IRR_calculator___Windows__Nov_2020_.zip ( 1.88mb ) Number of downloads: 26 Mac OS: FSM_Portfolio_IRR_Mac_Office_2016__Nov_2020_.xlsm.zip ( 1.91mb ) Number of downloads: 9 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 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" This post has been edited by idyllrain: Apr 29 2023, 11:05 AM GamaX320, ironman16, and 2 others liked this post
Card PM	Report Top Like Quote Reply

idyllrain	Nov 1 2020, 05:31 PM Show posts by this member only \| Post #23619
Getting Started Junior Member 78 posts Joined: Apr 2008	Instructions for Mac OS 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 Right click on the "Update Current Fund Price" button, and choose "Assign Macro" Click on the "Edit" button Look on the left side of the panel, and find "Module 2" in the "Modules" folder. Double click on it. Select all the lines of the function called "DownloadFromFSMMac" Press the "Backspace" key or "Delete" key on your keyboard Copy the code in the Spoiler section below, and paste it here Code in here vvvv » Click to show Spoiler - click again to hide... « CODE Function DownloadFromFSMMac(sCode As String) As String Dim sCmd As String Dim sResult As String Dim lExitCode As Long ' Idyllrain-Leverage OSX perl commands because there is no built-in support for the HTML object nor regular expressions sCmd = "perl -MLWP::UserAgent -le '$l=""https://www.fundsupermart.com.my/fsmone/rest/"";$u=LWP::UserAgent->new(ssl_opts=>{verify_hostname=>0},cookie_jar=>{});$u->post($l.""fund/get-factsheet?paramSedolnumber="".shift)->decoded_content()=~/latestNavPrice.+?showDate.:(\d+).+?bidPrice.:([0-9.]+)/;print $2."";"".$1;' " + sCode sResult = execShell(sCmd, lExitCode) DownloadFromFSMMac = sResult End Function So what has changed? This highlighted section has been removed from the previous code. Finally, click on the Save button and close the window" This post has been edited by idyllrain: Apr 29 2023, 10:59 AM brokenbomb, yklooi, and 1 other liked this post
Card PM	Report Top Like Quote Reply

polarzbearz	Nov 1 2020, 05:40 PM Show posts by this member only \| Post #23620
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: My_Portfolio_IRR_calculator___Windows__Nov_2020_.zip ( 1.88mb ) Number of downloads: 26 Mac OS: FSM_Portfolio_IRR_Mac_Office_2016__Nov_2020_.xlsm.zip ( 1.91mb ) Number of downloads: 9 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

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

1553 Pages « < 1179 1180 1181 1182 1183 > » Top

Add Reply Options

Change to:

0.0305sec

0.41

6 queries

GZIP Disabled
Time is now: 29th November 2025 - 01:38 PM

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

Removal Request

Powered by Invision Power Board © 2025 IPS, Inc.