Mutual Fund Overlap Calculator with Weighted Method

What Fund Overlap Really Means for Your Portfolio

Owning five mutual funds feels like diversification. But if all five hold Reliance, HDFC Bank, ICICI Bank, Infosys and TCS in their top positions, which most large-cap and flexi-cap funds do, you are not spreading your risk at all. You are paying five expense ratios to own the same fifteen or twenty stocks, and calling it a portfolio. This hidden duplication is called portfolio overlap, and it is the single most common reason an investor’s carefully assembled portfolio behaves like one concentrated bet when the market falls. The comfort of holding several funds is real, but it can be entirely false comfort if those funds are, underneath, the same investment. This tool exists to tell you which it is.

Overlap is the percentage of your portfolio that is effectively duplicated across two funds because both hold the same stocks. The crucial point is that it is measured by weight, not just by counting common names. Two funds might share twenty stocks, but if those stocks are tiny positions in both, the overlap is small; conversely, two funds sharing just five stocks that are large positions in both can have a high overlap. So the right question is not how many stocks two funds have in common, but how much of your money sits in those common holdings, which is exactly what the weighted method measures.

Why does this matter so much? Because overlap silently undoes the diversification you think you have. If two funds each hold HDFC Bank at 8 per cent, and you split your money equally between them, your actual exposure to HDFC Bank is 8 per cent of your whole portfolio, not the comfortable spread you imagined. When HDFC Bank falls, it hits you through both funds at once. High overlap means your real number of distinct companies is far lower than your number of funds suggests, and a market shock in the common stocks damages you twice over, in each fund.

The financial cost compounds the risk. Every mutual fund charges an expense ratio, an annual fee on your money. If two funds are largely the same, you are paying two sets of fees for what is essentially one investment. Consolidating into a single fund with the same exposure cuts your costs without reducing your diversification, because the diversification was illusory to begin with. This is why checking overlap before adding a new fund, or when reviewing an existing portfolio, is one of the highest-value few minutes an investor can spend, and this tool makes it quick.

It is worth pausing on how easily this trap catches careful, well-meaning investors. Nobody sets out to buy the same fund twice. What happens is that funds are added one at a time, on separate recommendations, from magazine best-buy lists, a colleague’s tip, a top-performer ranking, each looking attractive in isolation. Because the recommendations rarely mention what you already own, the new fund’s heavy overlap with your existing holdings goes unnoticed, and over a few years a portfolio quietly accumulates redundancy. The only defence is to check each fund against your current holdings before you buy, which reframes the decision from “is this a good fund?” to “does this add anything I don’t already have?”, the question that actually protects your diversification.

The Large-Cap Trap and How to Read Your Result

There is a structural reason Indian equity portfolios are so prone to overlap, and understanding it changes how you build a portfolio. The market regulator, SEBI, mandates that a large-cap fund must invest at least 80 per cent of its money in the top 100 companies by market capitalisation. There are only 100 such companies, and every one of the many large-cap funds is fishing from that same small pond. The result is that Reliance, HDFC Bank, ICICI Bank, Infosys and TCS appear in virtually every large-cap fund at similar weights, because every fund manager is effectively required to hold them.

The consequence is stark: any two large-cap funds overlap by 65 to 85 per cent almost by design. Adding a second large-cap fund to your portfolio does not improve your diversification in any meaningful way; it just multiplies your expense ratios on the same underlying exposure. The same structural pull affects flexi-cap and multi-cap funds, since most of their managers anchor heavily to large caps too. So a portfolio of a large-cap fund, a flexi-cap fund and an ELSS fund can easily have sixty or seventy per cent overlap despite looking varied on paper. The variety is in the fund labels, not in the underlying stocks, which is precisely the illusion overlap analysis is designed to pierce.

The practical rule that follows is simple and powerful: hold at most one fund per category. Real diversification does not come from owning more funds in the same category; it comes from combining genuinely different categories, a large-cap for stability, a mid-cap and a small-cap for growth, an international fund for geographic spread, perhaps a sector or thematic fund for a specific view. Funds in different categories fish from different ponds, so their overlap is naturally low and each one adds distinct exposure. That is how you turn a nominally diversified portfolio into a genuinely diversified one, and it usually means fewer funds, not more.

Reading your overlap result is straightforward once you know the guideposts. Below about 30 per cent is healthy: the two funds add genuinely different exposure and holding both improves your diversification. Between 30 and 60 per cent is moderate, common between funds in adjacent categories, and warrants a review; the funds are not identical but you are not getting full diversification either, so compare their costs and records and decide whether both earn their place. Above 60 per cent the two funds are largely redundant, one investment in two wrappers, and consolidating is almost always the right move. The tool applies these bands to give you a clear verdict alongside the number.

One nuance worth holding in mind is that the bands are guides, not laws, and the right action also depends on the funds’ other characteristics. Two funds at 40 per cent overlap might both be worth keeping if their non-overlapping portions pull in usefully different directions and their costs are low; two funds at 40 per cent where one has a much higher expense ratio and a weaker record are a clearer case for trimming. So use the overlap figure as the starting point of the analysis, not the whole of it, and combine it with expense ratios, track records and how each fund fits your overall category mix. The tool gives you the overlap and the shared-stock detail precisely so you can make that fuller judgement rather than acting mechanically on a single number.

How the Overlap Is Calculated

The tool uses the standard weighted-overlap method that professional analysts and every serious overlap tool use, in four steps.

Step one: read your holdings

