V3_OPTION_SNAPSHOT_TRADE()

StandardPro

• Retrieve the real-time last trade of an option contract.
• You might need to change the default expiration date to a different date if it is past the current date.
• This endpoint will return no data if the market was closed for the day. Theta Data resets the snapshot cache at midnight ET every night.

Example

=THETADATA.V3_OPTION_SNAPSHOT_TRADE("AAPL", "2027-01-15", "270.000", "call", "", "")

Parameters

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

strike_range  -

Limits the number of contracts returned relative to the underlying's spot price. For a specified value 'n', this returns 'n' strikes above and 'n' strikes below the spot price, plus one at-the-money (ATM) strike (where spot price = strike price), if available. This results in a maximum of 2n + 1 strikes.

Type: string

Behavior: Optional.

min_time  -

Filters snapshots to include only data with a timestamp greater or equal to the specified value (HH:mm:ss.SSS format).

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.