US date calendar used within the NY stock exchange for equities (data from http://www.nyse.com).

This calendar object is already pre-programmed with holiday dates.

You can view the list of holidays between any 2 dates by executing the function GetHolidayList(). There are 2 additional optional parameters that can be used to fine tune the holiday list.

You can provide a range object in order to extend the holiday list with further dates.

You can also provide a range object with a list of dates which will be removed from the holiday list.

The dates passed into these range objects must be in the serial date format (Integer values).

Excel automatically passes dates entered into Excel spreadsheets in this serial date format.

The internal holiday dates are : Saturdays; Sundays; New Year's Day, January 1st (possibly moved to Monday if actually on Sunday); Martin Luther King's birthday, third Monday in January (since 1998); Presidents' Day (aka Washington's birthday), third Monday in February; Good Friday; Memorial Day, last Monday in May; Independence Day, July 4th (moved to Monday if Sunday or Friday if Saturday); Labor Day, first Monday in September; Thanksgiving Day, fourth Thursday in November; Presidential election day, first Tuesday in November of election years (until 1980); Christmas, December 25th (moved to Monday if Sunday or Friday if Saturday); Special historic closings.

This function creates an object and returns a string-key value to represent this created object.
The TAG value of the string-key returned (second part of the key) is : "usexchange"

String CTCalendars.CALUSExchange( _
String Key, _
Long Reload, _
Variant AddHols, _
Variant RemoveHols)

=CT.CAL.US.Exchange(
Excel String Cell Key,
Excel Numeric Cell Reload,
XLRange AddHols,
XLRange RemoveHols)

static std::string CALUSExchange(
std::string Key,
long Reload,
CTRangeDataCPP AddHols,
CTRangeDataCPP RemoveHols);

System.String CTCalendarsSA.CALUSExchange(
System.String Key,
System.Int32 Reload,
CTRangeData AddHols,
CTRangeData RemoveHols);

CTQL.CTRangeData CALUSExchange_AddHols;


int[] arrBCALUSExchange_AddHols = {
CTQL.Date.serialNumber("1/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("2/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("3/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("4/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("5/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("6/2/2006", "dd/mm/yyyy")  //  Array Data

};

CTQL.IntVector arrCALUSExchange_AddHols =
new  CTQL.IntVector(arrBCALUSExchange_AddHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALUSExchange_AddHols = new  CTQL.CTRangeData(arrCALUSExchange_AddHols, false);

CTQL.CTRangeData CALUSExchange_RemoveHols;


int[] arrBCALUSExchange_RemoveHols = {
CTQL.Date.serialNumber("25/12/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("25/12/2007", "dd/mm/yyyy")  //  Array Data

};

CTQL.IntVector arrCALUSExchange_RemoveHols =
new  CTQL.IntVector(arrBCALUSExchange_RemoveHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALUSExchange_RemoveHols = new  CTQL.CTRangeData(arrCALUSExchange_RemoveHols, false);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.