V3_INDEX_SNAPSHOT_PRICE()

StandardPro

Retrieves a real-time last index price.
Exchanges typically generate a price report every second for popular indices like SPX.
Returns the latest message for each symbol from the past 7 days (for example, on a Friday back to the previous Friday). Outside market hours it returns values from the most recent trading session. Symbols with no messages in the past 7 calendar days are not returned. Use current_day_only=true to return only today's data.

Example

=THETADATA.V3_INDEX_SNAPSHOT_PRICE("SPX", "", FALSE)

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.

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.

current_day_only -

Only return snapshot data from the current trading day (New York date). Applied before min_time.

Type: boolean

Behavior: Optional (default: false).

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