📊 Google Sheets

Seamless integration with your spreadsheets.

Overview

Google Sheets provides powerful built-in functions like IMPORTDATA and WEBSERVICE (for newer Sheets) that can fetch data directly from our API. This allows you to keep your financial data in your spreadsheets automatically updated with the latest calendar information.

For importing lists of data (like holidays), using the format=csv parameter with IMPORTDATA is highly recommended as it automatically parses the data into separate rows/columns.

Examples

Check if a Date is a Holiday

To check if the date in cell `A2` (e.g., `2025-07-04`) is a holiday on the `SIFMA-US` calendar:

=IMPORTDATA("https://fincalapi.com/v1/is_holiday?date="&TEXT(A2,"YYYY-MM-DD")&"&calendar=SIFMA-US")

Note: WEBSERVICE might also work for this in newer Google Sheets versions.

Calculate T+2 Settlement Date

To find the T+2 settlement date for a date in cell `A2` (e.g., `2025-07-03`) using the `SIFMA-US` calendar:

=IMPORTDATA("https://fincalapi.com/v1/settlement_date?date="&TEXT(A2,"YYYY-MM-DD")&"&calendar=SIFMA-US&tplus=2")

Import a Range of Holidays (CSV)

To import the next 12 months of `SIFMA-US` holidays directly into your sheet, starting from the cell where you enter this formula:

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