/v1/is_holiday

Check if a given date is a holiday.

Description

Checks whether a given date is a holiday on the specified financial calendar. This endpoint returns a simple boolean (`true` or `false`) indicating holiday status, making it ideal for quick checks.

Endpoint

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

Parameters

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

Use the WEBSERVICE function to directly fetch the holiday status into an Excel cell:

=WEBSERVICE("https://fincalapi.com/v1/is_holiday?date=2025-07-04&calendar=SIFMA-US")

💻 VBA Macro

Integrate the API call into your VBA macros for automated checks:

Function IsHolidayAPI(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_holiday?date=" & targetDate & "&calendar=" & calendarName
    http.Open "GET", url, False
    http.Send
    IsHolidayAPI = http.responseText
End Function

' Example Usage in a cell: =IsHolidayAPI("2025-07-04", "SIFMA-US")
' Example Usage in VBA: MsgBox IsHolidayAPI("2025-07-04", "SIFMA-US")

📊 Google Sheets

Similar to Excel, IMPORTDATA (or `WEBSERVICE` in newer Sheets) can fetch the boolean result:

=IMPORTDATA("https://fincalapi.com/v1/is_holiday?date=2025-07-04&calendar=SIFMA-US")

🐍 Python

Programmatically check holiday status using the requests library:

import requests

base_url = "https://fincalapi.com/v1/is_holiday"
params = {
    "date": "2025-07-04",
    "calendar": "SIFMA-US"
}

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

if response.status_code == 200:
    is_it_holiday = response.json()
    print(f"Is 2025-07-04 a holiday in SIFMA-US? {is_it_holiday}")
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Quickly test the endpoint from your command line:

curl "https://fincalapi.com/v1/is_holiday?date=2025-07-04&calendar=SIFMA-US"

🌐 Browser

You can paste the URL directly into your browser to see the JSON output:

https://fincalapi.com/v1/is_holiday?date=2025-07-04&calendar=SIFMA-US