🧮 Excel Formulas

Leverage WEBSERVICE for direct data retrieval.

Overview

Excel's WEBSERVICE function allows you to call a web service (like our API) directly from a cell, making it easy to pull dynamic financial calendar data into your spreadsheets without macros or complex programming.

For best results when retrieving lists of data (like holidays), use the format=csv parameter in your API call.

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:

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

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:

=WEBSERVICE("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 (each holiday in a new row):

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