FinCal API - /is_valid_settlement

Description

This endpoint verifies whether a given date is a valid settlement date for a specified financial calendar. A date is considered a valid settlement date if it is not a weekend and not a full-close holiday, and generally, if it is not in the past relative to today.

Endpoint

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

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`).
`format`	string	No (Default: `json`)	Response format: `json`, `text`, `plain`, `html`, `csv`.

Usage Examples

🧮 Excel Formula (WEBSERVICE)

Check if a date in cell `A2` is a valid settlement date for `SIFMA-US`. Pass your API key as the api_key parameter:

=WEBSERVICE("https://fincalapi.com/v1/is_valid_settlement_date?date="&TEXT(A2,"YYYY-MM-DD")&"&calendar=SIFMA-US&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/is_valid_settlement_date?date=2025-07-07&calendar=SIFMA-US",
        [Headers = [Authorization = "Bearer " & ApiKey]]
    ),
    Result = Json.Document(Source)
in
    Result

💻 VBA Macro

Automate validation of settlement dates:

Function IsValidSettlementDateAPI(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_valid_settlement_date?date=" & targetDate & "&calendar=" & calendarName
    http.Open "GET", url, False
    http.setRequestHeader "Authorization", "Bearer fincal_live_YOUR_KEY_HERE"
    http.Send
    IsValidSettlementDateAPI = http.responseText
End Function

' Example: MsgBox IsValidSettlementDateAPI("2025-07-04", "NYSE")

📊 Google Sheets

Import the validation result into your Google Sheet using the api_key query parameter:

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

🐍 Python

Check settlement date validity programmatically:

import requests
import json

API_KEY = "fincal_live_YOUR_KEY_HERE"
base_url = "https://fincalapi.com/v1/is_valid_settlement_date"
params = {
    "date": "2025-07-04", # US Independence Day (Friday)
    "calendar": "SIFMA-US"
}

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

if response.status_code == 200:
    data = response.json()
    print(json.dumps(data, indent=2))
    # Expected output:
    # {
    #   "input_date": "2025-07-04",
    #   "calendar": "SIFMA-US",
    #   "is_valid_settlement_date": false # Because it's a holiday
    # }
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Check validity from the command line:

curl -H "Authorization: Bearer fincal_live_YOUR_KEY_HERE" \
  "https://fincalapi.com/v1/is_valid_settlement_date?date=2025-07-06&calendar=NYSE"