Fund Equity Holders (which ETFs / fund series hold a stock, N-PORT fund-series grain)
fund_equity_holdersWhich fund series / ETFs hold an equity ticker — from the SEC N-PORT-P fund-holdings panel, at FUND-SERIES grain (per-ETF, per-mutual-fund), amendment-resolved to each fund's latest report. Returns the ranked holder list (series_name, series_id, registrant_cik, shares, value_usd, as-of date) + breadth stats (n_funds, total shares, total fund-held value, top-5 concentration). Each holder row also carries its adviser and sub_advisers (name, CRD, CIK, role) from N-CEN; use funds_managed for every fund an adviser runs. cik beside each crd (#2287) is the adviser's SEC CIK: the CIK of the 13F filer that reports under this CRD (mars thirteenf_filer_crd_family, own_adv_crd / ncen_own_name; can be the parent's filer, e.g. Vanguard Capital Management -> The Vanguard Group 102909), else the CIK on its own Form ADV (investors_v2.adv_cik); null when neither exists (never inferred). When those two differ, ciks lists both, 13F filer first.
This is the granularity 13F cannot give. thirteenf_who_holds returns institutional MANAGERS (BlackRock, aggregated across all its funds); this returns the actual FUND SERIES (iShares Core S&P 500 ETF, Fidelity 500 Index Fund, …) with per-fund shares. Use this for 'which ETFs own X'; use 13F for 'which managers own X'.
Scope caveats (surface these): (1) SEC-registered funds only (mutual funds + ETFs) — insurers / pensions / direct holders / foreign funds are NOT in N-PORT, so this is the fund slice of ownership, not the full holder base. (2) Funds file N-PORT quarterly on staggered fiscal calendars, so 'as_of' varies per fund (each row is that fund's latest report) — it's a rolling snapshot, not a single date. (3) value_usd is the fund's marked position. Coverage: latest-quarter universe + ~3.5y history (2022-11 → current); full 6.5y backfill in progress.
Input: ticker (resolved to CUSIP internally) OR cusip (037833100-style, faster). include_preferred=false by default (common stock only; true adds preferred 'EP').
Each fund row carries fund_type from the fund's latest SEC N-CEN: etf, mutual_fund, closed_end, money_market, interval, both (one series with ETF and mutual-fund share classes, e.g. Vanguard Total Stock Market = VTI + VTSAX; share_classes then lists each class with ticker and is_etf_class), other (separate account, UIT), or null when N-CEN doesn't cover the series (e.g. liquidated before filing one). fund_type filters holders and the breadth stats — for 'which ETFs hold X' pass fund_type=['etf','both']. by_fund_type gives n_funds, value and shares per type across all holders. Each holder row carries accession + filing_url (the fund's N-PORT behind the row; open with get_filing).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "fund_equity_holders"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cusip | No | 9-char CUSIP (e.g. '037833100'). Faster than ticker (indexed). Provide ticker OR cusip. | |
| limit | No | Max holder rows (default 100, max 1000). Breadth stats always computed over ALL holders. | |
| ticker | No | Equity ticker (e.g. 'STRL', 'AAPL'). Resolved to CUSIP internally. | |
| fund_type | No | Only these fund types (any of). etf / mutual_fund / closed_end / money_market / interval; 'both' = a series with ETF and mutual-fund share classes (Vanguard VTI / VOO); 'other' = separate account, UIT etc.; 'unknown' = not in N-CEN. For 'which ETFs' pass ['etf','both']. A single string or comma list also works. | |
| include_preferred | No | Include preferred-stock holdings (asset_cat 'EP') alongside common ('EC'). Default false = common only. |