Financial Calendar API

Description

The SIFMA-JP calendar provides details on bond market holidays observed in Japan. This calendar is critical for understanding trading and settlement schedules within the Japanese fixed income market.

Holiday Dates

Official SIFMA-JP holiday dates are dynamically retrieved via the API. Below are examples of how to query them.

For a comprehensive list of upcoming holidays, use the /v1/holidays/range or /v1/next_n_holidays endpoints with calendar=SIFMA-JP.

Usage Examples

🧮 Excel Formula

Retrieve the next 12 months of SIFMA-JP holidays in CSV format:

=WEBSERVICE("https://fincalapi.com/v1/holidays/range?calendar=SIFMA-JP&months_ahead=12&format=csv")

💻 VBA Macro

Fetch SIFMA-JP holidays using VBA:

Function GetSIFMAJPHolidays() As String
    Dim http As Object
    Set http = CreateObject("MSXML2.XMLHTTP")
    http.Open "GET", "https://fincalapi.com/v1/holidays/range?calendar=SIFMA-JP&months_ahead=12&format=json", False
    http.Send
    GetSIFMAJPHolidays = http.responseText
End Function

' Example: MsgBox GetSIFMAJPHolidays()

📊 Google Sheets

Import SIFMA-JP holidays into your Google Sheet:

=IMPORTDATA("https://fincalapi.com/v1/holidays/range?calendar=SIFMA-JP&months_ahead=12&format=csv")

🐍 Python

Retrieve SIFMA-JP holiday data programmatically:

import requests
import json

url = "https://fincalapi.com/v1/holidays/range"
params = {
    "calendar": "SIFMA-JP",
    "months_ahead": 12
}

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

if response.status_code == 200:
    holidays = response.json()
    print(f"SIFMA-JP Holidays (Next 12 Months): {json.dumps(holidays, indent=2)}")
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Fetch SIFMA-JP holidays from the command line:

curl "https://fincalapi.com/v1/holidays/range?calendar=SIFMA-JP&months_ahead=12&format=json"

🌐 Browser

View SIFMA-JP holidays directly in your browser:

https://fincalapi.com/v1/holidays/range?calendar=SIFMA-JP&months_ahead=12&format=html