📚 Legacy Web Query Guide

Description

For users of older Excel versions (e.g., Excel 2007, 2010, 2013) that might not fully support the WEBSERVICE function, Excel Web Queries (`.iqy` files) provide a robust alternative for importing data directly from the API. This guide explains how to use these files to get holiday data into your spreadsheets.

🧩 Excel Web Query

You can download a prebuilt .iqy file specifically designed to import holiday data from our API into Excel. This file automates the process of creating a Web Query.

Download: holidays.iqy

How to Use:

1. Download the holidays.iqy file to your computer.
2. Open Excel.
3. Go to the Data tab.
4. In the "Get External Data" group, click From Web.
5. In the "New Web Query" dialog, paste the URL from the `.iqy` file (e.g., `https://fincalapi.com/v1/holidays/range?calendar=SIFMA-US&months_ahead=12&format=html`) or directly open the downloaded `.iqy` file if prompted.
6. Excel will import a vertical range of holidays into a table.

Once the data is imported, you can use standard Excel formulas to work with the holidays. For instance, to check if a date (in cell A2) is a holiday (assuming your imported holidays are in column D):

=IF(ISNA(VLOOKUP(A2, D:D, 1, FALSE)), "Not a holiday", "Holiday")