It reads the holdings you paste for each fund, one stock per line with its weight, accepting commas, spaces or colons between the name and the number, and tolerating a per cent sign. It normalises names so that minor differences like “HDFC Bank” and “HDFC Bank Ltd” are treated as the same stock. You do not need every holding; the top ten to twenty positions of each fund, which dominate the portfolio, give a reliable overlap figure.

The name-normalisation step matters more than it might seem, because the same company is often written slightly differently across factsheets, “HDFC Bank” in one, “HDFC Bank Ltd” in another, “Larsen & Toubro” versus “L&T”. Without normalisation, these would be treated as different stocks and the overlap understated, missing genuine duplication. The tool strips common suffixes like Ltd and Limited and standardises spacing so that the same company is matched wherever it appears, giving a truer overlap. You can paste holdings straight from the fund pages without hand-editing the names to match, and the tool reconciles the minor differences for you.

Step two: match the common stocks

It compares the two lists and identifies every stock held by both funds. These common holdings are where overlap lives; the stocks unique to each fund are what actually diversify your portfolio. The tool counts how many stocks are shared and how many are unique to each fund, giving you a first sense of how much the two funds have in common.

Step three: compute the weighted overlap

For each common stock, it takes the smaller of the two weights, the minimum of the fund A weight and the fund B weight, and adds these up across all shared holdings. This minimum-weight method is the accepted standard, because it captures the portion of your money that is genuinely duplicated: if a stock is 8 per cent in one fund and 6 per cent in the other, the overlapping, duplicated part is 6 per cent, the smaller position. Summing these minimums gives the single overlap percentage.

The choice of the minimum weight, rather than an average or the sum, is deliberate and correct, because it captures exactly the part of your money that is genuinely duplicated. If a stock is 8 per cent in one fund and 6 per cent in the other, only 6 per cent of it is held in both, the smaller position is the shared portion, while the extra 2 per cent in the first fund is unique to it. Taking the average would overstate the duplication for the fund holding less, and taking the sum would double-count. The minimum is the honest measure of the overlapping exposure, which is why every serious overlap tool uses it, and why this tool does too rather than a cruder count of shared names.

Step four: apply the verdict bands

Finally it places your overlap percentage into the recognised bands, healthy below 30 per cent, moderate between 30 and 60, and redundant above 60, and gives you a plain verdict and a suggested action. Together with the table of shared stocks and their weights, this tells you not just the overlap number but exactly which stocks drive it and what to do about it.

Overlap Bands, Categories and Rules of Thumb

These reference points help you interpret your result and build a genuinely diversified portfolio. Fund holdings change over time, so recheck periodically.

Overlap bands

Typical overlap by category pairing

Diversification rules of thumb

Three Worked Examples From Real Investors

Here are three investors using the overlap check to fix a portfolio.

Meera discovers her funds are one bet in Mumbai

Meera, in Mumbai, held four equity funds and felt well diversified until a bad day in the market when all four fell by almost the same amount, between four and five per cent. Puzzled, she pasted the top holdings of two of them into the tool and found an overlap above seventy per cent: the same handful of large-cap names dominated both. The tool’s verdict was blunt, that the two funds were largely redundant, and it explained the large-cap structural trap.

Meera realised her four funds were effectively one concentrated bet in different wrappers, paying four expense ratios. She consolidated to two funds in genuinely different categories and cut both her cost and her hidden concentration. What struck her most was the shared-stock table: seeing HDFC Bank, Reliance and ICICI Bank listed as heavy positions in both funds, with the overlapping weight spelled out for each, made the abstract idea of overlap concrete and impossible to argue with. She had chosen those four funds at different times, from different recommendations, never suspecting they were all fishing from the same pond, and the tool exposed in two minutes what three years of investing had obscured.

Arjun checks before adding a fund in Bengaluru

Arjun, in Bengaluru, already held a flexi-cap fund and was about to buy a popular large-cap fund a colleague recommended. Before doing so, he pasted both funds’ holdings into the tool. The overlap came back at over sixty per cent, and the tool pointed out that his flexi-cap fund already anchored heavily to the same large-cap stocks the new fund held. Rather than duplicating that exposure, Arjun instead added a mid-cap fund, which the tool would show as having low overlap with his existing holdings, genuinely broadening his portfolio.

The two-minute check saved him from a purchase that would have added cost without adding diversification. The experience also changed his habit: rather than buying funds on recommendation and hoping they fit, he now treats the overlap check as a mandatory step before every purchase, comparing any candidate against what he already owns. He came to see that the value of the check was not just the one bad purchase it prevented but the discipline it instilled, turning fund selection from a collection of hopeful bets into a deliberate process of adding only what genuinely complements his portfolio.

Priya builds a low-overlap portfolio in Chennai

Priya, in Chennai, was starting fresh and wanted a portfolio that was truly diversified, not just diversified on paper. She used the tool as she went, checking each new fund’s overlap against the ones she had already chosen. She picked one large-cap, then a mid-cap that showed low overlap with it, then a small-cap, then an international fund, confirming at each step that the overlap stayed comfortably below thirty per cent.

The result was a compact portfolio of four funds that were genuinely complementary, each adding distinct exposure, with none of the redundancy that traps investors who simply collect same-category funds. Priya’s approach illustrates the tool’s best use: not just diagnosing an existing mess but building a clean portfolio from the start. By keeping to one fund per category and verifying low overlap at each addition, she ended up with fewer funds than many investors hold yet far better real diversification, and lower total fees. She noted that her four-fund portfolio would behave very differently from Meera’s original four in a downturn, because a shock to any one segment of the market would be cushioned by the others rather than amplified across near-identical holdings.

Six Tips for Managing Fund Overlap

Frequently Asked Questions on Fund Overlap

Related Calculators You May Find Useful