---
title: "List CLO tranches"
url: "https://console.9fin.com/apis/clo-api/versions/221fee01-d90e-4b49-9e39-50dbcbf0d81c/operations/list_tranches_v0_clo_tranches_get"
---

> Full API specification: https://console.9fin.com/apis/clo-api/versions/221fee01-d90e-4b49-9e39-50dbcbf0d81c.md

# List CLO tranches

`GET` `/v0/clo/tranches`

Operation ID: `list_tranches_v0_clo_tranches_get`

List CLO tranches (Pre-Marketing, In market, Priced, and Called).

## Query parameters

- `limit` (integer, optional) - Maximum number of rows to return (1-200).
- `cursor` (optional) - Opaque keyset-pagination cursor from a previous response's `next_cursor`; omit for the first page.
- `since` (optional) - Only return rows with updated_at at or after this datetime (UTC).
- `until` (optional) - Only return rows with updated_at at or before this datetime (UTC).
- `deal_ids__in` (optional) - Comma-separated CLO deal IDs to include (max 10).
- `status` (optional) - Filter deal status (default: Pre-Marketing, In market, Priced, and Called).
- `region` (optional) - Filter coverage region.
- `pricing_type` (optional) - Filter pricing type.
- `deal_name` (optional) - Filter by CLO deal name (case-insensitive substring match).
- `manager` (optional) - Filter by manager name (case-insensitive substring match).
- `marketing_date_from` (optional) - Only return rows with marketing_date on or after this date.
- `marketing_date_to` (optional) - Only return rows with marketing_date on or before this date.
- `pricing_date_from` (optional) - Only return rows with pricing_date on or after this date.
- `pricing_date_to` (optional) - Only return rows with pricing_date on or before this date.

## Responses

- `200` - Successful Response
- `400` - Bad request (e.g. invalid cursor).
- `422` - Validation Error
- `500` - Unexpected server error.
- `503` - Service unavailable (e.g. database down).

## OpenAPI definition

