Getting Market Holidays with Excel Eikon.

aquilesjlp300

Hi,

How can I get Market Holidays using Eikon for Excel?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

exchange-holidays

market-holidays

Accepted answers

SupDev1

Try DfListHolidays, example: =DfListHolidays("USA","2019","2020")

Name is usually the same as the ISO code, but there is many other calendar styles. Full list of available styles you can find on: TR-> Utilities->Admin Settings->Style Management->Calendar styles.

All comments

SupDev1

Try DfListHolidays, example: =DfListHolidays("USA","2019","2020")

Name is usually the same as the ISO code, but there is many other calendar styles. Full list of available styles you can find on: TR-> Utilities->Admin Settings->Style Management->Calendar styles.

aquilesjlp300

It appear it has worked for others, as suggested in this post, In fact, I tried your suggestion and the example proposed in the post as well, but no luck.

What could be the issue? Is there some feature I have to turn on before doing this?

Thanks in advance for your help.

Wan Po.Lee

What standard is applied to the country code? It is not the ISO-alpha3 code because this function is using "JAP" for Japan not the ISO "JPN". Where I can get the full list of country code that can be used in this function?

EXPLORE OUR SITES