Search

Categories

Show

Search Results

Searching for entries matching function, looking in keywords for any words
Found 1 matching entries

Entries

CME / NYMEX Crude Oil (CL) Holiday Calendar Generator � Excel Add-In (.xlam)

A production-ready Excel Add-In (.xlam) that provides a deterministic worksheet function returning official CME/NYMEX CL holiday dates for any given year.

The Add-In exposes a single worksheet function: CrudeOilHoliday(HolidayNumber, Year)

.

It returns either:

A valid Excel date

An Excel error value (#N/A, #VALUE!, #NUM!)

Function Parameters

Year: Four-digit integer in the range 1900�9999.

HolidayNumber: Integer in the range 1�14 identifying the holiday, as defined below.

1 New Year's Day
2 Martin Luther King Jr. Day (3rd Monday of January)
3 Presidents Day (3rd Monday of February)
4 Good Friday (Easter − 2 days)
5 Memorial Day (Last Monday of May)
6 Juneteenth (June 19, Year ≥ 2022)
7 Day Before Independence Day (conditional early close)
8 Independence Day (July 4, observed rule applied)
9 Labor Day (1st Monday of September)
10 Thanksgiving (4th Thursday of November)
11 Day After Thanksgiving
12 Christmas Eve (conditional early close)
13 Christmas Day (December 25, observed rule applied)
14 New Year's Eve (conditional early close)

A complete explanation of the Add-In is available in the GitHub repository.

Category The Elite Circle

Details: CME / NYMEX Crude Oil (CL) Holiday Calendar Generator � Excel Add-In (.xlam)
Category: The Elite Circle

February 21st, 2026
Size: 36.30 KB
Downloaded: 12 times

Keywords: .xlam add-in cme excel function holiday holidays trading