This is a major update to the popular Equity Mutual Fund Portfolio Comparison Tool. The biggest limitation of working with Value Research was that the entire portfolio was not compared. Now the sheet uses the entire portfolio listed at Moneycontol to make the comparison.
Use the excel tool to compare mutual fund stock holdings and determine the extent of portfolio overlap among your mutual fund holdings. The tool can help you build a well-diversified equity portfolio.
I have checked it with equity funds and balanced funds. I have not yet checked it with debt funds.
Note: Just because there is large overlap among your funds, you don’t need to press the panic button and make changes to your portfolio. If you think a change is needed, make it gradually.
Here is a couple of screenshots comparing HDFC Top 200, HDFC equity and HDFC Prudence.
Register for the New Delhi DIY Investor meet: April 23rd 2017Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!