Indonesian date calendar.

Holidays for the Jakarta stock exchange (data from http://www.jsx.co.id/trading.asp?cmd=menu3).

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; Good Friday; Ascension of Jesus Christ; Independence Day, August 17th; Christmas, December 25th.

Other holidays for which no rule is given (data available for 2005-2006 only) : Idul Adha; Imlek; Moslem's New Year Day; Nyepi (Saka's New Year); Birthday of Prophet Muhammad SAW; Waisak; Ascension of Prophet Muhammad SAW; Idul Fitri; Other national leaves.

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 : "Indonesia"

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

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

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

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

CTQL.CTRangeData CALIndonesia_AddHols;


int[] arrBCALIndonesia_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 arrCALIndonesia_AddHols =
new  CTQL.IntVector(arrBCALIndonesia_AddHols);

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

CTQL.CTRangeData CALIndonesia_RemoveHols;


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

};

CTQL.IntVector arrCALIndonesia_RemoveHols =
new  CTQL.IntVector(arrBCALIndonesia_RemoveHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALIndonesia_RemoveHols = new  CTQL.CTRangeData(arrCALIndonesia_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.