> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tickdb.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Funds Holding a Stock

> Query funds that disclose holdings in a specified stock and the stock's weight in each fund; supports pagination.

## Plan Access

| Plan | Available |
| - | :-: |
| Free | ❌ |
| Starter | ❌ |
| Professional | ✅ |
| Full-Market Plans (A-Shares, HK Stocks, US Stocks) | ✅ |
| Enterprise | ✅ |

## Notes

* Holdings are based on each fund's disclosure date and may not reflect the current trading date. Pagination information is returned in the top-level `page` object.

## Supported Markets

| Market | Examples |
| - | - |
| US Stocks | AAPL.US |
| HK Stocks | 700.HK |
| A-Shares | 600519.SH |

## Request Parameters

| Parameter | Required | Description |
| - | :-: | - |
| `symbol` | Yes | Stock symbol |
| `type` | No | Product type; currently supports `stock` |
| `limit` | No | Number of records per page; default `200`, range `1–500` |
| `cursor` | No | Pagination cursor. Omit it on the first request; for the next page, pass the previous response's top-level `page.next_cursor` value |

## Request Example

```bash theme={null}
curl -H "X-API-Key: YOUR_API_KEY" \
  "https://api.tickdb.ai/v1/fundamentals/fund-holdings/latest?symbol=AAPL&type=stock&limit=3"
```

## Response Fields

The table below lists fields in `data` and the pagination fields; an outer `code=0` indicates success.

| Field | Description |
| - | - |
| symbol | Stock symbol. |
| total | Total number of fund records holding the stock. |
| members | Funds that disclose holdings in the stock. |
| └─ fund\_code | Fund code. |
| └─ fund\_symbol | Standardized fund symbol. |
| └─ fund\_name | Fund name. |
| └─ position\_ratio | Weight of the stock in the fund's holdings. |
| └─ currency | Currency. |
| └─ report\_date | Report date in `YYYY-MM-DD` format. |
| page | Top-level pagination information. |
| └─ next\_cursor | Cursor for the next page. When non-null, pass it unchanged as `cursor` in the next request; `null` means the last page has been reached. |
| └─ limit | Current page limit. |

`total` is the total number of matching records, while `members` contains only the current page. To request the next page, keep `symbol`, `type`, and `limit` unchanged and pass the current response's top-level `page.next_cursor` value unchanged as the next request's `cursor`. The cursor is an opaque string used by the API and should not be decoded or calculated by the client. Stop when `page.next_cursor` is `null`.

The first-page example above uses `limit=3`. If its top-level pagination object is:

```json theme={null}
{ "page": { "next_cursor": "Mw", "limit": 3 } }
```

request the next page as follows:

```bash theme={null}
curl -H "X-API-Key: YOUR_API_KEY" \
  "https://api.tickdb.ai/v1/fundamentals/fund-holdings/latest?symbol=AAPL&type=stock&limit=3&cursor=Mw"
```

`Mw` is only an example; always use the cursor returned by the preceding page.


## OpenAPI

````yaml openapi.en.yaml GET /v1/fundamentals/fund-holdings/latest
openapi: 3.1.0
info:
  title: TickDB API
  description: TickDB unified real-time market data API via REST and WebSocket.
  version: 1.0.3
  contact:
    email: support@tickdb.ai
servers:
  - url: https://api.tickdb.ai
    description: Production server
security:
  - ApiKeyAuth: []
paths:
  /v1/fundamentals/fund-holdings/latest:
    get:
      tags:
        - fundamentals-holders
      summary: Funds Holding a Stock
      description: >-
        Query funds that disclose holdings in a specified stock and the stock's
        weight in each fund; supports pagination.
      operationId: getFundamentalsFundHoldingsLatest
      parameters:
        - $ref: '#/components/parameters/SymbolQuery'
        - $ref: '#/components/parameters/TypeQuery'
        - $ref: '#/components/parameters/FundHoldingsLimitQuery'
        - $ref: '#/components/parameters/CursorQuery'
      responses:
        '200':
          $ref: '#/components/responses/FundHoldingsResponse'
        default:
          $ref: '#/components/responses/ErrorResponse'
