Welcome Guest ( Log In | Register )

1554 Pages « < 238 239 240 241 242 > » Bottom

Outline · [ Standard ] · Linear+

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

views
     
plumberly
post May 22 2017, 09:12 AM

Look at all my stars!!
*******
Senior Member
4,761 posts

Joined: Jun 2007
From: My house


QUOTE(screwedpeep @ May 21 2017, 09:27 PM)
If you check on first page, our sifu did mention this:
» Click to show Spoiler - click again to hide... «

You can use macro on OSX but macro on OSX relies on different applications as to macro on Windows. So need to tweek the coding to make your macro Excel work on OSX.
TL;DR: macro running on Windows won't directly be able to run on OSX.

I think I've gotten around the issue with my macro Excel, after 2 nights of tweaking, trial and error rclxub.gif  mega_shok.gif i'll update my tweaked code here later on for reference.

EDIT:

After latest update of MO 2016 for Mac, the macro Excel uploaded by ]@polarbearz] and idyllrain somehow can't work, with this error popping out:
» Click to show Spoiler - click again to hide... «

I updated the declare statement with "PtrSafe" attribute, and updated LONG arguments for pointers with LONGPTR. My coding as below. Reference for declare statement update is HERE and for "long" arguments is HERE
The tweaked code is here:
» Click to show Spoiler - click again to hide... «

TBH, i'm not sure if i have amended all necessary LONG arguments but it works and i'll let it be until next error  sweat.gif
*
I see. Thanks.
dasecret
post May 22 2017, 10:36 AM

Regular
******
Senior Member
1,498 posts

Joined: Nov 2012
QUOTE(suadrif @ May 21 2017, 10:48 PM)
Yup understood the management fee is different.

This is only specifically WRAP FEE that they are talking about. I did counter them using the same statement.
*
I belief that agent is referring to the wrap account that IFAST offers through financial planners. Well, strictly speaking it's only comparing apple to apple when you compare Public Mutual agent to financial planners that sell funds from asset management companies other than Pub Mut. FSM is another ball game altogether, you gotta put through all the transactions yourself and decide on what funds to get on your own.

As to whether or not 1.5% p.a. wrap fee is worth it, it depends on how you buy & sell your funds. If you trade it like share market, the wrap fee may work out to be cheaper than upfront sales charge. Especially with Pub Mut style of switching penalty within 90 days. In FSM, you can even get 0 switching charge if you are willing to have longer lag time.


QUOTE(Avangelice @ May 21 2017, 11:10 PM)
I sometimes wish fsm would have installed their own irr calculation instead of us having to go through the wonky excel sheets.
*
I don't think the excel sheets are wonky, I'm grateful there are excel experts who are willing to spend time to prepare them and generously share with us. But some forumers did rightly point out that sometimes it's hard to use other ppl's stuffs and may be easier if you just prepare your own excel sheet which meet your own objective instead
inquiries
post May 22 2017, 10:52 AM

Getting Started
**
Junior Member
273 posts

Joined: Jan 2017
Since we are on this topic again...
Was it you who mentioned that there are some IRR calculators in the market? Were you able to find out which is suitable for you?

IIRC, you prefer to use a dedicated software for such IRR calculations, rather than Excel worksheet.
I have similar thoughts too. Nothing against the great Excel file did by our fellow LYN members, but despite all the instructions here, I still fail to utilize it appropriately. If anyone found any alternatives (for Excel-newbies like me), kindly enlighten me.

Thanks.

QUOTE(Avangelice @ May 21 2017, 11:10 PM)
I sometimes wish fsm would have installed their own irr calculation instead of us having to go through the wonky excel sheets.
*
T231H
post May 22 2017, 10:56 AM

Look at all my stars!!
*******
Senior Member
5,143 posts

Joined: Jan 2015
QUOTE(inquiries @ May 22 2017, 10:52 AM)
Since we are on this topic again...
Was it you who mentioned that there are some IRR calculators in the market? Were you able to find out which is suitable for you?

IIRC, you prefer to use a dedicated software for such IRR calculations, rather than Excel worksheet.
I have similar thoughts too. Nothing against the great Excel file did by our fellow LYN members, but despite all the instructions here, I still fail to utilize it appropriately. If anyone found any alternatives (for Excel-newbies like me), kindly enlighten me.

Thanks.
*
those standalone program cannot get NAV prices update from FSM at the press of the button.
the one downloadable from post # 1 can..... thumbsup.gif
Avangelice
post May 22 2017, 11:24 AM

