How to Find Duplicate Holdings Across Mutual Funds

You may think you own five different mutual funds, but how many unique stocks do you actually hold? Mutual fund portfolio overlap means owning the same underlying securities across multiple funds, which can increase concentration risk and cost you more in fees. Understanding and managing this overlap is essential for a well-diversified portfolio.

What is mutual fund portfolio overlap and why it matters

Portfolio overlap occurs when two or more mutual funds in your portfolio hold common stocks or bonds. It can be measured simply by counting common holdings or more accurately by calculating weighted overlap, which considers the proportion of your total investment exposed to these duplicates. The weighted overlap formula is:

Weighted Overlap (%) = (Sum of duplicated holdings’ weighted exposure across funds) ÷ Total portfolio value × 100

Overlap matters because:

Concentration risk: Duplicate holdings increase exposure to a few stocks, reducing diversification benefits.
Hidden costs: You pay multiple expense ratios for the same underlying assets.
Tax implications: Switching funds to reduce overlap can trigger capital gains taxes and exit loads.

Where to get reliable fund holdings data in India

AMC scheme fact sheets and portfolio disclosures

Mutual funds disclose their holdings monthly or quarterly on AMC websites as mandated by SEBI. These are usually PDFs listing stocks, quantities, and percentage of assets.

AMFI and CAMS/KFin investor portals

AMFI aggregates scheme data and provides links to portfolio disclosures. CAMS and KFintech portals offer investor statements showing your holdings across funds.

Third-party data providers

Platforms like Value Research, Morningstar India, ET Money, and Trendlyne offer portfolio tools and overlap calculators with updated holdings data, often with export options.

Three practical methods to find duplicate holdings (step-by-step)

Method 1 — Automated overlap calculators (fastest)

Use online portfolio overlap tools available on platforms like Morningstar or Value Research. Upload your portfolio or select your funds to get an instant overlap report showing pairwise overlap percentages and common stocks.

Method 2 — Using Value Research / Morningstar portfolio tools (recommended)

Create a portfolio on these platforms by adding your mutual funds. The tool fetches holdings data and calculates overlap metrics, including weighted exposure and sector overlaps, helping you visualize concentration.

Method 3 — Manual method with AMC PDFs and Excel/Google Sheets (fallback)

Download the latest portfolio disclosures for each fund from AMC or AMFI websites.
Extract holdings into a spreadsheet with columns: ISIN or stock name, quantity, % scheme assets, and market value if available.
Normalize names using ISIN or stock codes to match securities across funds.
Calculate weighted exposure per holding by multiplying the fund’s allocation to that holding by your share of that fund in your total portfolio.
Sum exposures across funds to identify duplicates and calculate overlap percentage as the ratio of duplicated exposure to total portfolio value.
Build a pairwise overlap matrix to prioritize which funds have the highest duplication.

How to interpret overlap — metrics, thresholds and examples

Overlap can be measured as:

Count-based: Number or percentage of common stocks between funds.
Weight-based: Percentage of your total portfolio exposed to duplicated holdings, which is more meaningful.

For example, if two funds share 10 stocks but those stocks represent 40% of your combined portfolio value, the weighted overlap is 40%.

Sector overlap measures duplication at the sector level and can reveal hidden concentration.

Thresholds vary by investor profile:

Conservative: Overlap above 10% may warrant review.
Balanced: 10–30% moderate overlap is acceptable with monitoring.
Aggressive: Overlap above 30% is significant and should be addressed.

What to do if you find a lot of overlap (decision framework & tax checklist)

Follow these steps:

Quantify: Measure weighted overlap and identify funds with highest duplication.
Prioritize: Focus on funds with large overlap and high expense ratios.
Tax and cost check: Calculate capital gains tax (10% LTCG over INR 1 lakh for equity funds held >12 months; 15% STCG if shorter) and exit loads before switching.
Act: Stop SIPs in overlapping funds first to reduce future duplication. Redeem partially or fully based on tax cost-benefit analysis.
Monitor: Review overlap quarterly as holdings change.

For NRIs, consider TDS implications and repatriation rules before switching.

Tools & platforms that calculate overlap (comparison table)

Tool	Free/Paid	Data Freshness	Portfolio Upload	Overlap Metrics	India Coverage
Value Research	Free with premium options	Monthly	Yes	Weighted, count, sector	Comprehensive
Morningstar India	Free with subscription	Monthly	Yes	Weighted, count	Comprehensive
ET Money	Free	Monthly	Yes	Weighted	Good
Moneycontrol	Free	Monthly	No	Count-based	Good
Trendlyne	Free/Paid	Monthly	Yes	Weighted, count	Good

Common pitfalls, FAQs and quick checklist

Do not assume different fund names mean different holdings; always check at the stock level.
Use ISIN or stock codes to avoid name mismatches.
Check data freshness; holdings change quarterly or monthly.
Consider tax and exit loads before switching funds.
Review overlap periodically, not just once.

Sample worked example: a real portfolio walkthrough

Consider an investor with three equity funds totaling INR 10 lakh:

Fund A: INR 4 lakh
Fund B: INR 3 lakh
Fund C: INR 3 lakh

Step 1: Extract holdings from AMC PDFs and normalize by ISIN.

Step 2: Calculate weighted exposure for each stock = fund allocation × % holding in fund.

Step 3: Sum exposures across funds to find duplicates. For example, a blue-chip stock held 10% in Fund A and 15% in Fund B results in (4 lakh × 10%) + (3 lakh × 15%) = INR 40,000 + INR 45,000 = INR 85,000 exposure.

Step 4: Calculate overlap % = (sum of duplicated exposures) ÷ total portfolio value × 100. If total duplicated exposure is INR 4.5 lakh, overlap is 45%.

Step 5: Use a pairwise overlap matrix to identify which fund pairs have highest duplication and prioritize actions.

Conclusion — simple actions to reduce duplicate holdings

Duplicate holdings across mutual funds can quietly increase risk and cost. Start by gathering reliable holdings data, use automated or manual methods to calculate overlap, and interpret results with your risk profile in mind. If overlap is high, consider stopping SIPs in overlapping funds first, then plan redemptions carefully with tax implications in view. Regularly monitoring overlap helps maintain a diversified, cost-efficient portfolio aligned with your financial goals.

If you want expert help to analyze your portfolio overlap and plan your next steps, consider starting a conversation with a Growthvine advisor or explore growthvine.in for more resources.

Disclosure: Growthvine Capital is an AMFI Registered Mutual Fund Distributor (ARN-176753). Mutual Fund and SIF investments are subject to market risks; please read all scheme-related documents carefully. PMS and AIF products, where referenced, are distributed in association with SEBI-registered providers and are subject to their respective regulations and risk profiles. Past performance is not necessarily indicative of future returns. This article is for educational purposes only and is not investment, tax, or legal advice.