What the funds hold underneath
look_throughThe companies a portfolio owns through its funds, added up across funds. In: holdings. Out: the largest companies with their share of the whole portfolio, companies reached through more than one fund, the part of the money that buys a company a second time, sectors, and how much of the money could be named. Typical questions: 'How much do my ETFs overlap?'; 'What companies do I really own through VTI, QQQ and VXUS?'; 'How much NVIDIA do I hold through my funds?'. Instead: for one fund on its own, asset_info. Figures are minimums where a fund shows only its largest holdings; the answer says how much of the money is named. It does not recommend, predict or calculate tax.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base | No | Currency code every figure is expressed in: USD, EUR, GBP, CAD… Default USD. | |
| units | No | What the holdings' numbers are: 'money' (amounts in the base currency) or 'weights' (percentages or fractions). Omitted: holdings adding up to 1 or 100 are read as percentages, anything else as money, and the answer says so. | |
| holdings | Yes | What is held: {ticker: number}, 1 to 100 holdings. Weights in any scale (60/20/20 or 0.6/0.2/0.2) or money amounts in the base currency (60000/20000/20000): `units` says which; without it, holdings adding up to 1 or 100 are read as percentages, anything else as money, which makes the falls come out in money. Tickers as the exchange lists them (VOO, VWCE.DE, EQQQ.DE, XAW.TO; 'CASH.USD' for cash). Example: {"VTI": 60, "VXUS": 20, "BND": 20}. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | Where the prices came from and what was missing or repaired. | |
| _fence | Yes | What these figures are and are not: descriptive, no forecast, no advice. Repeat its sense when presenting the result. | |
| opaque | No | Holdings with no breakdown to look through. | |
| n_funds | No | Funds looked through. | |
| refused | No | Funds whose breakdown the data vendor refused. | |
| sectors | No | [sector, share] pairs. | |
| exposures | No | [company, share of the whole portfolio] pairs, largest first. | |
| top_symbol | No | The largest single company underneath. | |
| n_companies | No | Distinct companies seen underneath. | |
| covered_fraction | No | Share of the money whose underlying holdings are visible, 0 to 1. | |
| top_symbol_weight | No | Its share of the whole portfolio. | |
| duplicated_exposure | No | Share held more than once through different funds. |