Look at all my stars!!
*******
Senior Member
5,274 posts

Joined: Jun 2008


QUOTE(inquiries @ May 22 2017, 10:52 AM)
Since we are on this topic again...
Was it you who mentioned that there are some IRR calculators in the market? Were you able to find out which is suitable for you?

IIRC, you prefer to use a dedicated software for such IRR calculations, rather than Excel worksheet.
I have similar thoughts too. Nothing against the great Excel file did by our fellow LYN members, but despite all the instructions here, I still fail to utilize it appropriately. If anyone found any alternatives (for Excel-newbies like me), kindly enlighten me.

Thanks.
*
there's one way. Pay dasecret which I'm contemplating to do. dasecret you wanna make a few tens?
Drian
post May 22 2017, 11:31 AM

Look at all my stars!!
*******
Senior Member
4,999 posts

Joined: Jan 2003


QUOTE(suadrif @ May 21 2017, 10:36 PM)
Guys, just want to do a quick check.

One of the advantage having Fundsupermart platform compared to any agent is LOWER SALES CHARGE.
FSM platform sales charge is ranging from 0-2% per transaction whereas agent charges up to 7%.

But recently there's agent saying that FSM is charging us WRAP FEE which is 1.5% from our ANNUAL TOTAL AMOUNT. Is this statement true? I dont have any clue on this.
*
Your agent trying to mislead you to make his 5.5% sales charge appear cheaper.
Mine telling us from what company the agent is?


T231H
post May 22 2017, 11:55 AM

Look at all my stars!!
*******
Senior Member
5,143 posts

Joined: Jan 2015
for those that are still sitting on the fence waiting for the time to throw some % into M'sia
.......
Is Malaysia Still A Good Buy? [19 May 2017]
https://www.fundsupermart.com.my/main/resea...-May-2017--8370

for those that are still waiting for signs to top up more into EM......
Strong market rebound for emerging Asia?
http://www.thestar.com.my/business/busines...-emerging-asia/

This post has been edited by T231H: May 22 2017, 12:05 PM
puchongite
post May 22 2017, 12:30 PM

20k VIP Club
*********
All Stars
33,725 posts

Joined: May 2008
QUOTE(T231H @ May 22 2017, 11:55 AM)
for those that are still sitting on the fence waiting for the time to throw some % into M'sia
.......
Is Malaysia Still A Good Buy? [19 May 2017]
https://www.fundsupermart.com.my/main/resea...-May-2017--8370

for those that are still waiting for signs to top up more into EM......
Strong market rebound for emerging Asia?
http://www.thestar.com.my/business/busines...-emerging-asia/
*
USD to ringgit is now 4.30, shows that foreign money is flowing in to Malaysia. Flow to where, I don't know.

Malaysian small cap is still going up. I guess it will continue to do so, until the market finds an excuse to do a major correction.
wodenus
post May 22 2017, 12:30 PM

Tree Octopus
********
All Stars
14,990 posts

Joined: Jan 2003
QUOTE(Ramjade @ May 20 2017, 10:42 PM)
I haven't look at fundamentals of u-li but selling down of u-li was the cause of malaysia smallcaps sell downtown last time. If I am not mistaken, most RHB funds kena wipe out by 15-25% because of this u-li fiasco.
*
Any fund that will drop by 25% just because of one counter.. is too concentrated smile.gif
puchongite
post May 22 2017, 12:34 PM

20k VIP Club
*********
All Stars
33,725 posts

Joined: May 2008
QUOTE(wodenus @ May 22 2017, 12:30 PM)
Any fund that will drop by 25% just because of one counter.. is too concentrated smile.gif
*
It's incorrect to say it's due to one counter ( u-li ). It was actually a bunch of counters, but common among the RHB funds ( and also other funds ).

For me I think it was a natural correction due to the oversell nature of the small/mid cap counters at that moment, the market was just looking for an excuse to perform a correction. Personnel movement happened to trigger it.

This post has been edited by puchongite: May 22 2017, 12:54 PM
Ramjade
post May 22 2017, 12:36 PM

20k VIP Club
*********
All Stars
24,431 posts

Joined: Feb 2011



QUOTE(puchongite @ May 22 2017, 12:34 PM)
It's incorrect to say it's due to one counter ( u-li ). It was actually a bunch of counters, but common among the RHB funds ( and also other funds ).

