Mutual Fund Portfolio Overlap Tool: Compare 3 funds to find common stocks

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 ToolI 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.

Mutual Fund Portfolio Overlap Tool input page

The results are shown below. Should be reasonably self-explanatory.

Mutual Fund Portfolio Overlap Tool output page

Notice that the overlap is quite small. You can get the sector-wise comparison also.

common stocks listing for the three mutual fundssector allocation comparison among the three funds

To add a mutual fund, go to 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.

snapshot from moneycontrol page


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.

Download the  Mutual Fund Portfolio Overlap Tool (July 2017)

Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media

Do check out my books

You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create customg solutions for your lifestye!Get it now.  It is also available in Kindle format.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you want My 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 Surya

Travel-Training-Kit-Cover This 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)

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

All 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)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

One thought on “Mutual Fund Portfolio Overlap Tool: Compare 3 funds to find common stocks

  1. What is the best way for comparing funds? i.e. As per funds under same category (LC, SC, MC etc) or funds across categories.

Comments are closed.