🗓️ NYSE Calendar

New York Stock Exchange holiday calendar.

Description

The NYSE (New York Stock Exchange) calendar details market closures and early close days for U.S. equities. This is a standard reference for stock market operations in the United States.

Holiday Dates

Official NYSE holiday dates are dynamically retrieved via the API. Below are examples of how to query them.

For a comprehensive list of upcoming holidays, use the /v1/holidays/range or /v1/next_n_holidays endpoints with calendar=NYSE.

Usage Examples

🧮 Excel Formula

Import a list of NYSE holidays for the next 6 months in CSV format:

=WEBSERVICE("https://fincalapi.com/v1/holidays/range?calendar=NYSE&months_ahead=6&format=csv")

💻 VBA Macro

Fetch NYSE holidays using VBA:

Function GetNYSEHolidays() As String
    Dim http As Object
    Set http = CreateObject("MSXML2.XMLHTTP")
    http.Open "GET", "https://fincalapi.com/v1/holidays/range?calendar=NYSE&months_ahead=6&format=json", False
    http.Send
    GetNYSEHolidays = http.responseText
End Function

' Example: MsgBox GetNYSEHolidays()

📊 Google Sheets

Import NYSE holidays into your Google Sheet:

=IMPORTDATA("https://fincalapi.com/v1/holidays/range?calendar=NYSE&months_ahead=6&format=csv")

🐍 Python

Retrieve NYSE holiday data programmatically:

import requests
import json

url = "https://fincalapi.com/v1/holidays/range"
params = {
    "calendar": "NYSE",
    "months_ahead": 6
}

response = requests.get(url, params=params)

if response.status_code == 200:
    holidays = response.json()
    print(f"NYSE Holidays (Next 6 Months): {json.dumps(holidays, indent=2)}")
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Fetch NYSE holidays from the command line:

curl "https://fincalapi.com/v1/holidays/range?calendar=NYSE&months_ahead=6&format=json"

🌐 Browser

View NYSE holidays directly in your browser:

https://fincalapi.com/v1/holidays/range?calendar=NYSE&months_ahead=6&format=html