Securities Industry and Financial Markets Association (U.K.) holiday calendar.
The SIFMA-UK calendar outlines bond market holidays observed in the United Kingdom. This calendar is essential for participants in the UK fixed income market for accurate settlement and trading schedules.
Official SIFMA-UK holiday dates are dynamically retrieved via the API. Below are examples of how to query them.
For a comprehensive list of upcoming holidays, use the /v1/holidays/range or /v1/next_n_holidays endpoints with calendar=SIFMA-UK.
Retrieve the next 12 months of SIFMA-UK holidays in CSV format:
=WEBSERVICE("https://fincalapi.com/v1/holidays/range?calendar=SIFMA-UK&months_ahead=12&format=csv")Fetch SIFMA-UK holidays using VBA:
Function GetSIFMAUKHolidays() As String
Dim http As Object
Set http = CreateObject("MSXML2.XMLHTTP")
http.Open "GET", "https://fincalapi.com/v1/holidays/range?calendar=SIFMA-UK&months_ahead=12&format=json", False
http.Send
GetSIFMAUKHolidays = http.responseText
End Function
' Example: MsgBox GetSIFMAUKHolidays()
Import SIFMA-UK holidays into your Google Sheet:
=IMPORTDATA("https://fincalapi.com/v1/holidays/range?calendar=SIFMA-UK&months_ahead=12&format=csv")Retrieve SIFMA-UK holiday data programmatically:
import requests
import json
url = "https://fincalapi.com/v1/holidays/range"
params = {
"calendar": "SIFMA-UK",
"months_ahead": 12
}
response = requests.get(url, params=params)
if response.status_code == 200:
holidays = response.json()
print(f"SIFMA-UK Holidays (Next 12 Months): {json.dumps(holidays, indent=2)}")
else:
print(f"Error: {response.status_code} - {response.text}")
Fetch SIFMA-UK holidays from the command line:
curl "https://fincalapi.com/v1/holidays/range?calendar=SIFMA-UK&months_ahead=12&format=json"View SIFMA-UK holidays directly in your browser:
https://fincalapi.com/v1/holidays/range?calendar=SIFMA-UK&months_ahead=12&format=html