DfListHolidays country codes

ma20181

I try to get market holiday information for Italy, Netherlands and Greece. Could somebody please tell me the country codes for the function DfListHolidays()? I tried ITA, ITY, NLD, NET and GRC. But I get the error message "Error: ERROR 5000 - Calendars : calendar(s) not found."

m.bunkowski

Hi @ma20181

There are few ways of getting the country codes. Since you are using Adfins you can get them with =AdStyleAttribute() function.

If you want to get the calendar style you need to provide three arguments where two are fixed the the third is the ISO currency code. For the countries that currently has EUR you would need to provide the ISO currency code before conversion to EUR.
The example for Greek Drahma and the output should be 'GRE'

=AdStyleAttribute("CUR","GRD","CLDR")

Similar with
Netherland 'NLG' - NTL
Italy ITL - ITL

Zhenya Kovalyov

@ma20181 in addition to @marcin.bunkowski comment, you can go to Thomson Reuters tab > Utilities > Admin Settings > Style Management and select Calendar styles. You can get the list full list of available codes there.

There is not always a one-to-one relationship between a country/currency and a calendar, as multiple calendars are used for different purposes, for example, the US:

ma20181

https://community.developers.refinitiv.com/discussion/comment/35941#Comment_35941

Zhenya Kovalyov

Dec 12, 2018

@ma20181 in addition to @marcin.bunkowski comment, you can go to Thomson Reuters tab > Utilities > Admin Settings > Style Management and select Calendar styles. You can get the list full list of available codes there.

There is not always a one-to-one relationship between a country/currency and a calendar, as multiple calendars are used for different purposes, for example, the US:

Thanks a lot!

ma20181

https://community.developers.refinitiv.com/discussion/comment/35907#Comment_35907

m.bunkowski

Dec 12, 2018

Hi @ma20181

There are few ways of getting the country codes. Since you are using Adfins you can get them with =AdStyleAttribute() function.

If you want to get the calendar style you need to provide three arguments where two are fixed the the third is the ISO currency code. For the countries that currently has EUR you would need to provide the ISO currency code before conversion to EUR.
The example for Greek Drahma and the output should be 'GRE'

=AdStyleAttribute("CUR","GRD","CLDR")

Similar with
Netherland 'NLG' - NTL
Italy ITL - ITL

Thanks a lot!