Indexes
Blog / Thematic investing 6 min read

ETF Overlap Calculator and Tool With Real Water ETF Numbers

PHO and FIW overlap 71.9% while PHO and CGW overlap only 33.7%. How an ETF overlap calculator works, a worked example, and what to do when overlap is high.

November 2026 · Indexes

Index Studio
· vs
Index
✓Hypothetical backtest against
Holdings

Pick 2 to 10 holdings. Stocks, ETFs and crypto mix in one index.

Weighting
Performance Index
Price return
--
Vs
--
Max drawdown
--

The backtest did not run just now. Tap Backtest it to try again.

Tracking, daily closes

Educational only · Never places a trade

An ETF overlap calculator adds up, for every stock two funds share, the smaller of the two weights. The result is the percentage of your money that is the same bet twice. On the latest SEC N-PORT filings, the two biggest US water ETFs, PHO and FIW, overlap by 71.9%, while PHO and CGW overlap by only 33.7%. Owning both PHO and FIW is mostly owning one fund twice at two fees.

Overlap tools answer a narrow question: do my funds hold the same companies? They do not tell you which weighting you actually want. That second step is where you build your own basket. Below is how the calculation works, a worked example with real numbers for five water ETFs, and what to do when the overlap is higher than you expected.

How does an ETF overlap calculator work?

The calculator lines up the holdings of two funds and takes the minimum weight for each stock that appears in both. If fund A holds 4.1% American Water Works and fund B holds 8.1%, the overlap on that stock is 4.1%. Add the minimums across all shared stocks and you have the overlap percentage. 0% means no shared money and 100% means one fund is a subset of the other.

Two details change the answer. First, the weights must come from the same date, ideally the same month, because thematic funds rebalance quarterly. Second, share classes and tickers must be matched to the company, not the ticker symbol, or a stock listed under two lines is counted as different. We matched by issuer name from each fund's N-PORT filing on the SEC EDGAR database.

Worked example with five water ETFs

We took the equity holdings of PHO, CGW, FIW, PIO and AQWA from filings dated June 30 to August 31, 2026. The five funds hold 219 positions, but only 109 different companies. Pairwise overlap, as a percentage of each fund, looks like this.

PairShared companiesOverlap
PHO and FIW3071.9%
CGW and AQWA2856.6%
PHO and PIO1446.5%
FIW and PIO1236.8%
CGW and FIW1636.5%
FIW and AQWA1435.7%
PHO and CGW2333.7%
CGW and PIO2030.6%
PHO and AQWA1729.3%
PIO and AQWA817.9%

Two things stand out. The pair most people would pick as "the two big water funds," PHO and FIW, is nearly the same portfolio: Roper, Ecolab, Waters, Agilent, IDEXX, Xylem and a long tail of pump and pipe makers sit in both. The pair that looks different on the label, PHO and CGW, shares only a third. If you wanted two funds that diversify each other, CGW plus PHO works far better than PHO plus FIW.

Only two companies appear in all five funds, Xylem and American Water Works. Another fifteen appear in four, including Ecolab, Pentair, Watts Water, Zurn Elkay, Advanced Drainage Systems and Core & Main. That is the real water core, and it shows up regardless of which fund you pick.

What is a good overlap between ETFs?

Under 25% is genuinely different exposure. 25% to 50% is a normal overlap for two funds in the same theme. Above 50% you are paying two expense ratios for mostly the same holdings. In the table above, PHO and FIW at 71.9% fall in the third group, and each charges roughly 0.5% to 0.6% a year according to stockanalysis.com. Check current fees on each issuer's page before you decide.

Why does overlap matter more with thematic ETFs?

A broad index fund has hundreds of names and overlap with another broad fund is expected. A thematic fund has 36 to 66 holdings, so every shared name carries real weight. A 4% position in Xylem in one fund and 7.8% in another means a single company can drive a large part of your result from two directions at once, and your total exposure is the sum, not either number.

Overlap also hides under the label. PHO is called a water fund, yet our best water ETF ranking found that only 27.1% of it sat in water-first companies, with lab instrument makers filling much of the remainder. Two funds can share instrument makers and still look different to a ticker-based tool.

What to do when overlap is high

  • Drop the smaller or pricier fund. If PHO and FIW overlap 71.9% and you hold both, selling one cuts fees and barely changes what you own. Check the tax cost first with the wash sale calculator, since a loss sale followed by a buy of a nearly identical fund can trigger the wash sale rule. The IRS explains it in Publication 550.
  • Pick the pair with the lowest overlap. For water, that was PIO plus AQWA at 17.9%, though both are small and international.
  • Hold the shared core directly. The seventeen companies that sit in four or five funds are the water core. Buying them yourself, at weights you set, removes the second fee. The water stocks index page shows how to weight them and backtest the basket against CGW and PHO.

From overlap check to your own index

A free overlap checker stops at the percentage. If the answer is "too high," you are back at the brokerage deciding what to buy. The build your own ETF tool starts where the overlap tool ends. You choose the companies, set equal weights or your own, backtest the result against the funds you were comparing, and track it daily. For a sense of how weighting changes the outcome, see the equal weight index page, and to look at the performance of what you already own, the portfolio analyzer.

Is it safe to connect a brokerage account to an overlap tool?

Many overlap tools only need tickers, and that is all you should hand over. Tools that ask for a brokerage login or account number are collecting more than the calculation requires. Your holdings, your name and your email can end up in data broker profiles, and a service like dataremoval.ai exists to remove those listings if that worry applies to you.

The same holdings-first method applies to other themes. In the best biotech ETF ranking, XBI and IBB share 41.6% of their money while ARKG overlaps both by about 10%, and the biotech stocks index page shows how to weight a basket of your own against XBI.

How we built these numbers

Holdings come from each fund's latest N-PORT filing with the SEC (reporting dates June 30, July 31 and August 31, 2026), equity positions only, matched by issuer name. Overlap is the sum of the smaller weight across shared names. Reporting dates differ by up to two months between funds, so treat results as a snapshot, and expect them to move after each quarterly rebalance. This is educational information, not investment advice. The same low overlap shows up in robotics: ROBO and BOTZ share 25.1% of their money, and ARKQ and IBOT only 6.5%, as laid out in our best robotics ETF ranking.

Build your index and see how it backtests

Bundle stocks or crypto into your own weighted index, backtest it against real market history, and track it against the S&P 500 or BTC. Educational and informational only, and Indexes never places a trade.