Funds (by holding)
Find which ETFs and index funds hold a given security, and at what weight, sourced direct from SEC fund holdings filings.
Overview
Give us a security ticker, get the funds that hold it, each with that fund’s weight in the security. Results are sorted by weight descending, with a security header that echoes the queried ticker and the total number of funds. Use this to answer “which ETFs hold AAPL, and how much?” for exposure look-through, crowding, and flow analysis. To get started, please create an account and grab your API key at financialdatasets.ai. You will use the API key to authenticate your API requests.The “current” definition
This endpoint returns the funds whose most recent filing holds the security. Funds that held it in an earlier filing but no longer report it are excluded. This is the strict “currently holds” view.Matching
holding is matched against the security’s resolved ticker, so this covers equity positions. Matching bonds and foreign securities by CUSIP or ISIN is coming soon.
Find available tickers
The funds available in the API are listed by the same helper endpoint used by the by-fund query:Filtering the Data
holding is required. By default, limit is 50 (max 1000). Use offset to page through the funds.
A security that no fund currently holds returns an empty funds array (not an error).
Examples
Authorizations
API key for authentication.
Query Parameters
The fund's ticker symbol (e.g., SPY). Returns that fund's holdings. Mutually exclusive with holding.
A held security's ticker symbol (e.g., AAPL). Returns the funds whose latest filing holds it. Mutually exclusive with ticker.
Only valid with ticker. Returns the fund composition in effect on or before this date (YYYY-MM-DD). Without it, the fund's latest filing is returned.
Only valid with ticker. Filter constituents by instrument type: equity or bond. Omit for all holdings.
equity, bond The maximum number of rows to return (default: 50, max: 1000).
x <= 1000The number of rows to skip, for pagination (default: 0).
Response
Index fund holdings response. The shape depends on the query direction: ticker returns a fund header + constituents; holding returns a security header + funds.
- Option 1
- Option 2
Forward response (?ticker=...): a fund header plus its constituents, sorted by weight descending.