Hidden Portfolio Overlap: Find Duplicate Holdings With AI
Your funds may own more of the same stocks than you realize. Use an AI prompt to uncover overlapping holdings, calculate exposure, and verify the results.
In partnership with
Are You Buying the Same Stocks Without Knowing It?
Different funds can hide the same holdings. Use this AI prompt to uncover your portfolio’s overlap.
✍️ Editor’s Note
You own a broad stock market fund, a growth fund, and an AI-focused ETF.
Three investments. Three different names. Three different jobs - or so it seems.
But what if all three put substantial money into the same companies?
This issue explores a question that’s easy to overlook: Does your portfolio contain the variety you intended, or repeated exposure to the same investments?
We’ll use AI to look inside your funds, combine their holdings, and make that overlap easier to see.
You might discover something surprising without buying a single new investment.
What if AI made us prove we’re creative?
This year AI shook up creative strategy. Most teams are still working like it didn't.
Ari Murray, Chief Digital Officer at Salt and Stone sits down with Bryan Harvey, Head of Brand at Hightouch, for an honest conversation about what's breaking on creative teams right now, how the roles are changing, and what a day looks like when creatives spend it on ideas, concepts, and craft while agents handle the manual execution.
Leave with new insights from 3 experts in the field and 5 prompts to instantly improve your creative output.
Think of each fund as a basket. The label describes the basket’s purpose, but you need to look inside to see its contents.
A broad market fund and a technology fund can own some of the same stocks. Add an AI-themed fund - or individual shares in those companies - and your exposure can accumulate across several investments.
The SEC specifically encourages investors who hold multiple mutual funds or ETFs to check their top holdings to see whether they provide the diversification being sought.
Overlap isn’t automatically a mistake. You might deliberately want extra exposure to a particular company or sector.
The important distinction is whether you chose that concentration or acquired it without realizing.
Counting funds won’t answer that question. Looking through them will.
🔢 A Simple Example: One Company, Several Routes
Imagine a hypothetical $100,000 portfolio.
You invest $50,000 in Fund A, $30,000 in Fund B, and $20,000 directly in Company X.
Company X also represents 6% of Fund A and 10% of Fund B.
Here’s your combined exposure:
Investment | Amount invested | Company X’s weight | Exposure to Company X |
|---|---|---|---|
Fund A | $50,000 | 6% | $3,000 |
Fund B | $30,000 | 10% | $3,000 |
Direct shares | $20,000 | 100% | $20,000 |
Total | $100,000 | — | $26,000 |
Your direct stock position represents 20% of the portfolio. After including the funds, your total exposure to Company X is 26%.
That extra six percentage points matters when assessing how much one company can influence your results.
This example uses invented figures and ordinary stock funds. It illustrates the calculation, not a recommended allocation.
🤖 Where AI Can Help
Comparing long holdings lists by hand gets tedious.
AI can help organize those lists, identify repeated securities, and calculate their combined portfolio weights. A tool that can analyze spreadsheets is useful for this task.
Start with:
Your fund names and tickers.
Each investment’s percentage of the portfolio.
Holdings files from the fund providers, including their dates.
Any individual stocks you also own.
Use percentages instead of account balances if you prefer. Account numbers and login details aren’t needed.
Full holdings lists provide a more complete picture than top-ten lists. If you only have partial data, the analysis should clearly describe what it covers.
🛠️ Your Copy-and-Paste Portfolio Prompt
Analyze the overlap in my portfolio using only the allocation information and holdings files I provide.
First, identify each file’s fund, holdings date, weight units, and whether the list appears complete. Flag missing or ambiguous information before calculating.
For ordinary stock holdings, multiply each fund’s portfolio allocation by each stock’s weight within that fund. Add any direct stock allocation to calculate total exposure to the same security.
Produce a table showing the ten largest combined security exposures, the funds or direct positions contributing to each, and the calculation.
Identify securities that appear in multiple funds. Distinguish exact security matches from different share classes of the same company. Flag uncertain matches.
Do not invent holdings or weights. Do not assume differently dated files describe the same moment. Flag derivatives, leverage, and funds that hold other funds for separate review.
Explain the limits of the analysis and list three questions worth investigating. Do not recommend trades.
✅ How to Verify the Prompt’s Results
Check the holdings dates. Ideally, compare files from the same date. If dates differ, treat the result as an approximation rather than a precise current snapshot.
Confirm the weight format. Make sure the tool understands whether “6” means 6%, and whether a spreadsheet stores that percentage as 0.06.
Recalculate the largest exposures. For example, a fund representing 40% of your portfolio with an 8% position in a stock contributes 3.2% portfolio exposure to that stock.
Inspect security matches. Similar names can represent different investments. Different share classes may belong to the same company, but combining them requires an explicit decision.
Check completeness. A top-ten holdings list cannot establish your total portfolio overlap. Missing holdings mean missing exposure.
Review unusual instruments separately. Simple weight multiplication may not describe the economic exposure of options, leveraged funds, or other derivatives.
🔍 Three Questions to Ask Afterward
Am I repeating a position intentionally?
Owning a company directly and through funds may fit your plan. Seeing the combined percentage helps you assess that decision honestly.
Does each fund add something useful?
Different fund names don’t necessarily mean substantially different holdings. Consider what each investment contributes to your intended allocation.
What can this analysis miss?
Different companies can still respond to the same economic forces. Holdings overlap measures shared positions; it does not measure every source of portfolio risk or predict how investments will move together.
🔐 This Week’s Vault Action
Choose your two largest stock funds.
Download their holdings, note the dates, and identify their largest shared positions. Then check whether you own any of those companies directly.
Start with understanding the result. Any allocation decision should also account for your goals, time horizon, taxes, and transaction costs.
The number of investments you own is easy to count. What you own through them takes a closer look.
AI can make that closer look more manageable - as long as you check its work.
Vaulting Your Wealth Forward,
– T. D. Thompson
AI Investing Vault
The content above is for educational and informational purposes only and does not constitute financial advice or a solicitation to buy or sell any financial instruments. Trading and investing involve significant risk of loss, and past performance is not indicative of future results. Always consult with a licensed financial advisor or conduct your own research before making any investment decisions. Use of AI tools and strategies mentioned above is at your own discretion and risk. AI Investing Vault may receive compensation if you purchase tools or services mentioned in this email, at no additional cost to you.