Use this free Mutual Fund Portfolio Overlap Tool to compare three mutual funds and find out the common stocks and percentage portfolio overlap. In an update to the Equity Mutual Fund Portfolio Comparison Tool, I have added the ability to add missing funds in the sheet thanks to a suggestion by Jithu Raj. You can use this sheet to compare the portfolio of three equity mutual funds. It will also list the portfolios of debt mutual funds, but not compare them (but you can).
How to use mutual fund portfolio overlap comparison tool?
If you are trying to build a diversified mutual fund portfolio (see how you can do this), then simply choose funds with an investment strategy that does not overlap much. For example, choose a bluechip fund and a mid/small-cap fund. Or a single multi-cap fund. Just 1/2 funds are enough for a market-cap and sector diversified portfolio.
Most investors hold anywhere between 5- 50 mutual funds. Track the portfolio of the large cap funds in your portfolio for a couple of months and check the portfolio overlap. If it is anywhere above 60-70%, then there is not much point holding both funds (unless your portfolio is large and you are scared about putting it all in one AMC). That this, this tool can be used to ruthlessly trim down your portfolio.
Screenshots of mutual fund portfolio comparison tool
The main input sheet where I have chosen PPFAS LTVF, Quantum Long term Equity and HDFC Balanced for comparison.
The results are shown below. Should be reasonably self-explanatory.
Notice that the overlap is quite small. You can get the sector-wise comparison also.
To add a mutual fund, go to moneycontrol.com and search for your fund. Click on NAVS on the search drop-down to locate. Now head over to fund url and locate the fund code as mentioned in the sheet and enter.
Please DO NOT ask me to increase the number of funds that can be compared. I will not and am tired of responding to such requests. Just ask, if I have made 3 comparisons for 3 funds, how many comparisons should I make for 4 funds, 5 funds, 6 funds …. and the reasons behind my refusal will be clear to you.
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google PlusandPinterest
Do check out my books
Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a youngearner
The ultimate guide to travel by Pranav SuryaThis is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for ₹199 (instant download)
Free Apps for your Android PhoneAll calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)