V3_OPTION_HISTORY_EOD()

FreeValueStandardPro

• Since OPRA does not provide a national EOD report for options, Theta Data generates a national EOD report at 17:15 ET each day.
• created represents the datetime the report was generated and last_trade represents the datetime of the last trade.
• The quote in the response represents the last NBBO reported by OPRA at the time of report generation.
• You can read more about EOD & OHLC data here.

Example

=THETADATA.V3_OPTION_HISTORY_EOD("20241104", "20241104", "AAPL", "20241115", "170.000", "call", "", "")

Parameters

start_dateRequired  -

The start date (inclusive).

Type: string

Behavior: Required.

end_dateRequired  -

The end date (inclusive).

Type: string

Behavior: Required.

symbolRequired  -

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

Type: string

Behavior: Required.

expiration  -

The expiration of the contract in YYYY-MM-DD or YYYYMMDD format, or * for all expirations.

Type: string

Behavior: Optional - leave blank for all expirations.

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

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.

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.

Returns

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