QUOTE(wongmunkeong @ Apr 23 2012, 07:47 PM)
Congrats Xuzen.
I gotta spend U some good food one day AND suck your brains dry on "how to.." calculate all that for an entire portfolio

I baka - only can track stats per transaction and per fund/stocks/fixed incomes/properties/etc.
Mostly due to a changing variable (and my own blurness with stats) - available resources (monthly savings for investments & EPF), which also influences asset allocation and total assets (net worth and investment/investable assets).
Really need to kacau U one of these days, can ar? I hope you're around Klang Valley heheh

Now lets get down and dirty to the mathematics section: I will not explain all the terms here as I assume you can google them.
1) Look through your assets. Look at their past return, lets take 3 years, now, annualized their return. You may take 5 years or whatever years, but my data is 3 years only. So I'll stick with three years. Remember to take the annualized return and not the absolute return.
2) Now, do a standard deviation calculation of your assets return. Formula = [(Sum of [individual rtn - mean rtn]^2)/n]^1/2. If you want to use Semi-deviation instead of standard deviation, then count only the assets which have a rtn below the mean instead of all points. But the n remains the same.
3) Now you would have a return and her corresponding standard/semi deviation.
4) To calculate risk adjusted performance (aka Modigliani^2 ratio) = [(Rtn of your portfolio - Risk free rate)/Stan-Dev of portfolio] X Stan-Dev of benchmark + Risk Free Rate. NB: I used KLCI as my bench mark and One year FD in local bank as my risk free rate.
5) Value at Risk is given by the formula = Mean Portfolio Rtn + (zeta x Stan-Dev of portfolio) where zeta is taken as -1.64. The assumption is that zeta is -1.64 for a normal distribution curve at 95% confidence level.
Don't ask me more about this zeta value, I just take it as gospel truth from my lecturer, I am a pragmatic person, therefore I am not so concern for its theory and how zeta is derived.
WongMK, wrt you belanja me makan, not necessary, as long you think what I say is useful and is not bullocks and as long as other who are interested about personal investing find my post useful for them, that is reward in it self. Beside, I am not living in Klang Valley. Very far from it.
Xuzen
Added on April 24, 2012, 7:04 pmQUOTE(Malformed @ Apr 24 2012, 04:46 PM)
Hello xuzen,
Good to hear someone reading the CASHFLOW Quadrant. I have read it and about to finish the book, but I have yet to begin the 7 steps he had written at the end of the book. Then today I came across this
post - which made me thinker. Although I know that it a writer may be writing all sorts to be a bestseller, CASHFLOW Quadrant indeed has shone light to me, so I decided to continue his guidance despite what others say about him. I just came out to work but I do want to start early in moving to the right side of the quadrant.
How old were you when you read the CASHFLOW Quadrant? I am buying funds from PM, but I am investing in a recommended fund as a start.
I don't know how well did it perform, or determine how well will it be able to perform, but I believe it is a good start to get involved. What do you think?If you do not do any financial analysis of your fund, how could you confidently answer this. As usual, we can never predict how it will perform in the future.
That is why there are so many ratios and theory made by the financial gurus to measure and mitigate the risk but not the return.
Please note that in most of this theories/ratio, the risk is more important than rtn.
As one famous investor puts it (can't remember who): Take care of the risk, and the profits will take care of itself.
But as a start, buy The Edge weekend newspaper, look at the Normandy Fund Table and choose the fund that has high Sharpe Ratio... that can be a good start.
Happy investing, Malformed.
Xuzen
This post has been edited by xuzen: Apr 24 2012, 07:04 PM