Nothing better to do ... 

I'm very heavy in Asia ex Japan.

Looking at chart, I'd say Ringgit should trade at 4:USD1
But now my Developed Markets equity funds already 37% of my portfolio, I've stopped topping up. Recent topping ups were just to make up previous underexposure to DMs.

Looking at Ponzi 2.0 next, Singapore and HK has been quite bearish lately.

But in recent months my UTs have outperformed my stocks, so I'm moving more ammo to my stock trading account instead.

Was just calculating how my funds performed and yield a double digit IRR %. That's good right? Or should I say better than FD/EPF return?

IRR is annualized number. If 1 year period of IRR is 14%, then the full year is 14% and if 2 year period of IRR is 14%, then averagely is 7%. It depends on time period when you lock in for the IRR calculation.

EPF DY for 2015 is 6.75%

Why don't u try write direct to the Fund House?

Strange. I got mine back to 2012 as recent as September unless they just change their policy. What fund you need? See if I have it.

That's basically my portfolio with the exception of u having EI Small Cap while I have Affin Hwang Select Opportunity

Unfortunately I only have Ponzi 1, Titanic & EI SC up to 22/8/14 and Ponzi 2 up to 6/7/12. Let me know if you still want them, PM me your email address.

Yes, long term 8% IRR is consider good. Just that these few years market is considerably "good", I expect more that what I am getting with 90% EQ in my portfolio...

   I am struggling to get my IRR to double digits... 

My latest IRR < 9% 

Assume yo calculation is correct, is all yo funds > 1 yr?

In tis case, the IRR may not represent a true picture

Wow, IRR competition today?

75% equities here
12-months total return: 16.2%
IRR from commencement (Aug-08) to-date: 7.5%

Hello, my IRR is for my investment since Aug-08, it borne the impact of my initial beginner's mistake of buying "spicy" funds and switching out into cash during the bear market of 2010...

And my portfolio changed greatly since then...

Try "resetting" your worksheet to 17-Nov-14 (take holdings as at that date and delete off all earlier transactions) and recalculate your IRR, this will give u your 12-months IRR, for a more fair comparison with mine

My disposed funds are still in the worksheet to calculate IRR.

I think your IRR calculations tak betul la

When u sold off a fund, the current value will be zero. But so long as u keep the transactions within the XIRR formula range, your P/L on that fund will impact your overall IRR forever.

Back to basics of IRR...

KEY POINT - transaction

Each and every transaction must be captured along with the relevant dates.

When u sell off a fund, the proceeds from sale and the date of sale must be there.

And u must not delete any transaction line.

This is a general reply, and not specific to how the worksheet was structured...

1. Date and value of the fund "sold" should be there to be included into the IRR calculation; if you want to know the IRR of all investments since day 1. Otherwise, the IRR is only on the current portfolio of funds.

2. The whole portfolio was already assumed to be "sold off" at its latest current value in calculating the IRR.

3. Above "sold" means that. Don't confuse it with switching from one fund to another. These swithcing transations - one transaction in, and another transaction out nullified each other and nullified the cash flow. So don't have to keep track of switching transactions in IRR. The real "buys" and "sells" values and dates are needed...

TakoC

See screenshot attached.

My disposed funds, I move to upper section of my worksheet and hide them away (they're in Rows 384 to 618).

My current fund holdings are in Rows 620 to 796.

See my XIRR formula, it links up Rows 384 to 796, i.e. disposed holdings and current holdings are all included in the formula range.

I unhiddden one of my disposed holdings to illustrate treatment for disposed funds:
- I dumped all my units of Pheim Asia Ex-Japan on 13-Jul-2010 for RM1,546.72
- because I no longer have any holdings in that fund, cell F618 becomes zero
- Cells C618 and E618 no data needed, as units becomes zero, no current price and no current value

No way your disposed holdings would mess up your XIRR formula calculation.