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
Formula | Description (Result) |
---|---|
=NxCALName(CHF) | Switzerland Bank Holidays |
=NxCALName(CAD) | Canada Bank Holidays |
=NxCALName(EUR) | EUR ECB Banks Calendar |
Files Examples
External Links
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068.
Comments
Article is closed for comments.