Good effort. I did these when i start investing many many years back. Ok ... what i really want to know is 1. your fund value (including the CASH) at "beginning" and "end" of every year for annual rate calculation.. 2. and state the date and how much every time u inject new cash into the fund. Cheers.
BearbearDrop Some dividend return appears high as I am calculating based on dividend yield adjusted to the cost price. It may not be so high if we calculate based on trailing 12 month DY.
leno, that would require some work to do. I did not keep track on when I inject new cash into the fund or how much percentage of cash I hold for that certain year. I only keep track of my current cash holding %, the date I bought/sold a stock and the amount of units. But I would prefer not to disclose it. Cheers.
u dun need to disclose it ... but u need to know these for your self. If u haven't done so ... u must start to do it. U can start by now. How much is your stock worth now and how much cash in the fund (meaning Cash in your share account). U dun need to included cash in your saving account. Onli those cash u transfer from saving account into share account. Open a new excel page, and record it down. For eg. 01/11/2015 inject RM 1,000 cash into share account.
in another excel page ... u should have a portfolio BALANCE SHEET. In Balance sheet ... u should list down preferably "horizontally" instead or vertically your cash and all the stocks VALUE u own. For eg. Capital : Total Fund Value : Net : %Net : Cash : X-Div : padini : spsetia : opensys : etc.
sometime I will go to the realized p&l section to revise the result, the issues I found is they didn't include the brokerage fee for every purchase and repurchase transaction into the realized p&l calculation may be it taste better for the viewer, so I need to copy them individually into excel sheet and correct them In the end it is still the cash on hand that matter the most So remember to keep track record of it every once a while I prefer to keep it every month end
For once I see Leno is well behaved. So good to see a tame cute cat again.
Here let Calvin tell you a stock that will protect you from the erosion of your purchasing power.
Go see GMutual
Last week I visited MAPEX in Johor. I got a nice surprise to note that their iconic Austin 18 Versatile Suites which are commercial soho right at the traffic junction in Mt Austin have already sold over 80%.
A check with GMutual website reveals that even GMutual Bosses are buying these sohos themselves.
Gmutual Bosses are very conservative businessmen who regularly attend OSK-RHB Investment Talks. They also own Dominant Ent.
All GMutual properties are LANDED Houses, Commercial Shops or Industrial factories in Johor and Melaka. (Fortunately no high rise condo).
So at 42 cents with NTA over 80 cents plus Good EPS and dividend GMutual will help all to Grow Mutually.
Grow Mutually?
YES! I and many Johor Buddies Have Mutually Made 5 to 6 figures in Pm Corp. This is what GMutual stands for.
like i said ... during early stage .. newbies will tend to do like u do ... i last time also record all this. Now i am in different stage liaw ... hope u one day will reach my stage ... then u will say the same thing like i just did. At my stage ... i no need record so detail all this small small issues mar. It is the bigger picture that i look at. For eg. who care how much i bought or sell LCTH or PMCorp LAST TIME. I onli ask ... what is the current value of LCTH, what is the buy/sell price, what is my current cash, exposure, what is the near term outlook etc. For eg. let said i sold LCTH 13 sen last month ... doesn't mean i will not buy back LCTH at 20 sen.
I am using I3's "Portfolio" to follow up the performance of my stock investment. You need to key in all the transactions including buy,sell,dividend,bonus,split etc. You can set the commision rate and even GST rate.
The "Snapshot" and "Wealth creation" are the sites that I can view my return either current total return or cumulative return and capital change monthly, quarterly and yearly.
You can view individual stock's all time performance easily and the records are kept though you have sold them.
I find that it is simple to use and save your time in calculation of the stock performance in term of realized and unrealized gain & dividend received too.
If read shinado and kc chong blogs many people assume they and buy and hold stocks with not much trading. If read other people comments(Leno, ks55) there a lot of trading even in few stocks. Which one is true and which method is better? How about future performance even if past is good?
This book is the result of the author's many years of experience and observation throughout his 26 years in the stockbroking industry. It was written for general public to learn to invest based on facts and not on fantasies or hearsay....
NOBY
936 posts
Posted by NOBY > 2015-11-13 22:32 | Report Abuse
Consider using time weighted returns and XIRR to calculate annualized returns.
http://www.oldschoolvalue.com/blog/investment-tools/calculate-xirr-annualized-returns/