🗓️ HKEX Calendar

Hong Kong Exchanges and Clearing holiday calendar.

Description

The HKEX calendar covers the Hong Kong Exchanges and Clearing equity market. It reflects official Hong Kong public holidays plus exchange-specific closures published in the HKEX Stock Connect Trading Calendar. HKEX observes a morning-only early close on Lunar New Year's Eve when that falls on a weekday.

What this calendar is useful for

Holiday Dates

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

API Examples

Day status — Lunar New Year Day 1, 2025

GET /v1/day_status?calendar=HKEX&date=2025-01-29

Is holiday check

GET /v1/is_holiday?calendar=HKEX&date=2025-01-29

Early close — Lunar New Year's Eve 2025

HKEX closes at 12:00 Hong Kong time on Lunar New Year's Eve (28 Jan 2025).

GET /v1/day_status?calendar=HKEX&date=2025-01-28

Next business day — skips Easter cluster

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

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

Previous business day

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

Settlement date — T+1 skips Lunar New Year cluster

T+1 from Tuesday 28 Jan 2025 (LNY Eve early close): skips LNY Day 1–4 and weekend → settles Monday 3 Feb 2025.

GET /v1/settlement_date?calendar=HKEX&date=2025-01-28&tplus=1

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

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

🖥️ cURL

curl "https://fincalapi.com/v1/day_status?calendar=HKEX&date=2025-01-29"

Notes & Limitations