/v1/is_early_close

Determines if a given date is an early close day.

Description

Checks whether a specified date is an early close day for a particular financial calendar. This endpoint also provides the exact closing time if it is an early close day, which is crucial for operational planning around abbreviated trading hours.

Endpoint

GET https://fincalapi.com/v1/is_early_close

Parameters

Name Type Required Description
date string ✅ Yes Date to check in `YYYY-MM-DD` format (e.g., `2025-11-28`).
calendar string ✅ Yes Holiday calendar name, e.g., `SIFMA-US`, `NYSE`, `NASDAQ`, `SIFMA-UK`, `SIFMA-JP`.
format string No (Default: `json`) Response format: `json`, `text`, `plain`, `html`, `csv`.

Usage Examples

🧮 Excel Formula

Check if a date (e.g., in cell A2) is an early close day for SIFMA-US:

=WEBSERVICE("https://fincalapi.com/v1/is_early_close?date="&TEXT(A2,"YYYY-MM-DD")&"&calendar=SIFMA-US")

💻 VBA Macro

Automate the check for early close days:

Function IsEarlyCloseAPI(targetDate As String, calendarName As String) As String
    Dim http As Object
    Set http = CreateObject("MSXML2.XMLHTTP")
    Dim url As String
    url = "https://fincalapi.com/v1/is_early_close?date=" & targetDate & "&calendar=" & calendarName
    http.Open "GET", url, False
    http.Send
    IsEarlyCloseAPI = http.responseText ' Returns JSON string
End Function

' Example: MsgBox IsEarlyCloseAPI("2025-11-28", "NYSE")

📊 Google Sheets

Import the early close status into your sheet:

=IMPORTDATA("https://fincalapi.com/v1/is_early_close?date=2025-11-28&calendar=SIFMA-US")

🐍 Python

Check for early close status programmatically:

import requests
import json

base_url = "https://fincalapi.com/v1/is_early_close"
params = {
    "date": "2025-11-28",
    "calendar": "SIFMA-US" # The day after Thanksgiving in the US, usually an early close
}

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

if response.status_code == 200:
    early_close_info = response.json()
    print(json.dumps(early_close_info, indent=2))
    # Example output:
    # {
    #   "date": "2025-11-28",
    #   "calendar": "SIFMA-US",
    #   "is_early_close": true,
    #   "close_time": "13:00"
    # }
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Quickly check early close status:

curl "https://fincalapi.com/v1/is_early_close?date=2025-11-28&calendar=NYSE"

🌐 Browser

Paste the URL into your browser for a direct JSON view:

https://fincalapi.com/v1/is_early_close?date=2025-11-28&calendar=NYSE