📚 Legacy Web Query Guide

Integrating with older Excel versions using Web Queries.

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 create a .iqy file specifically designed to import holiday data from our API into Excel. This file automates the process of creating a Web Query.

To create a holidays.iqy file manually, save a plain-text file with the .iqy extension containing the following:

WEB
1
https://fincalapi.com/v1/holidays/range?calendar=SIFMA-US&months_ahead=12&format=html

How to Use:

  1. Create the holidays.iqy file as described above and save it 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")