V3_STOCK_SNAPSHOT_MARKET_VALUE()

StandardPro

Returns a real-time market value derived from the last BBO quote from the Nasdaq Basic feed if the account has a stocks standard or pro subscription.
Returns a 15-minute delayed market value derived from an NBBO quote from the UTP & CTA feeds if the account has the stocks value subscription subscription.

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_STOCK_SNAPSHOT_MARKET_VALUE("AAPL", "nqb", "", FALSE)

symbol -

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

Type: string

Behavior: Optional - leave blank for all symbols.

venue -

Used to specify the venue of the real time or historic request. nqb = Nasdaq Basic; utp_cta = merged UTP & CTA.

Type: string

Behavior: Optional (default: nqb).

Enumnqb, utp_cta

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.