How We track Portfolio Performance

Modified: 29-Jun-20

The current article in this series provides responses related to:

 

Tracking portfolio performance

Dear Vijay,

Can you share how do you track your portfolio performance because with buy/sell transactions at different times, more cash infusion in the portfolio, dividends etc., I am not sure if I am using excel formula correctly to calculate CAGR on investment?

It will be great if you can share your view on how to calculate portfolio returns or any excel template for the same.

Also how to include the dividend paid by the company?

Author’s Response:

Hi,

Thanks for writing to us!

We use valueresearchonline for keeping track of our portfolio performance. We manually update each our portfolio transactions at Value research as and when we do such transactions. Value research shows us life till date CAGR of entire portfolio as well as individual stocks.

However, the yearly & cumulative CAGR data, which we put in our portfolio performance has been calculated by exporting the transactions from valueresearchonline.com into a Microsoft Excel file and using XIRR function.

The portfolio tracker at value research gives auto notification when any dividend is due on the stocks in the portfolio. One can then update the same in 2-3 clicks of the mouse and the dividend transaction gets added in the overall transactions of the portfolio and the updated returns reflect the impact of dividend as well.

Hope it answers your concerns.

All the best for your investing journey!

Regards

Dr. Vijay Malik

P.S.

 

DISCLAIMER

  • The above discussion is only for educational purpose to help the readers improve their stock analysis skills. It is not a buy/sell/hold recommendation for the discussed stocks.
  • I am registered with SEBI as an Investment Adviser under SEBI (Investment Advisers) Regulations, 2013.
  • Currently, I do not own stocks of the companies mentioned above in my portfolio.

Related Posts:

Get FREE 3 e-books with 45 Companies Analysis

Sign Up Get Free Ebooks 250

Learn detailed fundamental analysis by reading case studies in these e-books:​

  1. Company Analysis: Vol. 1
  2. Company Analysis: Vol. 2
  3. Case Studies: Applying Peaceful Investing Approach

Get email updates of our articles

Get email updates of our articles

  • Portfolio returns of 16.0% against Sensex returns of 9.2%.
  • We identified companies, which were later invested by Sanjay Bakshi, Mohnish Pabrai, PE funds, Mutual Funds
  • See details of stocks in our portfolio
  • Get updates of buy/sell transactions in our portfolio by email

“Peaceful Investing” approach is the result of my experience of more than a decade in stock markets. I believe that the biggest challenge faced by investors is “scarcity of time” for stock analysis and “Peaceful Investing” keeps it in mind.

This approach aims to find such stocks, where once an investor has put in her money, then she may sleep peacefully. If later on, the stock prices increase, then the investor is happy as she is now wealthier. On the contrary, if the stock prices decline, even then the investor is happy as she can now buy more quantity of the selected fundamentally good stocks.

Watch Balance Sheet Analysis through a FREE sample video:

Peaceful Investing Video Series Image
Play Video

Please share your comments here:

1. IMPORTANT: You MUST do a search on Google and on our website to find answer to your query before writing it here. It will save your time as well as our time.
2. To use images in the comments, upload them on any image sharing website and then use the link in the comments.
3. All comments are moderated. Your comment will be visible after we approve/reply to it.

Leave a Comment

Get FREE 3 e-books with 45 Companies Analysis

Sign Up Get Free Ebooks 250

Learn detailed fundamental analysis by reading case studies in these e-books:​

  1. Company Analysis: Vol. 1
  2. Company Analysis: Vol. 2
  3. Case Studies: Applying Peaceful Investing Approach

Get email updates of our articles

Get email updates of our articles