V3_OPTION_LIST_DATES()

FreeValueStandardPro

Lists all dates of data that are available for an option with a given symbol, request type, and expiration.
This endpoint is updated overnight.

Example

=THETADATA.V3_OPTION_LIST_DATES("quote", "AAPL", "20220930", "*", "both")

request_typeRequired -

The request type.

Type: string

Behavior: Required.

Enumtrade, quote

symbolRequired -

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

Type: string

Behavior: Required.

expirationRequired -

The expiration of the contract in YYYY-MM-DD or YYYYMMDD format.

Type: string

Behavior: Required.

strike -

The strike price of the contract in dollars (ie 100.00 for $100.00), or * for all strikes.

Type: string

Behavior: Optional (default: *).

right -

The right (call or put) of the contract.

Type: string

Behavior: Optional (default: both).

Enumcall, put, both

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