QUOTE(T231H @ Sep 28 2016, 06:36 PM)
Oh ya horif it's RHB, should be RHB Asian Income Fund
If it's "Select", should be Affin-Hwang
Fundsupermart.com v15, 基金超市第十五章 - Rise the Dragon
|
|
Sep 28 2016, 06:42 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
16,872 posts Joined: Jun 2011 |
|
|
|
|
|
|
Sep 28 2016, 06:49 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
All Stars
24,429 posts Joined: Feb 2011 |
Guys, sorry for disturbing again, few more questions.
1a) How come the value didn't come out? 1b) What amount is it showing? ![]() 2a) I started with RM3k, how come it showed only RM1k? 2b) Any idea to update/fixit? ![]() This post has been edited by Ramjade: Sep 28 2016, 06:52 PM |
|
|
Sep 28 2016, 06:50 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
16,872 posts Joined: Jun 2011 |
QUOTE(Ramjade @ Sep 28 2016, 06:49 PM) Guys, sorry for disturbing again, few more questions. I suggest u to open my more basic worksheet and see how it works 1st before u use the more advanced one.1a) How come the value didn't come out? 1b) What amount is it showing? ![]() 2a) I started with RM3k, how come it showed only RM1k? 2b) Any idea to update it? ![]() |
|
|
Sep 28 2016, 07:04 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
5,143 posts Joined: Jan 2015 |
in Sept 2014 till May 2015...China funds made a GOOD uptrend before it corrected......
there are many reasons given for the correction during that time. now ...some China funds NAV are higher than the May 2015 Navs. ...has the reasons changed from the last time before the collapsed Attached thumbnail(s) |
|
|
Sep 28 2016, 07:07 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,498 posts Joined: Nov 2012 |
QUOTE(Ramjade @ Sep 28 2016, 06:49 PM) Guys, sorry for disturbing again, few more questions. Data entry got problem. Are you willing to bare all then it's easier to troubleshoot, just expand all lines1a) How come the value didn't come out? 1b) What amount is it showing? ![]() 2a) I started with RM3k, how come it showed only RM1k? 2b) Any idea to update/fixit? ![]() Amount should be the current value of your fund, so the amount you got there is wrong. If you keyed in the FSM code of the fund, then you can use the radio button "update current fund" at the bottom and it would be automatically pull the unit price of the fund for you For entrance value; you need to check that your grey subtotal lines are listed as 1 in column A |
|
|
Sep 28 2016, 08:13 PM
|
![]() ![]()
Junior Member
200 posts Joined: Mar 2015 |
QUOTE(T231H @ Sep 28 2016, 07:04 PM) in Sept 2014 till May 2015...China funds made a GOOD uptrend before it corrected...... Nobody knows for sure...there are many reasons given for the correction during that time. now ...some China funds NAV are higher than the May 2015 Navs. ...has the reasons changed from the last time before the collapsed http://www.bloomberg.com/news/articles/201...y-bumps-in-road http://www.bloomberg.com/news/articles/201...siness-optimism |
|
|
|
|
|
Sep 28 2016, 08:20 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,055 posts Joined: Nov 2015 |
|
|
|
Sep 28 2016, 09:11 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
All Stars
24,429 posts Joined: Feb 2011 |
QUOTE(dasecret @ Sep 28 2016, 07:07 PM) Data entry got problem. Are you willing to bare all then it's easier to troubleshoot, just expand all lines Figured it out. Amount should be the current value of your fund, so the amount you got there is wrong. If you keyed in the FSM code of the fund, then you can use the radio button "update current fund" at the bottom and it would be automatically pull the unit price of the fund for you For entrance value; you need to check that your grey subtotal lines are listed as 1 in column A Now it's all back to normal. IRR is now -1.96 ROI is now -0,02 |
|
|
Sep 28 2016, 09:21 PM
|
||||||||||||||||||||||||||||||||||||
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
4,726 posts Joined: Jul 2013 |
QUOTE(Avangelice @ Sep 27 2016, 01:10 PM) That's what i thought on the dca on Bond fund. Doesn't make sense. Thank you for informing me. Not to sound interrogative but i'm really curious.As for my retirement. It's maybe ill retire at age 70 continuing doing my work to heal people while letting funds run their course so I'm planning short term goals to turn into long term ones why would you want to bank on your profits... at 15%? there must be stated timeframe. 15% in 5 years is not ideal for UT investment (might as well throw the money in FD). and i feel like by doing that, the compounding effect is gone. anyway, i point out i was bitten during volatility of bond fund, which while usually bond funds are less volatile, the market shock possibility is still there. End of month portfolio sharing, Age of portfolio, 2y, 1m, 10d
This post has been edited by adele123: Sep 28 2016, 09:33 PM |
||||||||||||||||||||||||||||||||||||
|
|
Sep 28 2016, 09:34 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
5,274 posts Joined: Jun 2008 |
QUOTE(adele123 @ Sep 28 2016, 09:21 PM) Not to sound interrogative but i'm really curious. 15% is in a span of 1 years to two years max then I'm skimming the profits. I know some people rather leave them alone so they can compound but my plan of skimming profits only from unstable volatile equities and pushing them to fixed income funds there it can still generate roi better than FDs which is shit. why would you want to bank on your profits... at 15%? there must be stated timeframe. 15% in 5 years is not ideal for UT investment (might as well throw the money in FD). and i feel like by doing that, the compounding effect is gone. anyway, i point out i was bitten during volatility of bond fund, which while usually bond funds are less volatile, the market shock possibility is still there. I regretted not setting that same goal for Titans when it reached 18% and then it dropped. True enough my entire portfolio looked better when I rebalanced it (cough dumped it) My total roi 6.42%. Age 1 year and 2 months. Started with my first purchase with titans. I switched all my RHB TRF to Libra This post has been edited by Avangelice: Sep 28 2016, 09:40 PM |
|
|
Sep 28 2016, 09:56 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,259 posts Joined: Sep 2009 |
|
|
|
Sep 28 2016, 09:57 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,259 posts Joined: Sep 2009 |
|
|
|
Sep 28 2016, 11:30 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,932 posts Joined: Sep 2007 |
QUOTE(Ramjade @ Sep 28 2016, 06:49 PM) Guys, sorry for disturbing again, few more questions. If you don't know what it means, don't worry about it. It was meant for the person who designed and programmed it, not you.1a) How come the value didn't come out? 1b) What amount is it showing? 2a) I started with RM3k, how come it showed only RM1k? 2b) Any idea to update/fixit? If you don't have basic spreadsheet/macro skills, asking questions like "How come the value didn't come out?" is unlikely to get you a reply that you can understand. What the spreadsheet macro does is call a URL end-point of the fund code as a ? parameter. and parse the resultant HTML page and look for the current NAV, and update the spreadsheet cell. Well, if you need more information, just ask the source you got the information from. This post has been edited by howszat: Sep 28 2016, 11:31 PM |
|
|
|
|
|
Sep 28 2016, 11:40 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
All Stars
24,429 posts Joined: Feb 2011 |
QUOTE(vincabby @ Sep 28 2016, 03:28 PM) first you need to ungroup and then group them in a new one. i figured out the way yesterday. after you copy your new fund( white and grey boxes) as stated in their instructions, you will see dots at the side. ungroup the cells with dots. then, group the cells all except the grey one. you have your collapsible group. you will now u done it right when the grey box is the only one showing. if not, undo and try again. Thanks. Got it. QUOTE(howszat @ Sep 28 2016, 11:30 PM) If you don't know what it means, don't worry about it. It was meant for the person who designed and programmed it, not you. Nevermind all the technical stuff. Asal can work and can get the results. If you don't have basic spreadsheet/macro skills, asking questions like "How come the value didn't come out?" is unlikely to get you a reply that you can understand. What the spreadsheet macro does is call a URL end-point of the fund code as a ? parameter. and parse the resultant HTML page and look for the current NAV, and update the spreadsheet cell. Well, if you need more information, just ask the source you got the information from. Anyway how I got it to work: 1) Delete everything except fund A cause I noticed if use fund B template, results won't show correctly. 2) Recopy back fund A, rename it to fund B and give it a test. Result shows exactly like how FSM shows it + IRR + ROI 3) Repeat the process for fund C |
|
|
Sep 28 2016, 11:50 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,932 posts Joined: Sep 2007 |
QUOTE(Ramjade @ Sep 28 2016, 11:40 PM) Thanks. Got it. How or why not important then.Nevermind all the technical stuff. Asal can work and can get the results. Anyway how I got it to work: 1) Delete everything except fund A cause I noticed if use fund B template, results won't show correctly. 2) Recopy back fund A, rename it to fund B and give it a test. Result shows exactly like how FSM shows it + IRR + ROI 3) Repeat the process for fund C You got something that works for you, great. |
|
|
Sep 29 2016, 01:17 AM
|
![]() ![]()
Junior Member
125 posts Joined: Dec 2012 |
QUOTE(guy3288 @ Sep 28 2016, 04:20 PM) only if everyone is as open minded like that, the world would have been a better place.. just i dont like the way you say it.i have put forth my contrarian views clearly, how many understand what you said above? same like your Maybank share analogy (again poor analogy) RM9.00 or RM10.00 but you offered to buy only RM8.00 from RAM (but he was clever not to be cheated, he sold you at RM8.00 only when the price was RM7.69, so he is not stupid after all.) isn't it much clearer after you use my straight to the point message, you only waste your effort if you dont make them understand, me not included as i actually know what you mean, just i dont like the way you say it. Arent you abit late now (return sudah jatuh lo) yes his 6.7-6.9% vs shakeleg lose nothing 6.1%, i wont fancy much. -> I feel exactly the same. he speaks like he owns this forum. if it is so difficult to explain then simply don't bother. This one is like have to mock and scold first then tell something. yes his 6.7-6.9% vs shakeleg lose nothing 6.1%, i wont fancy much. -> yup, 6.7-6.9% and then give a lot of 'if only', 'imagine if' yada yada. |
|
|
Sep 29 2016, 02:14 AM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,392 posts Joined: Dec 2009 |
|
|
|
Sep 29 2016, 07:55 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,166 posts Joined: Jul 2016 |
What is the difference between REITs and RE listed equities?
I see that amasia pacific REITs (I invested here) has REITs to cash ratio of 7:3 While the plus version has the same ratio but with REITs to (cash plus RE listed equities) |
|
|
Sep 29 2016, 09:06 AM
Show posts by this member only | IPv6 | Post
#819
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
3,816 posts Joined: Feb 2012 |
QUOTE(AIYH @ Sep 29 2016, 07:55 AM) What is the difference between REITs and RE listed equities? My guess is RE listed equities are property companies.I see that amasia pacific REITs (I invested here) has REITs to cash ratio of 7:3 While the plus version has the same ratio but with REITs to (cash plus RE listed equities) But you may want to confirm with FSM. This post has been edited by river.sand: Sep 29 2016, 09:06 AM |
|
|
Sep 29 2016, 10:04 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,185 posts Joined: Dec 2011 |
QUOTE(tmc @ Sep 22 2016, 03:43 PM) I have a portfolio in this proportion :- Plan to rebalance to make it in this proportion :-1. CIMB-Principal Asia Pac Dynamic Income - 25 % 2. Eastspring Inv Global Emerging Markets - 25 % 3. Kenanga Growth Fund - 25% 4. RHB Asian Income Fund - 25% Anyone care to give some comments on it ? Any recommendation how I should re-balance or add new fund ? 1. CIMB-Principal Asia Pac Dynamic Income - 20 % 2. Eastspring Inv Global Emerging Markets - 20 % 3. Kenanga Growth Fund - 20% 4. RHB Asian Income Fund - 20% 5. TA Global Tech - 10 % 6. Eastspring Inv Global Leaders MY Fund - 10% Any comments ? |
|
Topic ClosedOptions
|
| Change to: | 0.0318sec
0.85
6 queries
GZIP Disabled
Time is now: 19th December 2025 - 04:53 PM |