Returns the calendar name and description, given the calendar's short code (e.g., "US" will return "US Government Holidays").
Syntax
NxCALName(code)
- code
- is the calendar short code.
Remarks
- If the short code is not recognized (i.e. not supported), NxCALName will return the #VALUE! error value.
- See Calendars for a list of currently supported calendars.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxCALName(CHF) | Switzerland Bank Holidays |
| =NxCALName(CAD) | Canada Bank Holidays |
| =NxCALName(EUR) | EUR ECB Banks Calendar |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.