🗓️ SGX Calendar

Singapore Exchange equity market holiday calendar.

Description

The SGX calendar covers the Singapore Exchange equity market. It reflects official Singapore public holidays sourced from the Singapore Ministry of Manpower. Singapore's multi-cultural calendar includes Chinese New Year (2 days), Deepavali, Hari Raya Puasa, Hari Raya Haji, and other public holidays, making it one of the more diverse holiday schedules among major exchanges. Note that SGX does not observe Easter Monday.

What this calendar is useful for

Holiday Dates

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

API Examples

Day status — Chinese New Year Day 1, 2025

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

Is holiday check

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

Next business day — skips Chinese New Year

From Tuesday 28 Jan 2025: skips CNY Day 1 (Jan 29) and Day 2 (Jan 30) → returns Friday 31 Jan 2025.

GET /v1/next_business_day?calendar=SGX&date=2025-01-28

Previous business day

GET /v1/previous_business_day?calendar=SGX&date=2025-01-31

Settlement date — T+1 skips Chinese New Year

T+1 from Tuesday 28 Jan 2025: skips CNY Day 1 (Jan 29) and Day 2 (Jan 30) → settles Friday 31 Jan 2025.

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

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

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

🖥️ cURL

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

Notes & Limitations