For me I think it was a natural correction due to the oversell nature of the small/mid cap counters at that moment, the market was just looking for an excuse to perform a correction. Personal movement happen to trigger it.
*
It was a bunch. But it started with U-li if I am not wrong. Then domino effect as people sell other fund held by the fund.
wodenus
post May 22 2017, 12:37 PM

Tree Octopus
********
All Stars
14,990 posts

Joined: Jan 2003
QUOTE(puchongite @ May 22 2017, 12:34 PM)
It's incorrect to say it's due to one counter ( u-li ). It was actually a bunch of counters, but common among the RHB funds ( and also other funds ).

For me I think it was a natural correction due to the oversell nature of the small/mid cap counters at that moment, the market was just looking for an excuse to perform a correction. Personal movement happen to trigger it.
*
why call it a u-li fiasco then if u-li wasn't the sole cause of it smile.gif

T231H
post May 22 2017, 01:01 PM

Look at all my stars!!
*******
Senior Member
5,143 posts

Joined: Jan 2015
googled and found this last year's article..

The stocks that RHB Asset Management holds a significant long position include
PIE Industrial Bhd,
United U-Li Corp Bhd,
SLP Resources Bhd,
Oriental Food Industries Holdings Bhd,
Pestech International Bhd,
Berjaya Food Bhd,
ES Ceramics Technology Bhd,
Federal Furniture Holdings (M) Bhd,
Power Root Bhd and SCGM Bhd.

According to Bloomberg, from Aug 1 to 24, the prices of these stocks fell between 5.81% and 35.85%........
.......

According to the fund fact sheet as at end-June,
RHB Smart Treasure Fund,
RHB Kidsave Trust,
RHB Small Cap Opportunity Fund and
RHB Equity Trust have invested heavily in the stocks mentioned,

making up 35%, 32%, 33% and 30% of the funds’ portfolio respectively.

http://www.theedgemarkets.com/article/news...lldown%E2%80%99

screwedpeep
post May 22 2017, 01:52 PM

Enthusiast
*****
Senior Member
909 posts

Joined: Feb 2011
From: Kerteh - KL - Ipoh - KB
QUOTE(idyllrain @ May 21 2017, 10:48 PM)
Hi screwedpeep, I uploaded two files in this post: https://forum.lowyat.net/index.php?showtopi...post&p=83747364

The 2016 file is for 64bit, while the 2011 file is 32bit. My fault for naming them 2011/2016 instead of 32bit/64bit.

AIYH Would you please update the first post with these files instead?
*
Noted and Thanks! I compared side by side and it looks like i did the right thing with my excel yesterday. laugh.gif no more issue. notworthy.gif thumbsup.gif


QUOTE(inquiries @ May 22 2017, 10:52 AM)
I have similar thoughts too. Nothing against the great Excel file did by our fellow LYN members, but despite all the instructions here, I still fail to utilize it appropriately. If anyone found any alternatives (for Excel-newbies like me), kindly enlighten me.
*
If you use polarbearz version, it is very straightforward. The instructions are clear and all are automated so it's a fully baked excel sheet, if i could say that. I only have issue when i was migrating from Windows to OSX, and with idyllrain help, it works. The sheets provided need no further tweaking, unless you're like me, wanting to go a mile further to add few extra things. Just remember to have separate sheets to experiment with. You should be OK. It could serve you well to be a study material and learn bit by bit. Take your time and learn how each macro/formula works. nod.gif icon_rolleyes.gif
i-m-pinkie
post May 22 2017, 01:57 PM

New Member
*
Newbie
2 posts

Joined: May 2017
QUOTE(xuzen @ May 20 2017, 07:13 PM)
Interpac Dana Safi and Interpac Dynamic prior to hiring the new FM, is hardly heard off. It is as though nobody knew it existed. Then suddenly, the RHB FM left , went there and voila! Interpac UTF became super duper hot.
I suggest you take a look at the past performance of RHB Smart Series to get an idea of how Interpac UTF will perform since the FM is formerly from RHB Smart Series. As off now, FSM website is down, so I cannot check the past performance of RHB Smart Series. However, RHB Smart Series is never in Algozen™ radar, hence my guess, it a nothing to shout UTF, if strictly based on past performance.

