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.

• Theta Data resets its snapshot cache at midnight ET every day. This endpoint may not work on a weekend where there were no eligible messages sent over exchange feeds. We recommend using historic requests during the weekend.

Example

=THETADATA.V3_STOCK_SNAPSHOT_MARKET_VALUE("AAPL", "nqb", "")

Parameters

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.

Returns

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