🗓️ AMEX Holiday Calendar

AMEX (NYSE American) holiday calendar.

Description

The AMEX (NYSE American) calendar follows the standard U.S. equity market holidays. It’s used primarily for small- and mid-cap equity trading and options activity. This calendar is nearly identical to the NYSE and NASDAQ schedules.

Holiday Dates

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

Usage Examples

🧮 Excel Formula

Retrieve the next 12 months of AMEX holidays in CSV format:

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

💻 VBA Macro

Fetch AMEX holidays using VBA:

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

' Example: MsgBox GetAMEXHolidays()

📊 Google Sheets

Import AMEX holidays into your Google Sheet:

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

🐍 Python

Retrieve AMEX holiday data programmatically:

import requests
import json

url = "https://fincalapi.com/v1/holidays/range"
params = {
    "calendar": "AMEX",
    "months_ahead": 12
}

response = requests.get(url, params=params)

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

🖥️ cURL / Terminal

Fetch AMEX holidays from the command line:

curl "https://fincalapi.com/v1/holidays/range?calendar=AMEX&months_ahead=12&format=json"

🌐 Browser

View AMEX holidays directly in your browser:

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