```yaml
openapi: 3.1.0
info:
  title: 9fin CLO API
  version: 0.11.0
servers:
  - description: Production environment
    url: https://api.9fin.com
paths:
  /v0/clo/tranches:
    get:
      description: List CLO tranches (Pre-Marketing, In market, Priced, and Called).
      operationId: list_tranches_v0_clo_tranches_get
      parameters:
        - description: Maximum number of rows to return (1-200).
          in: query
          name: limit
          required: false
          schema:
            default: 50
            description: Maximum number of rows to return (1-200).
            maximum: 200
            minimum: 1
            title: Limit
            type: integer
        - description: Opaque keyset-pagination cursor from a previous response's
            `next_cursor`; omit for the first page.
          in: query
          name: cursor
          required: false
          schema:
            anyOf:
              - type: string
              - type: "null"
            default: null
            description: Opaque keyset-pagination cursor from a previous response's
              `next_cursor`; omit for the first page.
            title: Cursor
        - description: Only return rows with updated_at at or after this datetime (UTC).
          in: query
          name: since
          required: false
          schema:
            anyOf:
              - format: date-time
                type: string
              - type: "null"
            default: null
            description: Only return rows with updated_at at or after this datetime (UTC).
            title: Since
        - description: Only return rows with updated_at at or before this datetime (UTC).
          in: query
          name: until
          required: false
          schema:
            anyOf:
              - format: date-time
                type: string
              - type: "null"
            default: null
            description: Only return rows with updated_at at or before this datetime (UTC).
            title: Until
        - description: Comma-separated CLO deal IDs to include (max 10).
          in: query
          name: deal_ids__in
          required: false
          schema:
            anyOf:
              - type: string
              - type: "null"
            default: null
            description: Comma-separated CLO deal IDs to include (max 10).
            title: Deal Ids  In
        - description: "Filter deal status (default: Pre-Marketing, In market, Priced, and
            Called)."
          in: query
          name: status
          required: false
          schema:
            anyOf:
              - enum:
                  - Pre-Marketing
                  - In market
                  - Priced
                  - Called
                  - all
                type: string
              - type: "null"
            default: null
            description: "Filter deal status (default: Pre-Marketing, In market, Priced, and
              Called)."
            title: Status
        - description: Filter coverage region.
          in: query
          name: region
          required: false
          schema:
            anyOf:
              - enum:
                  - US
                  - Europe
                  - LATAM
                  - APAC
                  - CEEMEA
                  - North America
                  - Western Europe
                type: string
              - type: "null"
            default: null
            description: Filter coverage region.
            title: Region
        - description: Filter pricing type.
          in: query
          name: pricing_type
          required: false
          schema:
            anyOf:
              - enum:
                  - New issue
                  - Reset
                  - Refi
                type: string
              - type: "null"
            default: null
            description: Filter pricing type.
            title: Pricing Type
        - description: Filter by CLO deal name (case-insensitive substring match).
          in: query
          name: deal_name
          required: false
          schema:
            anyOf:
              - type: string
              - type: "null"
            default: null
            description: Filter by CLO deal name (case-insensitive substring match).
            title: Deal Name
        - description: Filter by manager name (case-insensitive substring match).
          in: query
          name: manager
          required: false
          schema:
            anyOf:
              - type: string
              - type: "null"
            default: null
            description: Filter by manager name (case-insensitive substring match).
            title: Manager
        - description: Only return rows with marketing_date on or after this date.
          in: query
          name: marketing_date_from
          required: false
          schema:
            anyOf:
              - format: date
                type: string
              - type: "null"
            default: null
            description: Only return rows with marketing_date on or after this date.
            title: Marketing Date From
        - description: Only return rows with marketing_date on or before this date.
          in: query
          name: marketing_date_to
          required: false
          schema:
            anyOf:
              - format: date
                type: string
              - type: "null"
            default: null
            description: Only return rows with marketing_date on or before this date.
            title: Marketing Date To
        - description: Only return rows with pricing_date on or after this date.
          in: query
          name: pricing_date_from
          required: false
          schema:
            anyOf:
              - format: date
                type: string
              - type: "null"
            default: null
            description: Only return rows with pricing_date on or after this date.
            title: Pricing Date From
        - description: Only return rows with pricing_date on or before this date.
          in: query
          name: pricing_date_to
          required: false
          schema:
            anyOf:
              - format: date
                type: string
              - type: "null"
            default: null
            description: Only return rows with pricing_date on or before this date.
            title: Pricing Date To
      responses:
        "200":
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/PaginatedTranches"
          description: Successful Response
        "400":
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/ErrorResponse"
          description: Bad request (e.g. invalid cursor).
        "422":
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/HTTPValidationError"
          description: Validation Error
        "500":
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/InternalServerErrorResponse"
          description: Unexpected server error.
        "503":
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/ErrorResponse"
          description: Service unavailable (e.g. database down).
      security:
        - HTTPBearer: []
      summary: List CLO tranches
      tags:
        - Tranches
security:
  - HTTPBearer: []
components:
  schemas:
    PaginatedTranches:
      description: Cursor-paginated list of in-market CLO tranches.
      properties:
        items:
          description: Tranches that match the provided filter criteria.
          items:
            $ref: "#/components/schemas/TrancheItem"
          title: Items
          type: array
        next_cursor:
          anyOf:
            - type: string
            - type: "null"
          description: Cursor to pass in the next request to fetch the next page of
            tranches.
          title: Next Cursor
      required:
        - items
      title: PaginatedTranches
      type: object
    ErrorResponse:
      description: Client-facing error envelope.
      examples:
        - error_code: invalid_cursor
          message: The supplied cursor could not be decoded.
          trace_id: 202bde256c7d446f9623efdc96286c5d
        - error_code: service_unavailable
          message: Database is not available
          trace_id: c2416d52c6d14c8e831aad792407442c
      properties:
        error_code:
          title: Error Code
          type: string
        message:
          title: Message
          type: string
        trace_id:
          anyOf:
            - type: string
            - type: "null"
          title: Trace Id
      required:
        - error_code
        - message
      title: ErrorResponse
      type: object
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: "#/components/schemas/ValidationError"
          title: Detail
          type: array
      title: HTTPValidationError
      type: object
    InternalServerErrorResponse:
      properties:
        error_code:
          examples:
            - internal_server_error
          title: Error Code
          type: string
        message:
          examples:
            - An unexpected error occurred.
          title: Message
          type: string
        trace_id:
          anyOf:
            - type: string
            - type: "null"
          examples:
            - e7dfd20231374d308f04655eb0538be4
          title: Trace Id
      required:
        - error_code
        - message
      title: InternalServerErrorResponse
      type: object
    TrancheItem:
      description: In-market CLO tranche row for the client-facing feed.
      properties:
        amount:
          anyOf:
            - type: number
            - type: "null"
          description: Tranche notional amount.
          title: Amount
        benchmark:
          anyOf:
            - type: string
            - type: "null"
          description: Floating-rate benchmark index.
          title: Benchmark
        bloomberg_ticker_prefix:
          anyOf:
            - type: string
            - type: "null"
          description: Bloomberg ticker prefix.
          title: Bloomberg Ticker Prefix
        clo_name:
          description: CLO deal name.
          title: Clo Name
          type: string
        clo_type:
          anyOf:
            - type: string
            - type: "null"
          description: CLO structure type.
          title: Clo Type
        closing_date:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Closing date.
          title: Closing Date
        coupon:
          anyOf:
            - type: number
            - type: "null"
          description: Coupon as a percentage.
          title: Coupon
        coupon_basis_points:
          anyOf:
            - type: integer
            - type: "null"
          description: Coupon spread in basis points.
          title: Coupon Basis Points
        currency:
          anyOf:
            - type: string
            - type: "null"
          description: Tranche currency code.
          title: Currency
        deal_id:
          description: Parent CLO deal identifier.
          title: Deal Id
          type: string
        discount_margin:
          anyOf:
            - type: number
            - type: "null"
          description: Discount margin in basis points.
          title: Discount Margin
        entity_nf_id:
          anyOf:
            - type: string
            - type: "null"
          description: Permanent opaque organisation id for the parent CLO vehicle entity
            (`nf_ent_<hex>`). Optional in the contract for forward safety; db1
            requires every company to have an entity, so in practice this is
            always populated.
          title: Entity Nf Id
        fitch_rating:
          anyOf:
            - type: string
            - type: "null"
          description: Fitch rating.
          title: Fitch Rating
        fixed_or_floating:
          anyOf:
            - type: string
            - type: "null"
          description: Fixed or floating rate indicator.
          title: Fixed Or Floating
        guidance:
          anyOf:
            - type: string
            - type: "null"
          description: Current pricing guidance.
          title: Guidance
        initial_price_talk:
          anyOf:
            - type: string
            - type: "null"
          description: Initial price talk range.
          title: Initial Price Talk
        isin_144a:
          anyOf:
            - type: string
            - type: "null"
          description: Rule 144A ISIN.
          title: Isin 144A
        isin_reg_s:
          anyOf:
            - type: string
            - type: "null"
          description: Regulation S ISIN.
          title: Isin Reg S
        manager:
          anyOf:
            - type: string
            - type: "null"
          description: CLO manager name.
          title: Manager
        market_value_over_collateral:
          anyOf:
            - type: number
            - type: "null"
          description: Market value over collateral (MVOC).
          title: Market Value Over Collateral
        marketing_date:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Marketing start date.
          title: Marketing Date
        marketing_status:
          anyOf:
            - type: string
            - type: "null"
          description: Marketing pipeline status.
          title: Marketing Status
        moodys_rating:
          anyOf:
            - type: string
            - type: "null"
          description: Moody's rating.
          title: Moodys Rating
        non_call_date:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Non-call date.
          title: Non Call Date
        other_rating:
          anyOf:
            - type: string
            - type: "null"
          description: Other agency rating.
          title: Other Rating
        par_subordination:
          anyOf:
            - type: number
            - type: "null"
          description: Par subordination level.
          title: Par Subordination
        price:
          anyOf:
            - type: number
            - type: "null"
          description: Issue price.
          title: Price
        pricing_date:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Pricing date.
          title: Pricing Date
        pricing_type:
          anyOf:
            - type: string
            - type: "null"
          description: New issue, Reset, or Refi.
          title: Pricing Type
        reinvestment_date:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Reinvestment period end date.
          title: Reinvestment Date
        roller_deadline:
          anyOf:
            - format: date
              type: string
            - type: "null"
          description: Roller deadline date.
          title: Roller Deadline
        roller_status:
          anyOf:
            - type: string
            - type: "null"
          description: Roller pipeline status.
          title: Roller Status
        s_and_p_rating:
          anyOf:
            - type: string
            - type: "null"
          description: S&P rating.
          title: S And P Rating
        seniority:
          anyOf:
            - type: integer
            - type: "null"
          description: Tranche seniority rank.
          title: Seniority
        status:
          description: In-market lifecycle status.
          title: Status
          type: string
        tranche_id:
          description: Unique tranche identifier.
          title: Tranche Id
          type: string
        tranche_name:
          description: Tranche label within the deal.
          title: Tranche Name
          type: string
        updated_at:
          description: Timestamp when the tranche row was last updated (UTC).
          format: date-time
          title: Updated At
          type: string
        weighted_average_life:
          anyOf:
            - type: number
            - type: "null"
          description: Weighted average life (WAL).
          title: Weighted Average Life
      required:
        - tranche_id
        - deal_id
        - clo_name
        - tranche_name
        - status
        - updated_at
      title: TrancheItem
      type: object
    ValidationError:
      properties:
        ctx:
          title: Context
          type: object
        input:
          title: Input
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          title: Location
          type: array
        msg:
          title: Message
          type: string
        type:
          title: Error Type
          type: string
      required:
        - loc
        - msg
        - type
      title: ValidationError
      type: object
  securitySchemes:
    HTTPBearer:
      bearerFormat: JWT
      scheme: bearer
      type: http
```