Returns an array of the matching supported holiday codes.
Syntax
NxHolidays(prefix, Return_type)
- prefix
- is the holiday name/prefix to search for. If missing, the full list of holidays will be returned.
- 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.
- A full name of a holiday is prefixed with a country code, followed by hyphen (-), colon (:) or forward slash (/).
- If the holiday is not recognized (i.e. not supported), NxHolidays will return the #VALUE! error value.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxHolidays() | All currently supported holidays |
| =NxHolidays("SAU/") | SAU-NATION, SAU-FITER, SAU-ADHA |
| =NxHolidays("EUC/") | EUC-CHR, EUC-BOX, EUC-MAY, EUC-GDF, EUC-EAST, EUC-NYD |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.