Financial Calendar API

Description

The JPX calendar covers the Japan Exchange Group (JPX) / Tokyo Stock Exchange (TSE) equity market. It reflects official Japanese national holidays sourced from the Japan Cabinet Office, plus the standing year-end / new-year closure rules (Dec 31 and Jan 2–3 are always non-trading days). Japan's Golden Week in late April through early May creates a multi-day closure cluster.

What this calendar is useful for

Checking whether a date is a JPX non-trading day
Calculating the next or previous JPX business day
Computing T+N settlement dates for Tokyo equity markets
Planning around Golden Week (late April–early May) and year-end closures
Validating JPX trading and settlement schedules

Holiday Dates

Official JPX non-trading days are dynamically retrieved via the API.

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

API Examples

Day status — Mountain Day 2025

GET /v1/day_status?calendar=JPX&date=2025-08-11

Is holiday check

GET /v1/is_holiday?calendar=JPX&date=2025-08-11

Next business day — skips Mountain Day and weekend

From Friday 8 Aug 2025: skips weekend and Mountain Day (Aug 11) → returns Tuesday 12 Aug 2025.

GET /v1/next_business_day?calendar=JPX&date=2025-08-08

Previous business day

GET /v1/previous_business_day?calendar=JPX&date=2025-08-12

Settlement date — T+1 skips Mountain Day

T+1 from Friday 8 Aug 2025: skips weekend and Mountain Day (Aug 11) → settles Tuesday 12 Aug 2025.

GET /v1/settlement_date?calendar=JPX&date=2025-08-08&tplus=1

Year-end closure cluster

From Tuesday 30 Dec 2025: skips Dec 31, New Year's (Jan 1), Jan 2, Jan 3 → returns Monday 5 Jan 2026.

GET /v1/next_business_day?calendar=JPX&date=2025-12-30

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

resp = requests.get("https://fincalapi.com/v1/day_status", params={"calendar": "JPX", "date": "2025-08-11"})
print(resp.json())

🖥️ cURL

curl "https://fincalapi.com/v1/day_status?calendar=JPX&date=2025-08-11"

Notes & Limitations

Dec 31, Jan 2, and Jan 3 are standing year-end / new-year closures at JPX in addition to national holidays.
No early-close data is published for JPX. All non-trading days are full closures.
Golden Week (late Apr–early May) typically generates 4–5 consecutive non-trading days.
Data currently covers 2025–2026. The 2027 calendar will be added when published by JPX.
Verify via the JPX trading calendar for mission-critical applications.