🗓️ XETRA Calendar

Deutsche Börse Xetra / Germany equity exchange holiday calendar.

Description

The XETRA calendar covers the Deutsche Börse Xetra electronic cash equity trading platform in Germany. It reflects the official non-trading days published by Deutsche Börse for the Xetra platform. Xetra trades normally on several German public holidays (Ascension Day, Whit Monday, Corpus Christi, and German Unity Day); only days explicitly listed as non-trading days in the official Deutsche Börse calendar are included.

What this calendar is useful for

Holiday Dates

Official XETRA 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=XETRA.

API Examples

Day status — Good Friday 2025

GET /v1/day_status?calendar=XETRA&date=2025-04-18

Is holiday check

GET /v1/is_holiday?calendar=XETRA&date=2025-04-18

Next business day — skips Easter cluster

From Thursday 17 Apr 2025: skips Good Friday (Apr 18) and Easter Monday (Apr 21) → returns Tuesday 22 Apr 2025.

GET /v1/next_business_day?calendar=XETRA&date=2025-04-17

Previous business day

GET /v1/previous_business_day?calendar=XETRA&date=2025-04-22

Settlement date — T+1 skips Labour Day

T+1 from Thursday 30 Apr 2026: skips Labour Day (May 1) and weekend → settles Monday 4 May 2026.

GET /v1/settlement_date?calendar=XETRA&date=2026-04-30&tplus=1

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

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

🖥️ cURL

curl "https://fincalapi.com/v1/day_status?calendar=XETRA&date=2025-04-18"

Notes & Limitations