Pink Spider I remembered you said investing in a emerging market fund is very volatile. Would you still say it's more volatile as compared to current SHCOMP stocks where index can fluctuate a few % every day?

Just curious.

EM fund is investing in sooooooooo many EMs...whereas SHCOMP is only China...of course single market is more volatile

just asking.....about the XIRR calculation....
example if
Portfolio started investing in 1 Jan 2010 RM 10000
Portfolio grow to RM 13000 in Jan 2013
ROi is 30%...Xirr is about 9.x%

if the growth stagnated in whole of 2013.....(which means Rm 13000 remains through out the whole year).
does the XIRR value remains the same in every month from Jan 2013 till Dec 2013?
if yes,....will the XIRR suddenly changes in Jan 2014?

I may be seriously wrong...I think most XIRR formula did not have "month" factor in it. which means the results are the same in Jan, March, June, Sept.......anyone can confirm?

This post has been edited by yklooi: Aug 9 2015, 09:17 PM

XIRR will change based on end date, assuming U place the last date as "=TODAY()"
Thus, if used properly - it'll change every DAY, not just every month... if U changed the end date lar

This post has been edited by wongmunkeong: Aug 9 2015, 09:16 PM

I may be seriously wrong...I think most XIRR formula did not have "month" factor in it. which means the results are the same in Jan, March, June, Sept....... can you PLEASE confirm if the XIRR value changed when the month are changed ?

This post has been edited by yklooi: Aug 9 2015, 09:20 PM

Maybe you use the wrong formula?

My XIRR uses a function that calculate IRR up to days instead of months. LOL

bro, as long as your XIRR is setup as below, it'll be good
eg
ColA; ColB
1/1/2013; -10000
1/2/2013; -10000
1/3/2013; -10000
.
.
.
=Today();-SUM(Bx:By) ie sum all the rows above for row B but negative it, ie turn it positive

thanks tested mine....xirr value changes when the month changes
I just saw this,...
the "Last" example.....
he has this....
Excel XIRR returns a compounded annual rate. If you want the equivalent compounded 9-month rate, you would use the following paradigm (see the screenshot below):

(1+XIRR(F2:F6,A2:A6))^(9/12) - 1

http://answers.microsoft.com/en-us/office/...6a3ece70?auth=1

therefore I am just curious...he has this month factor in there and therefore I asked.

If you use YEARFRAC(), then it'll in term of days. LOL

use in "where"?
using Pinky's irr excel file in post#1 for example

This post has been edited by yklooi: Aug 9 2015, 09:36 PM

I guess should be:

(1+XIRR(F2:F6,A2:A6))^(9/12) - 1

to YEARFRAC(STARTDATE,ENDDATE)

URL: https://exceljet.net/excel-functions/excel-yearfrac-function

Thanks YKLooi.
Heheh - way too complicated for me.
I just use IF >=365, then show the XIRR, else show simple returns

was wondering,...since many had said that, for investment of less than1 year, the XIRR calculation is not accurate....
will using this (the above) will solve the problem?

Won't accurate as IRR is more meaningful for > 1 year.

This post has been edited by David83: Aug 9 2015, 10:11 PM

won't as in not accurate?

I recall some months back.....some forummers "posted" about their high IRR rate...
though of thinking that this formula can be used to avoid confusion...

High IRR is misleading if holding is too short.

You can have high IRR from China funds if you invest less than 1 year.

yes,....
what if 'that formula" were to be used....will it shows a more accurate representation?

Also won't. I'm an engineer. It's normal for me to use formula up to certain precision until number may not be meaningful.

yes......I would understand if it was referring to x.xxxx vs x.xxxxxxxxxx in IRR cal
but for irr cal of less than 1 yr that formula would not be good to be used also?

This post has been edited by yklooi: Aug 10 2015, 01:13 AM

You meant the formula that Pinky used?

IRR is just an indicator.