Overlap across many ETFs
get_etf_overlap_matrixUse this when the user lists three to thirty US ETFs, often a portfolio, and asks which of them duplicate each other or whether the list is diversified across companies; two give one pair. Returns every pair ranked by overlap by weight, with the share of each ETF held in common and the count of companies in both, and the holdings date and source of each ETF in those pairs. It measures diversification by the holdings the ETFs share, not by how their returns move together. Bond ETFs are paired by issuer overlap and listed apart. Uncovered tickers are named and skipped; commodity, multi-asset, sponsor-file and prospectus-only ETFs and ETFs read from SEC filings that are leveraged, inverse, under half in stock or half in swaps and futures are listed as not comparable, each with its reason. Not for the companies underneath (get_etf_portfolio_lookthrough) or how ETFs move together (get_etf_portfolio_risk).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tickers | Yes | 2 to 30 US ETF tickers, for example ["VOO", "QQQ", "SCHD"]: three or more give the matrix, two give one pair. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pairs | No | In percent, largest first. | |
| source | No | ||
| covered | No | ||
| skipped | No | ||
| computed | No | ||
| not_covered | No | ||
| prices_as_of | No | ||
| holdings_as_of | No | ||
| not_comparable | No | ||
| holdings_source | No | ||
| issuer_overlap_pairs | No | By issuer, in percent, largest first. |