QUOTE(T231H @ Aug 4 2015, 09:21 PM)
Fundsupermart.com v11, Grexit or not, Europe will sail on...
Fundsupermart.com v11, Grexit or not, Europe will sail on...
|
|
Aug 4 2015, 09:28 PM
Return to original view | Post
#1
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
|
|
|
|
Aug 4 2015, 09:32 PM
Return to original view | Post
#2
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(T231H @ Aug 4 2015, 09:31 PM) OK thanks. :wink: |
|
|
Aug 11 2015, 09:16 AM
Return to original view | Post
#3
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(j.passing.by @ Aug 11 2015, 12:19 AM) yklooi, the above and your other posts on same topic of IRR and annualised rate referred... Saved as reference 1) Basically, annualised means 'making the rate into an annual rate or a yearly rate'. 2) If the maths is correct, it cannot be 'more accurate'. Or less accurate. 3) For example: Start value = 10k End value = 13k ROI is 3k. ROI can also be expressed in percentage: 3k / 10k = 30% If the time taken to get the 30% growth rate is 3 years, then the IRR (the annualised rate) is: =(1+30%)^(1/n)-1 (where n is the 'time taken') =(130%)^(1/3)-1 = 9.14% 4) More examples: If the fund grows 1% in 1 month, then the IRR is = (101%)^(1/(1/12))-1 = 12.68% If the fund grows 1% in 30 days, then the IRR is = (101%)^(1/(30/365))-1 = 12.87% If the fund grows 3% in 90 days, then the IRR is = (103%)^(1/(90/365))-1 = 12.74% If the fund grows 6% in 180 days, then the IRR is = (106%)^(1/(180/365))-1 = 12.54% And if the fund grows 36% in 3 years, then the IRR is = (136%)^(1/(365x3/365))-1 = (136%)^(1/3)-1 = 10.79% 5) From the above examples, so how is that the IRR is "less accurate" when the time take by an investment is less than 1 year? As mentioned; when the maths is correct, it cannot be less accurate or more accurate. 6) Please remember that the IRR is "making the ROI rate to an annual percentage". So, if you buy a fund today, and it increases by 0.3% the next month or in 30 days, the ROI is 0.3%. The IRR is = (100.3%)^(1/(30/365))-1 = 3.71% If you buy another fund today, and it jumps 3% tomorrow, the ROI is 3%. The IRR is = (103%)^(1/(1/365))-1 = 4848172.45% The former fund could be a money-market fund, and the latter a volatile fund. And yes, the latter fund has a very huge IRR, since, inside the maths, it was projected to grow 3% every day for 365 days, and it was being compounded daily! So don't blame the maths if you don't know or understand what you want but simply annualised the ROI to IRR. ==================== Further notes: 1) IRR is the same as CAGR. 2) XIRR is the name of a function in the Excel spreadsheet. 3) IRR is a simple formula (as shown in above examples). It used in calculations with only one start value or one purchase. 4) The formula in XIRR is more complex; it is a recursive formula; and it is used to calculate the IRR in multiple purchases. BTW, if I'm using DCA, then I have to use the XIRR method right? This post has been edited by ohcipala: Aug 11 2015, 09:17 AM |
|
|
Aug 11 2015, 09:21 AM
Return to original view | Post
#4
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
|
Aug 11 2015, 10:17 AM
Return to original view | Post
#5
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(Pink Spider @ Aug 11 2015, 09:40 AM) Yes Thanks sifuPut it simply... E.g. U invest RM100 in January RM100 in February RM100 in March Now is August... The RM100 in January has 7 months to "work" RM100 in February has 6 months... And so on... XIRR formula is a compound/average measure that lets u know how hard they have "worked" for u |
|
|
Aug 13 2015, 07:27 PM
Return to original view | Post
#6
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
What is CMF?
|
|
|
|
|
|
Aug 25 2015, 01:45 PM
Return to original view | IPv6 | Post
#7
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
|
Aug 25 2015, 02:18 PM
Return to original view | IPv6 | Post
#8
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(T231H @ Aug 25 2015, 02:13 PM) after the gain of RM 10....if you buy another fund...you have to pay SC+GST |
|
|
Aug 25 2015, 03:13 PM
Return to original view | IPv6 | Post
#9
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(T231H @ Aug 25 2015, 02:27 PM) click at the CMF historical pricing to have a look of how its NAV moves in the past 3 months http://www.fundsupermart.com.my/main/fundi...tpl?id=MYOSKCMF QUOTE(Pink Spider @ Aug 25 2015, 02:19 PM) CMF is mostly fixed deposits So calculation of profit for CMF is like how you would do for any other unit trust right, which is based on the difference of number of units*NAV?The net rate of 3.468% is the aggregate rate of all the FDs (plus some cash) CMF currently holding. |
|
|
Aug 25 2015, 03:27 PM
Return to original view | IPv6 | Post
#10
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(T231H @ Aug 25 2015, 03:17 PM) try read this FAQs on CMF Thanks ya. Was looking for that page. I think the answers to most of your doubt can be found there. http://www.fundsupermart.com.my/main/faq/faq.svdo?id=9718 QUOTE(Pink Spider @ Aug 25 2015, 03:16 PM) current value (units x price) LESS invested amount Thanks again sifuThe indicative net interest rate for CMF is just to give u an INDICATION of your future returns from CMF |
|
|
Aug 25 2015, 05:51 PM
Return to original view | Post
#11
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(EightPhantomz @ Aug 25 2015, 05:48 PM) FSM Merdeka Promotion - 0.57% *Sales Charge - All Funds from 27th August to 1st Sept. Finally http://www.fundsupermart.com.my/main/resea...?articleNo=6223 nexona88 FSM heard you |
|
|
Aug 25 2015, 08:34 PM
Return to original view | Post
#12
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
|
Aug 25 2015, 08:44 PM
Return to original view | Post
#13
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(Pink Spider @ Aug 25 2015, 08:39 PM) RHB Asian Total Return 7% Thank you thank you. Wanna start investing via FSM this month. Might start with DCA considering market so volatile nowRHB Emerging Markets Bond 20% CIMB Global Titans 15% Aberdeen Islamic World Equity 12% CIMB Asia Pac Dynamic Income 12% Affin Hwang Select Opportunity 5% Affin Hwang Asia ex Japan Quantum 12% Eastspring Global Emerging Markets 18% |
|
|
|
|
|
Aug 26 2015, 02:22 PM
Return to original view | Post
#14
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(Pink Spider @ Aug 26 2015, 11:00 AM) If u wanna replicate...I suggest u increase allocation for Global Titanic, reduce Eastspring GEM. Ignore this... Saw ur other post lateI started out too heavy on GEM...have been gradually reducing over time... This post has been edited by ohcipala: Aug 26 2015, 02:25 PM |
|
|
Aug 26 2015, 08:09 PM
Return to original view | Post
#15
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(yklooi @ Aug 26 2015, 06:55 PM) expected to hit 10% min (if all the selected funds of my portfolio "were" to perform just 80% of their averages...) then the taper tantrum came....then talks of QE stoppings,....then Russia Ukraine things,....then North south korea things,.... then Fed rate talks,..... then Oil prices drops,......then RM falls,....then now Fed Rate coming,...then China growth slowed,.....then China Devalued,....then...then...then.... now XIRR is abt 2%...ha-ha... |
|
|
Aug 27 2015, 06:12 PM
Return to original view | Post
#16
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(j.passing.by @ Aug 27 2015, 05:38 PM) No, it is not. "Opportunity cost" is the loss of other alternatives when one alternative is chosen. And all the alternatives are equally viable and available for selection. I guess it's either you choose time and effort to do research or you pay a bit extra and let fund managers do the work for you.If we don't see the other alternatives as equally viable for selection (ie. there is no knowledge and interest to pick stocks), then there is no lost in opportunity. "Lost opportunity is better than lost money". |
|
|
Aug 28 2015, 09:48 PM
Return to original view | Post
#17
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
|
Sep 6 2015, 01:10 PM
Return to original view | Post
#18
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
Is repurchase fee the same as redemption fee?
|
|
|
Sep 16 2015, 11:54 AM
Return to original view | Post
#19
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
QUOTE(polarzbearz @ Sep 16 2015, 10:45 AM) It's not in the latest file yet, it's on my personal file Can't wait for you to share your latest file. Just managed to play with the one you shared on post#1 and find it very useful Currently it only captures the snapshot - i.e. no further analysis on the raw data. Too lazy to do anything about it first The MoM and YoY got two section, one captures the snapshot of the WHOLE portfolio, and another captures the snapshot of each and every fund individually. However, as I said, it's just a snapshot (i.e. rows of data in the previous screenshot), no further analysis is added (i.e. chart) in the file, yet.. |
|
|
Sep 21 2015, 10:26 PM
Return to original view | Post
#20
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,338 posts Joined: Sep 2012 |
|
|
Topic ClosedOptions
|
| Change to: | 0.0331sec
0.46
7 queries
GZIP Disabled
Time is now: 7th December 2025 - 03:42 AM |