🗓️ ASX Calendar

Australian Securities Exchange holiday calendar.

Description

The ASX calendar covers the Australian Securities Exchange equity market in Sydney. It reflects official Australian national public holidays plus state-level holidays observed by ASX, sourced from ASX Settlement Notices and ASX T24 Trading Calendars. ASX observes early closes on Christmas Eve (14:10 AEDT) and New Year's Eve (14:10 AEDT). ANZAC Day (25 April) is observed as a full-close holiday.

What this calendar is useful for

Holiday Dates

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

API Examples

Day status — ANZAC Day 2025

GET /v1/day_status?calendar=ASX&date=2025-04-25

Is holiday check

GET /v1/is_holiday?calendar=ASX&date=2025-04-25

Early close — Christmas Eve 2025

ASX closes at 14:10 AEDT on Christmas Eve.

GET /v1/day_status?calendar=ASX&date=2025-12-24

Next business day — skips Easter cluster

From Wednesday 16 Apr 2025: skips Good Friday (Apr 18), Easter Saturday (Apr 19), Easter Monday (Apr 21) → returns Tuesday 22 Apr 2025.

GET /v1/next_business_day?calendar=ASX&date=2025-04-16

Previous business day

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

Settlement date — T+1 skips Christmas cluster

T+1 from Christmas Eve 24 Dec 2025 (early close): skips Christmas (Dec 25), Boxing Day (Dec 26), weekend → settles Monday 29 Dec 2025.

GET /v1/settlement_date?calendar=ASX&date=2025-12-24&tplus=1

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

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

🖥️ cURL

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

Notes & Limitations