🗓️ SIFMA-US Calendar

Securities Industry and Financial Markets Association (U.S.) holiday calendar.

Description

The SIFMA-US calendar observes U.S. bond market holidays. This calendar is crucial for fixed income trading, settlement, and compliance within the United States.

Holiday Dates

Official SIFMA-US 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-US.

Usage Examples

🧮 Excel Formula (WEBSERVICE)

Retrieve the next 12 months of SIFMA-US holidays in CSV format. Pass your API key as the api_key parameter:

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

Security note: The api_key parameter works but your key will appear in server access logs and Excel's formula bar. For better security, use Power Query (below) which supports the Authorization header.

🔌 Excel Power Query (recommended)

Excel 2016+ supports custom HTTP headers in Power Query, keeping your key out of the URL:

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

In Excel: Data → Get Data → From Other Sources → From Web → Advanced → add Authorization header with value Bearer fincal_live_YOUR_KEY_HERE.

💻 VBA Macro

Fetch SIFMA-US holidays using VBA (sends API key via Authorization header):

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

' Example: MsgBox GetSIFMAUSHolidays()

📊 Google Sheets

Import SIFMA-US holidays into your Google Sheet using the api_key query parameter:

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

🐍 Python

Retrieve SIFMA-US holiday data programmatically:

import requests
import json

API_KEY = "fincal_live_YOUR_KEY_HERE"
url = "https://fincalapi.com/v1/holidays/range"
params = {
    "calendar": "SIFMA-US",
    "months_ahead": 12
}

response = requests.get(url, params=params, headers={"Authorization": f"Bearer {API_KEY}"})

if response.status_code == 200:
    holidays = response.json()
    print(f"SIFMA-US Holidays (Next 12 Months): {json.dumps(holidays, indent=2)}")
else:
    print(f"Error: {response.status_code} - {response.text}")

🖥️ cURL / Terminal

Fetch SIFMA-US holidays from the command line:

curl -H "Authorization: Bearer fincal_live_YOUR_KEY_HERE" \
  "https://fincalapi.com/v1/holidays/range?calendar=SIFMA-US&months_ahead=12&format=json"

🌐 Browser

View SIFMA-US holidays directly in your browser:

https://fincalapi.com/v1/holidays/range?calendar=SIFMA-US&months_ahead=12&format=html