TIPBlog Portfolio Update: 2009 Year End

UpdateWhat a year 2009 was? At the beginning of the year, the stock market was trying to find how deep the abyss was. Every other participant in the equity market was trying to run away like there was no tomorrow. Fast forward to second half of the year. The story changed and now the stock market is trying to find its peak. It was in true sense a roller coaster ride.


When the equity market goes up like it did in later part of the year, it gives a false sense of confidence in our abilities to pick stocks. Irrespective of what one thinks, any company stock you had touched in second of 2009, it has zoomed. It really did not matter which company stock it was! Lately, I have seen quite a bit of emails trying to point me towards how the stocks that I negated (or did not pick?) have zoomed up and made them money. I do feel happy for everybody who made good money in 2009. I wish you had shared those winners with readers of this blog. We all want to make money here. Right? Continue reading rest of this article…

Portfolio Rebalancing

howTwo readers of this blog left couple of intelligent questions in comment section on some of the articles. Both of these questions relate to what I term as rebalancing the portfolio (or profit booking). I wanted to wait until I posted articles on TIPBlog portfolio update and risk analysis. I wanted to discuss these two questions in the context of TIPBlog portfolio. It will help better understand the re-balancing and profit booking processes.

You may have read earlier post that discusses risk analysis. I made a comment that the portfolio has overexposure on few stocks like ONGC, LNT, etc. I also mentioned that I will not be selling any partial shares to bring down allocation. Many use the term profit booking for partial selling.

Continue reading rest of this article…

Measuring Progress – Stock Tracker Excel Sheet

monthly-dividend-portfolio-reviewIn an earlier post, I mentioned that I use XIRR as one of the metrics for measuring the individual stocks performance in my portfolio.  In simple terms, XIRR is the interest rate you would need to make the same money from any interest bearing account (with same investments). While XIRR can be extended at portfolio level, in today’s post, I am only discussing how I use XIRR at individual stock level.


I have pulled out one excel sheet [copy is in my toolbox at TIP-Stock-Tracker] as a representative example for this discussion. The primary notion behind this excel sheet is to keep records and track the performance. It is not intended “to model an automated tracker” or “to perform any automated calculation across the board”. Except XIRR, I have used only few basic math formulas like addition, subtraction, divisions, multiplication, and percentages. In order to understand the formula, I suggest to use formula auditing tool bar (which will show arrows to linked cells) to understand the formulas. This excel is segregated into different regions.

Continue reading rest of this article…

Measuring Progress – XIRR as Personal Rate of Return

investingInvestor’s who use long term buy and hold philosophy use varied different ways to manage risk (such as allocation and diversification), monitor their progress, and performance metric. There is no single metric that can be considered as a holy grail of progress monitoring and/or performance measurement. Depending upon what is the objective and what you want to achieve is what will drive that performance metric.


In this context, I use few different monitoring and/or performance metric. Earlier, I have talked about yield on cost as one metric to determine cash flow (or dividends) received from my original investments. YOC is a very good metric to measure the growth of your dividend based cash flow over a period of time. However, it has a drawback. It does not take into account the variability of capital invested. The price of the stock does not remain static. It keeps changing over a period of time.

Continue reading rest of this article…



~