/v1/settlement_date

Calculates the T+N settlement date.

Description

Calculates a T+N settlement date (e.g., T+2 or T+3) from a given base date, considering weekends and holidays specific to a financial calendar. This is fundamental for post-trade processing and accurate deal settlement.

Endpoint

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

Parameters

Name Type Required Description
date string ✅ Yes Base date in `YYYY-MM-DD` format (e.g., `2025-05-01`).
calendar string ✅ Yes Holiday calendar name, e.g., `SIFMA-US`, `NYSE`, `NASDAQ`, `SIFMA-UK`, `SIFMA-JP`.
tplus integer ✅ Yes The 'N' in T+N (number of business days to add). Can be negative for T-N.
format string No (Default: `json`) Response format: `json`, `text`, `plain`, `html`, `csv`.

Usage Examples

🧮 Excel Formula

Calculate the T+2 settlement date for a date in cell `A2` (e.g., `2025-07-03`) using the `SIFMA-US` calendar:

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

💻 VBA Macro

Automate T+N settlement date calculations in VBA:

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

' Example: MsgBox GetSettlementDate("2025-07-03", "SIFMA-US", 2)

📊 Google Sheets

Calculate T+2 settlement date for `2025-07-03` (the day before US Independence Day):

=IMPORTDATA("https://fincalapi.com/v1/settlement_date?date=2025-07-03&calendar=SIFMA-US&tplus=2")

🐍 Python

Get the T+3 settlement date for a Japanese holiday using Python:

import requests
import json

base_url = "https://fincalapi.com/v1/settlement_date"
params = {
    "date": "2025-01-01",
    "calendar": "SIFMA-JP", # New Year's Day, a holiday in Japan
    "tplus": 3
}

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

if response.status_code == 200:
    settlement_info = response.json()
    print(json.dumps(settlement_info, indent=2))
    # Example output:
    # {
    #   "input_date": "2025-01-01",
    #   "calendar": "SIFMA-JP",
    #   "n_offset": 3,
    #   "settlement_date": "2025-01-08" # T+3 from Jan 1, considering holidays and weekends
    # }
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Calculate T+2 for a specific date and calendar:

curl "https://fincalapi.com/v1/settlement_date?date=2025-05-01&calendar=SIFMA-US&tplus=2"

🌐 Browser

Directly view the T+N settlement date in your browser:

https://fincalapi.com/v1/settlement_date?date=2025-05-01&calendar=SIFMA-US&tplus=2