Returns an array of the holidays' names and codes as defined for the given calendar.
Syntax
NxCALHolidays(calendar, Return_type)
- calendar
- is the calendar code (e.g. US, NYSE, CBT), name or alias. If missing, the US Government calendar is used.
- Return_type
- is a switch to select the return output (1 = count (default), 2 = array of holiday codes).
Method Description 1 count (default) 2 holiday codes
Remarks
- See Holidays for a list of currently supported Holidays.
- See Calendars for a list of currently supported calendars.
- The number in the first cell is always the number of cells in the array (e.g., "US" returns "11," so there are 11 holiday names for the US calendar).
- To view the supported holiday names within the cell, select the first cell and the number of cells in the array. Press F2, then press SHIFT+CTRL+ENTER.
- If the calendar is not recognized (i.e. not supported), NxCALHolidays returns the #VALUE! error value.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxCALHolidays (CAD) | CAN-NYD |
| CAN-GDF | |
| CAN-VICTORIA | |
| CAN-CANADA | |
| CAN-CIVIC | |
| CAN-LABOR | |
| CAN-THK | |
| CAN-REM | |
| CAN-CHR | |
| CAN-BOX |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.