/v1/day_status

Provides a comprehensive status for a given date.

Description

This endpoint returns a detailed status for a specific date on a given financial calendar. It indicates if the day is a holiday, a weekend, an early close day, and provides the actual close time if applicable. This is useful for understanding the full operational status of a market on any given day.

Endpoint

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

Parameters

Name Type Required Description
date string ✅ Yes Date to check in `YYYY-MM-DD` format (e.g., `2025-12-24`).
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

To get the full day status for a cell `A2` containing the date `2025-12-24` and calendar `SIFMA-US`:

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

💻 VBA Macro

Fetch the day status programmatically:

Function GetDayStatus(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/day_status?date=" & targetDate & "&calendar=" & calendarName
    http.Open "GET", url, False
    http.Send
    GetDayStatus = http.responseText ' Returns JSON string
End Function

' Example: MsgBox GetDayStatus("2025-12-24", "SIFMA-US")

📊 Google Sheets

Retrieve day status for a specific date and calendar:

=IMPORTDATA("https://fincalapi.com/v1/day_status?date=2025-12-24&calendar=SIFMA-US")

🐍 Python

Get and parse the day status using Python:

import requests
import json

base_url = "https://fincalapi.com/v1/day_status"
params = {
    "date": "2025-12-24",
    "calendar": "SIFMA-US"
}

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

if response.status_code == 200:
    day_status = response.json()
    print(json.dumps(day_status, indent=2))
    # Example output:
    # {
    #   "date": "2025-12-24",
    #   "calendar": "SIFMA-US",
    #   "is_holiday": false,
    #   "is_early_close": true,
    #   "close_time": "13:00",
    #   "is_weekend": false,
    #   "status": "Early Close"
    # }
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Check status for a date from the command line:

curl "https://fincalapi.com/v1/day_status?date=2025-12-25&calendar=SIFMA-US"

🌐 Browser

Paste the URL directly into your browser to see the JSON output:

https://fincalapi.com/v1/day_status?date=2025-12-24&calendar=SIFMA-US