Financial Calendar API

Overview

This API provides programmatic access to essential financial calendar functions, simplifying tasks such as:

Calculating T+N settlement dates based on specific market calendars.
Identifying holidays and early close days.
Determining the next or previous business day.
Retrieving holiday ranges for various financial markets.

All endpoints are hosted at: https://fincalapi.com

API Functions

Explore the core functionalities of the Financial Calendar API:

`/day_status`

Provides a comprehensive status for a given date, indicating if it's a holiday, weekend, early close, and its closing time.

View Details & Examples →

`/is_early_close`

Determines if a given date is an early close day for a specified calendar, also providing the closing time.

View Details & Examples →

`/settlement_date`

Calculates the T+N settlement date based on a base date and a specified financial calendar.

View Details & Examples →

`/holidays/range`

Retrieves a list of holidays within a specified date range for a chosen calendar.

View Details & Examples →

`/next_n_holidays`

Fetches the next 'N' upcoming holidays for a given calendar from a specified start date.

View Details & Examples →

`/previous_business_day`

Gets the closest previous business day for a specified date and calendar.

View Details & Examples →

`/next_business_day`

Gets the closest next business day for a given date and calendar.

View Details & Examples →

`/next_settlement_date`

Finds the next valid settlement date after a given base date.

View Details & Examples →

`/is_valid_settlement_date`

Checks if a specified date is considered a valid settlement date for a given calendar.

View Details & Examples →

`/is_holiday`

A simpler check to determine if a date is a holiday on the specified calendar (returns boolean).

View Details & Examples →

Supported Calendars

The API supports various financial market holiday calendars:

SIFMA-US

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

View Details & Examples →

NYSE

New York Stock Exchange holiday calendar.

View Details & Examples →

NASDAQ

NASDAQ stock market holiday calendar.

View Details & Examples →

SIFMA-UK

Securities Industry and Financial Markets Association (U.K.) calendar.

View Details & Examples →

SIFMA-JP

Securities Industry and Financial Markets Association (Japan) calendar.

View Details & Examples →

Integration Examples

The API is designed for easy integration into various platforms:

🧮 Excel Formulas

Leverage WEBSERVICE for direct data retrieval.

💻 VBA Macros

Automate complex date calculations within Excel.

📊 Google Sheets

Use IMPORTDATA for seamless integration with your sheets.

🐍 Python Scripts

Access data programmatically using the requests library.

For legacy Excel support, refer to the Legacy Web Query Guide.

Start Using the API for Free!

The Financial Calendar API is currently **free for all users** for basic and testing needs.

No signup, no hidden fees, just straightforward access to robust financial date calculations.

📅 Financial Calendar API

Overview

API Functions

`/day_status`

`/is_early_close`

`/settlement_date`

`/holidays/range`

`/next_n_holidays`

`/previous_business_day`

`/next_business_day`

`/next_settlement_date`

`/is_valid_settlement_date`

`/is_holiday`

Supported Calendars

SIFMA-US

NYSE

NASDAQ

SIFMA-UK

SIFMA-JP

Integration Examples

🧮 Excel Formulas

💻 VBA Macros

📊 Google Sheets

🐍 Python Scripts

Start Using the API for Free!

Ready to Get Started?