Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 Fundsupermart.com v11, Grexit or not, Europe will sail on...

views
     
ohcipala
post Aug 4 2015, 09:28 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(T231H @ Aug 4 2015, 09:21 PM)
hmm.gif some would also like consider this...maybe they are not up to it....eventhough they wanted good ROI...
*
What does annualized volatility mean?
ohcipala
post Aug 4 2015, 09:32 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(T231H @ Aug 4 2015, 09:31 PM)
OK thanks. :wink:
ohcipala
post Aug 11 2015, 09:16 AM

Regular
******
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...

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.  tongue.gif

====================

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.
*
Saved as reference thumbup.gif
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
ohcipala
post Aug 11 2015, 09:21 AM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Aug 11 2015, 09:16 AM)
IRR = annualised rate

Simple as that
*
So if I invest using DCA method, I should use XIRR?
ohcipala
post Aug 11 2015, 10:17 AM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Aug 11 2015, 09:40 AM)
Yes

Put 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
*
Thanks sifu

ohcipala
post Aug 13 2015, 07:27 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
What is CMF?
ohcipala
post Aug 25 2015, 01:45 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Aug 25 2015, 01:16 PM)
I'd top up across markets...

bond ar? not so keen tongue.gif
*
Top up across market means you top up equally across all regions?

Btw, wanna ask about CMF. Say today I buy rm1000 at 1.00. Tmr NAV is 1.01 and I sell it to invest in another fund. So I earn rm10?
ohcipala
post Aug 25 2015, 02:18 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(T231H @ Aug 25 2015, 02:13 PM)
hmm.gif the price movement of CMF is very slow....0.0X may takes weeks/months
after the gain of RM 10....if you buy another fund...you have to pay SC+GST
*
I was just confused about how FSM presented CMF with net interest rate of 3.468% as at 25th August. Just wanna understand how to calculate profit. It's exactly how you would calculate your IRR for other unit trust right?
ohcipala
post Aug 25 2015, 03:13 PM

Regular
******
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

The net rate of 3.468% is the aggregate rate of all the FDs (plus some cash) CMF currently holding.
*
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?
ohcipala
post Aug 25 2015, 03:27 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(T231H @ Aug 25 2015, 03:17 PM)
try read this FAQs on CMF
I think the answers to most of your doubt can be found there.
http://www.fundsupermart.com.my/main/faq/faq.svdo?id=9718
*
Thanks ya. Was looking for that page.

QUOTE(Pink Spider @ Aug 25 2015, 03:16 PM)
current value (units x price) LESS invested amount

The indicative net interest rate for CMF is just to give u an INDICATION of your future returns from CMF
*
Thanks again sifu
ohcipala
post Aug 25 2015, 05:51 PM

Regular
******
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.

http://www.fundsupermart.com.my/main/resea...?articleNo=6223
*
Finally thumbup.gif

nexona88 FSM heard you tongue.gif
ohcipala
post Aug 25 2015, 08:34 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Aug 25 2015, 08:31 PM)
Latest update:
12-months return: 10.5%
IRR: 6.2%

Saved a bit by RHB Asian Total Return and RHB Emerging Markets Bond sweat.gif
*
Mr Pinky can share share your portfolio ma?
ohcipala
post Aug 25 2015, 08:44 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Aug 25 2015, 08:39 PM)
RHB Asian Total Return 7%
RHB 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%
*
Thank you thank you. Wanna start investing via FSM this month. Might start with DCA considering market so volatile now
ohcipala
post Aug 26 2015, 02:22 PM

Regular
******
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.

I started out too heavy on GEM...have been gradually reducing over time...
*
Ignore this... Saw ur other post late

This post has been edited by ohcipala: Aug 26 2015, 02:25 PM
ohcipala
post Aug 26 2015, 08:09 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(yklooi @ Aug 26 2015, 06:55 PM)
rclxms.gif very true for me.....
hmm.gif while planning my initial portfolios...concentrated on too much past records of returns....
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...
*
What is QE?
ohcipala
post Aug 27 2015, 06:12 PM

Regular
******
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.

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".  tongue.gif
*
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.
ohcipala
post Aug 28 2015, 09:48 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(nexona88 @ Aug 28 2015, 08:47 PM)
Ponzi 1.0 ---> Affin Hwang Select Asia (Ex Japan) Quantum Fund

Ponzi 2.0 ---> CIMB-Principal Asia Pacific Dynamic Income Fund

Evergreen Fund ---> Kenanga Growth Fund

Aladdin Fund ---> Aberdeen Islamic World Equity Fund
*
Quoted for reference
ohcipala
post Sep 6 2015, 01:10 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
Is repurchase fee the same as redemption fee?
ohcipala
post Sep 16 2015, 11:54 AM

Regular
******
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 tongue.gif

Currently it only captures the snapshot - i.e. no further analysis on the raw data. Too lazy to do anything about it first tongue.gif

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..
*
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 thumbup.gif
ohcipala
post Sep 21 2015, 10:26 PM

Regular
******
Senior Member
1,338 posts

Joined: Sep 2012
QUOTE(Pink Spider @ Sep 21 2015, 10:14 PM)
Surprise surprise...

I actually topped up... rolleyes.gif

» Click to show Spoiler - click again to hide... «

*
Hopefully fund manager buy more now.. tongue.gif

2 Pages  1 2 >Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0331sec    0.46    7 queries    GZIP Disabled
Time is now: 7th December 2025 - 03:42 AM