How to get market holidays in Python API

zeusu.sato

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'}

chavalit-jintamalit

Hi @zeusu.sato

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

Here is the sample for Hong Kong:

zeusu.sato

Hi chavalit.jintamalit, thank you for your reply.

Do you know if there is structured holidays data?

chavalit-jintamalit

Hi @zeusu.sato

No, it is not available from the API.

zeusu.sato

chavalit.jintamalit , I got it, thank you!

aquilesjlp300

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.