How to get market holidays in Python API

I know EIKON has "HOL" app, and Eikon Excel also can get market holidays.

Could you let me know how to download each countries' market holidays in Python API?

<sample>

holidays, err = ek.get_data(instruments=['US', 'JP'], fields=['TR.marketholiday'], parameters={'SDate': '2019-01-01', 'EDate': '2019-12-31'}

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

market-holidays

Accepted answers

chavalit-jintamalit

You can get unstructured text from "XX/HOLIDAY" RIC.

Here is the sample for Hong Kong:

All comments

chavalit-jintamalit

You can get unstructured text from "XX/HOLIDAY" RIC.

Here is the sample for Hong Kong:

Hi chavalit.jintamalit, thank you for your reply.

Do you know if there is structured holidays data?

chavalit-jintamalit

No, it is not available from the API.

chavalit.jintamalit , I got it, thank you!

Hi,

Using the get_data method, how could I acquire all the columns for a given "Holiday RIC"?

In your example you know how to point out to the specific columns given the information shown in the Eikon app, but is there a way to download the whole dataframe without pointing out the columns we want?

And from that point on, we could make a script that processes the information, since its nicely formatted

chavalit-jintamalit

Hi @aquilesjlp300

You have to pass in field names on get_data method.

In this case, the field for this record template is as listed in the accepted answer.

ROW80_1 to ROW80_25.

Quick Links