🗓️ SSE Calendar

Shanghai Stock Exchange equity market holiday calendar.

Description

The SSE calendar covers the Shanghai Stock Exchange equity market in mainland China. It reflects official Chinese public holidays as published in the HKEX Stock Connect Trading Calendar (Shanghai row). China's Golden Week holidays (Chinese New Year and National Day) create multi-day trading closures that significantly affect settlement schedules. The SZSE calendar shares the same schedule.

What this calendar is useful for

Holiday Dates

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

API Examples

Day status — National Day 2025

GET /v1/day_status?calendar=SSE&date=2025-10-01

Is holiday check

GET /v1/is_holiday?calendar=SSE&date=2025-10-01

Next business day — skips National Day Golden Week

From Tuesday 30 Sep 2025: skips National Day Golden Week (Oct 1–8) → returns Thursday 9 Oct 2025.

GET /v1/next_business_day?calendar=SSE&date=2025-09-30

Previous business day

GET /v1/previous_business_day?calendar=SSE&date=2025-10-09

Settlement date — T+1 skips Ching Ming

T+1 from Friday 3 Apr 2026: skips weekend and Ching Ming (Apr 6) → settles Tuesday 7 Apr 2026.

GET /v1/settlement_date?calendar=SSE&date=2026-04-03&tplus=1

Spreadsheet & Integration Examples

🧮 Excel Formula (WEBSERVICE)

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

Security note: The api_key parameter works but your key appears in server logs and Excel's formula bar. For better security, use Power Query (Excel 2016+) with the Authorization header instead.

🔌 Excel Power Query (recommended)

let
    ApiKey = "fincal_live_YOUR_KEY_HERE",
    Source = Web.Contents(
        "https://fincalapi.com/v1/holidays/range?calendar=SSE&months_ahead=12&format=csv",
        [Headers = [Authorization = "Bearer " & ApiKey]]
    ),
    Result = Csv.Document(Source, [Delimiter=",", Encoding=65001])
in
    Result

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

API_KEY = "fincal_live_YOUR_KEY_HERE"
resp = requests.get(
    "https://fincalapi.com/v1/day_status",
    params={"calendar": "SSE", "date": "2025-10-01"},
    headers={"Authorization": f"Bearer {API_KEY}"}
)
print(resp.json())

🖥️ cURL

curl -H "Authorization: Bearer fincal_live_YOUR_KEY_HERE" \
  "https://fincalapi.com/v1/day_status?calendar=SSE&date=2025-10-01"

Notes & Limitations