V3_OPTION_LIST_STRIKES()

FreeValueStandardPro

Lists all strikes that are available for an option with a given symbol and expiration date.
This endpoint is updated overnight.

Example

=THETADATA.V3_OPTION_LIST_STRIKES("AAPL", "20220930")

Parameters

symbolRequired  -

The stock or index symbol, or underlying symbol for options. Specify '*' for all symbols or a comma separated list when appropriate.

Type: string

Behavior: Required.

expirationRequired  -

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

Type: string

Behavior: Required.

Returns

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