components:
  parameters:
    SymbolQuery:
      name: symbol
      in: query
      required: true
      schema:
        type: string
        examples:
          - AAPL
          - '700'
          - '600519'
          - AAPL.US
          - 700.HK
          - 600519.SH
      description: Stock symbol
    TypeQuery:
      name: type
      in: query
      required: false
      schema:
        type: string
        enum:
          - stock
      description: Product type; currently supports `stock`
    FundHoldingsLimitQuery:
      name: limit
      in: query
      required: false
      schema:
        type: integer
        minimum: 1
        maximum: 500
        default: 200
      description: Number of records per page; default `200`, range `1–500`
    CursorQuery:
      name: cursor
      in: query
      required: false
      schema:
        type: string
        minLength: 1
      description: Next-page cursor; omit on the first request
  responses:
    FundHoldingsResponse:
      description: Funds Holding a Stock response.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/FundHoldingsEnvelope'
    ErrorResponse:
      description: >-
        Error response. Common HTTP statuses include 400 (invalid parameters),
        401 (authentication failed), 403 (permission or quota restriction), 404
        (no matching data), 429 (rate limit), and 503 (service temporarily
        unavailable).
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorEnvelope'
          examples:
            missingAPIKey:
              summary: Missing API key
              value:
                code: '1002'
                message: API key is required. Provide via X-API-Key header
                error: '1002'
            missingKind:
              summary: Missing required parameter
              value:
                code: 40001
                message: kind is required
                data: null
            endpointForbidden:
              summary: API key cannot access this endpoint
              value:
                code: 3009
                message: This endpoint is not allowed for your API key
                data: null
            marketForbidden:
              summary: API key cannot access this market
              value:
                code: 3010
                message: Fundamentals market not allowed for your API key
                data:
                  market: US
            noAvailableSource:
              summary: Data temporarily unavailable
              value:
                code: 5003
                message: Data is temporarily unavailable
                data: null
            notFound:
              summary: No matching data
              value:
                code: 40404
                message: shareholder detail not found
                data: null
            businessNoData:
              summary: No business data matches the query
              value:
                code: 40405
                message: valuation time series not found
                data: null
  schemas:
    FundHoldingsEnvelope:
      allOf:
        - $ref: '#/components/schemas/SuccessEnvelope'
        - type: object
          required:
            - page
          properties:
            data:
              $ref: '#/components/schemas/FundHoldingsData'
            page:
              $ref: '#/components/schemas/PageInfo'
    ErrorEnvelope:
      type: object
      required:
        - code
        - message
      properties:
        code:
          description: >-
            TickDB API business error code; may be an integer or string. Convert
            it to a string before comparing.
          oneOf:
            - type: integer
            - type: string
        message:
          type: string
          description: Error description.
        error:
          type: string
          description: >-
            Compatibility error identifier; present only in some error
            responses.
        data:
          description: Optional error context; may be null, an object, or an array.
          oneOf:
            - type: 'null'
            - type: object
              additionalProperties: true
            - type: array
              items: {}
    SuccessEnvelope:
      type: object
      required:
        - code
        - data
      properties:
        code:
          type: integer
          const: 0
          description: Business status code; `0` means success.
    FundHoldingsData:
      type: object
      required:
        - symbol
        - total
        - members
      properties:
        symbol:
          type: string
          description: Stock symbol.
        total:
          type: integer
          description: Total number of fund records holding the stock.
        members:
          type: array
          description: Funds that disclose holdings in the stock.
          items:
            $ref: '#/components/schemas/FundHoldingMember'
      additionalProperties: true
    PageInfo:
      type: object
      required:
        - next_cursor
        - limit
      properties:
        next_cursor:
          type:
            - string
            - 'null'
          description: >-
            Cursor for the next page; pass a non-empty value unchanged as the
            next request’s `cursor` parameter. `null` on the final page.
        limit:
          type: integer
          minimum: 1
          description: Current page limit.
      additionalProperties: true
    FundHoldingMember:
      type: object
      required:
        - fund_code
        - fund_symbol
        - fund_name
        - currency
        - position_ratio
        - report_date
      properties:
        fund_code:
          type: string
          description: Fund code.
        fund_symbol:
          type: string
          description: Standardized fund symbol.
        fund_name:
          type: string
          description: Fund name.
        currency:
          type: string
          description: Currency.
        position_ratio:
          type:
            - string
            - number
            - 'null'
          description: Weight of the stock in the fund's holdings.
        report_date:
          type: string
          format: date
          description: Report date in `YYYY-MM-DD` format.
      additionalProperties: true
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: X-API-Key

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.