/v1/next_business_day

Finds the closest next business day.

Description

This endpoint calculates the closest succeeding business day for a given date on a specified financial calendar. It efficiently skips over weekends and full-close holidays to determine the next valid trading day.

Endpoint

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

Parameters

Name Type Required Description
date string ✅ Yes Base date 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

Find the next business day for a date in cell `A2` (e.g., `2025-07-04`) on the `SIFMA-US` calendar:

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

💻 VBA Macro

Automate finding the next business day:

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

' Example: MsgBox GetNextBusinessDay("2025-07-04", "SIFMA-US")

📊 Google Sheets

Import the next business day into your Google Sheet:

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

🐍 Python

Find the next business day programmatically:

import requests
import json

base_url = "https://fincalapi.com/v1/next_business_day"
params = {
    "date": "2025-07-04", # US Independence Day, a holiday
    "calendar": "SIFMA-US"
}

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

if response.status_code == 200:
    data = response.json()
    print(json.dumps(data, indent=2))
    # Expected output (assuming July 7, 2025 is a business day if July 4,5,6 are non-business):
    # {
    #   "input_date": "2025-07-04",
    #   "calendar": "SIFMA-US",
    #   "next_business_day": "2025-07-07"
    # }
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Get the next business day from the command line:

curl "https://fincalapi.com/v1/next_business_day?date=2025-12-25&calendar=NYSE"

🌐 Browser

View the result directly in your browser:

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