🗓️ LSE Calendar

London Stock Exchange equity market holiday calendar.

Description

The LSE calendar covers the London Stock Exchange equity market in the United Kingdom. It reflects official UK Bank Holidays plus the exchange's published early-close days (Christmas Eve and New Year's Eve at 12:30 London time). Holiday data is sourced from the LSE/Turquoise Trading Calendar and the UK Government bank-holidays feed.

What this calendar is useful for

Holiday Dates

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

API Examples

Day status — Good Friday 2025

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

Is holiday check

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

Early close — Christmas Eve 2025

LSE closes at 12:30 London time on Christmas Eve.

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

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=LSE&date=2025-04-17

Previous business day

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

Settlement date — T+1 skips Easter cluster

T+1 from Thursday 2 Apr 2026: skips Good Friday (Apr 3), weekend, and Easter Monday (Apr 6) → settles Tuesday 7 Apr 2026.

GET /v1/settlement_date?calendar=LSE&date=2026-04-02&tplus=1

Spreadsheet & Integration Examples

🧮 Excel Formula

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

💻 VBA Macro

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

📊 Google Sheets

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

🐍 Python

import requests

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

🖥️ cURL

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

Notes & Limitations