FinCal API - NASDAQ

Description

The NASDAQ calendar outlines market closures and early close days for NASDAQ-listed equities. This calendar is typically identical to the NYSE schedule for U.S. trading days.

Holiday Dates

Official NASDAQ 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=NASDAQ.

Usage Examples

🧮 Excel Formula (WEBSERVICE)

Import a list of NASDAQ holidays for the next 12 months in CSV format. Pass your API key as the api_key parameter:

=WEBSERVICE("https://fincalapi.com/v1/holidays/range?calendar=NASDAQ&months_ahead=12&format=csv&api_key=fincal_live_YOUR_KEY_HERE")

Security note: The api_key parameter works but your key appears in server logs and Excel's formula bar. For better security, use Power Query (Excel 2016+) with the Authorization header instead.

🔌 Excel Power Query (recommended)

Excel 2016+ supports custom HTTP headers in Power Query, keeping your key out of the URL:

let
    ApiKey = "fincal_live_YOUR_KEY_HERE",
    Source = Web.Contents(
        "https://fincalapi.com/v1/holidays/range?calendar=NASDAQ&months_ahead=12&format=csv",
        [Headers = [Authorization = "Bearer " & ApiKey]]
    ),
    Result = Csv.Document(Source, [Delimiter=",", Encoding=65001])
in
    Result

💻 VBA Macro

Fetch NASDAQ holidays using VBA (sends API key via Authorization header):

Function GetNASDAQHolidays() As String
    Dim http As Object
    Set http = CreateObject("MSXML2.XMLHTTP")
    http.Open "GET", "https://fincalapi.com/v1/holidays/range?calendar=NASDAQ&months_ahead=12&format=json", False
    http.setRequestHeader "Authorization", "Bearer fincal_live_YOUR_KEY_HERE"
    http.Send
    GetNASDAQHolidays = http.responseText
End Function

' Example: MsgBox GetNASDAQHolidays()

📊 Google Sheets

Import NASDAQ holidays into your Google Sheet using the api_key query parameter:

=IMPORTDATA("https://fincalapi.com/v1/holidays/range?calendar=NASDAQ&months_ahead=12&format=csv&api_key=fincal_live_YOUR_KEY_HERE")

🐍 Python

Retrieve NASDAQ holiday data programmatically:

import requests
import json

API_KEY = "fincal_live_YOUR_KEY_HERE"
url = "https://fincalapi.com/v1/holidays/range"
params = {"calendar": "NASDAQ", "months_ahead": 12}

response = requests.get(url, params=params, headers={"Authorization": f"Bearer {API_KEY}"})

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

🖥️ cURL / Terminal

Fetch NASDAQ holidays from the command line:

curl -H "Authorization: Bearer fincal_live_YOUR_KEY_HERE" \
  "https://fincalapi.com/v1/holidays/range?calendar=NASDAQ&months_ahead=12&format=json"

🌐 Browser

View NASDAQ holidays directly in your browser:

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