Xuzen
*
Hi Xuzen, can I ask your opinion on Kenanga Malaysia Inc Fund ? How does it performed compare to Kenanga Growth Fund. From the past year performance, looks like both of them are quite consistently growing. Thank you.
xuzen
post May 22 2017, 02:21 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(i-m-pinkie @ May 22 2017, 01:57 PM)
Hi Xuzen, can I ask your opinion on Kenanga Malaysia Inc Fund ? How does it performed compare to Kenanga Growth Fund. From the past year performance, looks like both of them are quite consistently growing. Thank you.
*
Hello friend Pink Spider I-m-pinkie,

If you read their prospectus, KGF has mandate to invest in Malaysia stock market with unconstrained selection. That means they can buy large cap, index linked counter, small cap and mid cap. If they want, they can also go ACE counter. With such versatile mandate and coupled with a good Fund Manager, it is not surprisingly KGF is the darling of the Malaysia focused UTF.

KMI on the other hand states in their prospectus their trust deed is to invest in Malaysian counter with global reach. To my interpretation, it appears to be targeting the large cap or index linked counters. By this virtue, this UTF is already limiting itself to only a segment of the whole KLSE. If large cap is what you think will fit into your portfolio, then one may consider buying directly into ETF Malaysia e.g., FTSE BURSA MALAYSIA KLCI ETF (0820EA).

Now, I will talk about performance. Both KGF and KMI have about the same type of volatility but KGF has better return historically. Hence, given that both offers the same level of risk, then a rationale investor should choose the one which gives a better rate of return. Understand boh?

Xuzen
raist86
post May 22 2017, 02:40 PM

Regular
******
Senior Member
1,577 posts

Joined: May 2005
From: USJ


Hi all, want to ask some advice. I'm using Polarbearz spreadsheet and keying in all my FSM transaction as of date. No issues with buying and selling transaction. but when comes to dividend from the Fund, the number of units does not tally with the amount.

For eg, 18 Apr 2017, CIMB fund gave a div of RM 131.62 @ 0.3393 NAV price. My transaction history shows 387.91 units added. I keyed in the transaction type as Dividend, Transaction Amt = RM 131.62, NAV = 0.3393 but the final unit comes out as 131.62 units.

Should i use the Transaction manual adj to change the units qty?
T231H
post May 22 2017, 02:41 PM

Look at all my stars!!
*******
Senior Member
5,143 posts

Joined: Jan 2015
QUOTE(raist86 @ May 22 2017, 02:40 PM)
Hi all, want to ask some advice. I'm using Polarbearz spreadsheet and keying in all my FSM transaction as of date. No issues with buying and selling transaction. but when comes to dividend from the Fund, the number of units does not tally with the amount.

For eg, 18 Apr 2017, CIMB fund gave a div of RM 131.62 @ 0.3393 NAV price. My transaction history shows 387.91 units added. I keyed in the transaction type as Dividend, Transaction Amt = RM 131.62, NAV = 0.3393 but the final unit comes out as 131.62 units.

Should i use the Transaction manual adj to change the units qty?
*
try key in ONLY the distributed (given) units quantity...??
raist86
post May 22 2017, 02:49 PM

Regular
******
Senior Member
1,577 posts

Joined: May 2005
From: USJ


ok.. that works...

cos i saw in the notes saying not to manually change anything in that column.
screwedpeep
post May 22 2017, 02:50 PM

Enthusiast
*****
Senior Member
909 posts

Joined: Feb 2011
From: Kerteh - KL - Ipoh - KB
QUOTE(raist86 @ May 22 2017, 02:40 PM)
Hi all, want to ask some advice. I'm using Polarbearz spreadsheet and keying in all my FSM transaction as of date. No issues with buying and selling transaction. but when comes to dividend from the Fund, the number of units does not tally with the amount.

For eg, 18 Apr 2017, CIMB fund gave a div of RM 131.62 @ 0.3393 NAV price. My transaction history shows 387.91 units added. I keyed in the transaction type as Dividend, Transaction Amt = RM 131.62, NAV = 0.3393 but the final unit comes out as 131.62 units.

Should i use the Transaction manual adj to change the units qty?
*
For dividend, you fill in units gained instead of total amount of the dividend received. It's not same as buy/sell where you put in amount.

EDIT: Tips for you. When you hover your mouse over the box of transaction type, you'll see a description on how to fill in the box.

This post has been edited by screwedpeep: May 22 2017, 02:52 PM

1554 Pages « < 238 239 240 241 242 > » Top
 

Change to:
| Lo-Fi Version
0.0215sec    0.81    6 queries    GZIP Disabled
Time is now: 23rd December 2025 - 06:39 AM