V3_CALENDAR_ON_DATE()

ValueStandardPro

• Retrieves equity market schedule for a given date
• Note: Holiday data is available 01/01/2012 through the end of the calendar year that immediately follows the current year
• *On days when the market closes early at 1:00 PM ET; eligible options will trade until 1:15 PM.
• **Some NYSE exchanges will continue late trading until 5:00 PM ET on early close days.

Example

=THETADATA.V3_CALENDAR_ON_DATE("20251225")

Parameters

dateRequired  -

The date to fetch data for.

Type: string

Behavior: Required.

Returns

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