QUOTE(cheahcw2003 @ Aug 10 2012, 11:17 PM)
wong sifu,
i opened the excel file and notice u highlight 2 funds that i have invested, i.e. P Small Cap, and P Focus Select, are these 2 funds outperform?
P Focus Select perform better in 3 years tenur than the 5 years tenur, P Small Cap the other way round.
No sifu, just "see food" (eat food) bro

.
Eh? I highlighted the 2 funds coz the numbers (all in all) looked good for 3, 5 and 10 years (if i remember correctly lar - done this in Apr wor

).
Note - that Excel was for my own monkeying around to see whether the JA ratio thinggy helps the probability of picking a fund that outperforms due to the fund manager(s). Looks to be true for PSmallCap, though i need to test it out with "bad endings" before executing anything - fish, my new PC and FPAdvisor doesn't play well, can't get the results out yet
I've yet to test it out across "bad endings" - ie. 10yrs, 5yrs and 3yrs ending Dec 2008 or Jan 2009
That Excel i shared was years ending April 2012 only, which, if it's a 5 years or 3 years range, is to me, considered "good endings" since end 2008 lelong.
Thus, please don't read way too much into it ar hehe. Main purpose i shared that Excel was how i calculated JA ratio based on PM's FPAdvisor's output.
Added on August 11, 2012, 5:32 amQUOTE(echoesian @ Aug 11 2012, 12:00 AM)
Which one should look for? Jensen Alpha or Fund Sharpe Ratio or Benchmark Sharpe Ratio? The higher number the better?
Generally?
I'd start with a filtered list of 10yrs, 5yrs & 3yrs "good ending" + another set "bad ending" (minimum 3 & 5yrs) stats, filtering for:
1. Top 1/3 highest CAGR - for total returns lar, i care crap if all else look good but CAGR bottom 25%
2. Top 1/3 highest Fund's Sharpe ratio - general risk/reward of the fund is much more important than its benchmark
3. Top 1/3 highest JA ratio - the fund manager(s) "alpha-bility"

Old style - i highlight the funds which appears in all 6 lists (10yrs, 5yr, 3yrs) like using a highlighter in Excel
THEN
4. Then only i go check out the normal lor like Lippers & MorningStar - just to see if it's at least 4 stars / above average, in case i screwed up or data screwed up
5. Then look at the funds' prospectus to see whether or how it can fit my planned Asset Allocation.
6. Then start a programmatic investment for 3 years minimum.
Will stop and change IF at the end of 3 years or going into 4th, most funds up and this particular fund's returns STILL down.
If fund's return is down a year, no biggie but continuously down for like 3 years+ WHILE others are growing or positive for the similar time-line, time to re-think it and fix the mistake IMHO.
---------------
Jiran jiran sekalian - pls do ask the real sifu, Xuzen, if really detailed info required (whys and whats and hows) on Jansen Alpha ratio if Wiki or Investopedia doesn't satisfy U ar. I picked up the ratio from Xuzen then Wiki-ed / googled it to see whether interesting to use with my other filters or not - thus no expert wielder of JA ratio
This post has been edited by wongmunkeong: Aug 11 2012, 05:39 AM