V3_OPTION_LIST_CONTRACTS()

ValueStandardPro

Lists all contracts that were traded or quoted on a particular date.

If the symbol parameter is specified, the returned contracts will be filtered to match the symbol.
Multiple symbols can be specified by separating them with commas such as symbol=AAPL,SPY,AMD
This endpoint is updated real-time.

Example

=THETADATA.V3_OPTION_LIST_CONTRACTS("quote", "20220930", "AAPL", "")

Parameters

request_typeRequired  -

The request type.

Type: string

Behavior: Required.

Enumtrade, quote

dateRequired  -

The date to fetch data for.

Type: string

Behavior: Required.

symbol  -

The stock or index symbol, or underlying symbol for options.

Type: string

Behavior: Optional - omitted if left blank.

max_dte  -

If specified, only contracts with a full calendar day 'Days to Expiration' (DTE) less than or equal to this number will be returned.

Type: string

Behavior: Optional.

Returns

A grid (string[][]) - a header row followed by one row per result. See the REST API reference for the full response schema.