# Find funds holding a security Find fund portfolios that reported holding a specific security and see their matching positions. ## How it works {#how-it-works} - **Choose the security.** An ISIN identifies a specific security. An exchange-qualified ticker works when it resolves to a single ISIN. - **Choose the report dates.** Each fund uses its latest eligible disclosure before matching positions. `as_of` limits the portfolio date. `known_by` limits the filing date or, for issuer snapshots, the date the snapshot was collected. Both cutoffs are inclusive. The selected report date can differ by fund. - **Read the matching positions.** A weight of `7.5` means 7.5% of that fund's portfolio. Separate positions are returned as separate rows. An `isin_source` identifies the reference used to link a position when its disclosure supplied an exchange-qualified symbol. Use `get_fund_holdings` to see the full portfolio and its disclosure source. - **Page through funds.** Results are ordered by fund name, then portfolio identifier. Pass `next_offset` as `offset` with the same filters until it is null. - **Check coverage.** This lookup searches the same sources as the full portfolio endpoint. An empty `funds` list can mean the identifier did not resolve to a single ISIN or that no eligible disclosure matched. Empty results do not count toward your request allowance. ## Request {#request} `GET /api/v1/funds/holding` with your API key. AI assistants call it as the `get_funds_holding_security` tool, with the same parameters. ``` curl "https://financialdb.ai/api/v1/funds/holding?q=AAPL:US" \ -H "Authorization: Bearer $FDB_API_KEY" ``` ## Parameters {#parameters} | Parameter | Type | Description | |---|---|---| | `include_sources` | boolean | Include available source documents and supporting evidence. Omit for data only. Default: `false`. | | `q` (required) | string | Held security identifier, such as an ISIN or an exchange-qualified ticker (AAPL:XNAS). | | `as_of` | date | Latest eligible portfolio date, inclusive. | | `known_by` | date | Latest eligible filing or collection date, inclusive. | | `limit` | integer: 1–100 | Maximum number of fund portfolios. Default: `20`. | | `offset` | integer: 0–9007199254740991 | Fund portfolios to skip. Default: `0`. | ## Response {#response} JSON with these fields. A field the source doesn't report is null or left out. | Field | Description | |---|---| | `query` | Requested security identifier | | `next_offset` | Offset of the next page, or null on the last page | | `funds[].name` | Reported fund or portfolio name | | `funds[].identifier.type` | Type of portfolio identifier | | `funds[].identifier.value` | Identifier of the reported portfolio | | `funds[].as_of` | Portfolio date, when known | | `funds[].publication_date` | Disclosure publication date, when known | | `funds[].net_assets.amount` | Reported portfolio net assets in currency units | | `funds[].net_assets.currency` | Currency of net assets, when known | | `funds[].positions[].name` | Reported position name | | `funds[].positions[].security_title` | Reported security title | | `funds[].positions[].isin` | Reported or exchange-verified ISIN | | `funds[].positions[].cusip` | Reported CUSIP | | `funds[].positions[].isin_source.url` | Exchange or issuer reference used to verify an ISIN absent from the holdings file | | `funds[].positions[].isin_source.published` | Reference publication date, when known | | `funds[].positions[].isin_source.sha256` | Fingerprint of the reference version | | `funds[].positions[].asset_class` | Asset class of the position, with other for uncategorized positions | | `funds[].positions[].weight_percent` | Portfolio weight in percent | | `funds[].positions[].quantity` | Reported position quantity | | `funds[].positions[].quantity_unit` | shares, units, principal_amount, contracts or null | | `funds[].positions[].instrument_currency` | Reported currency of the instrument, when known | | `funds[].positions[].market_value.amount` | Reported position value, when its denomination is established | | `funds[].positions[].market_value.currency` | Currency in which the position value is denominated | | `funds[].source_notice.source` | Data provider | | `funds[].source_notice.notice` | Required attribution and reuse notice | | `funds[].source_notice.source_url` | Public source catalogue | | `funds[].source_notice.terms_url` | Reuse terms | | `funds[].sources[].kind` | Source type | | `funds[].sources[].url` | Link to the disclosure or source archive | | `match` | Identifier lookup outcome. A found match can still have an empty page. | ## Errors {#errors} | Status | Meaning | |---|---| | 400 | Missing, unknown or invalid parameter, or an identifier that can't be looked up | | 401 | Missing, unknown or revoked API key | | 402 | No active plan or trial, or the included request allowance is used | | 403 | API access of the account is suspended | | 404 | The identifier matches nothing or is ambiguous. The match field identifies the outcome | | 429 | Over the plan's rate limit; Retry-After says when to retry | | 500 | Internal error; the same request is unlikely to succeed on retry | | 503 | The data couldn't be loaded right now; Retry-After says when to retry, when known | Errors are JSON with an `error` message saying what to fix. Errors are free. See [Errors and limits](https://financialdb.ai/documentation/api/errors-and-limits.md).