Tuesday, January 8, 2013

Making full use of Bloomberg Portfolio Tracker and DIY portfolio tracker

I've not found any portfolio app/software that match my needs perfectly. So the workaround is to use a few portfolio tracker to manage my portfolio.

1) DIY

I've my own portfolio tracker in Excel spreadsheet but it's mainly on the money management aspect.  The key aspects of this spreadsheet is to monitor the individual position sizing, the trailing stop-loss (15% from highest price achieve since purchase), % wrt 50d ma and 200dma(I'm lazy, i do not have to go see which chart individually), the MAX loss from purchase px to the 52wk low(just a theorectical test but of course it can break below 52wk low).  I've also added forex to calculate everything into SGD Value. All these are updated automatically when you go to the spreadsheet. Dividends/Coupons collected are tabulated into monthly schedule in another worksheet.

I've got a separate Cashflow and networth tracker that documents all major monthly expenses(budgeting yearly) and income yearly and the composition of the networth (different bank accounts with liabilities and bonds and shares etc).

For my fundamental analysis(the quantitative side), I have also done up an  Excel spreadsheet that will take in bloomberg/reuters financial data and then compute all the things I am looking for including :-
1) 10 "Buffettology" score sheet - Current Ratio > 2, Total Debt/Equity Ratio < 33%, Total Debt/Avg FCF < 5 etc
2) Fiscal Fitness score sheet -> Dealing with profitability, Debt & Capital, Operating Efficiency and altman Z-score
3) Projected DCF and ROI compared to Treasury bonds(or any sovereign bonds of the country the stock is based in), CARG as an equity/bond, CARG using historical annual EPS growth.

This will then be ranked with scores with the key variables of P/E, P/B, P/S, EV/FCF, EPV using FCF, Buffet's bkvalue, DCF.

Anyway, this is just to make certain you did your homework. Whether it translates into a good pick is anybody's guess. However, I have so far have good results with this method of doing stock selection. Looking back at my portfolio, those that are negatives results are around 1/6. The whole portfolio have returned (including dividends) a compounded annual growth rate of  around 10% since 2009.  Of course, it helps that it was a rising market and stocks i'm interested in are mainly blue-chips and companies that have been around for 10yrs.

2) Major Financial Market Providers

Bloomberg, Reuters, Shareinvestor all have good portfolio tracker. Reuters portfolio will automatically update the dividends received and any stock action(splits) into your account. Shareinvestor is mainly focused on STI and you get very good news on every stocks in your portfolio at a glance with insider trades, P/E, P/B etc etc. Bloomberg has a good watchlist with fundamentals, earnings in it.

Of particular interest to anyone who wants to know instanteous STI index or S&P index P/E ratio and P/B Ratio. You can do the following :-

You have to go to Personal Finance -> Watchlist(portfolio tracker). You can then add in this few stocks.. FSSTI:IND . SPX:IND
for other indexes..just do a search and see what is the code.
Once you add in to your watchlist, click on fundamentals and you will get what you want. 

No comments: