How do I get whether a day is a trading day from the Eikon Api?

yuyang.1958
yuyang.1958
in Eikon Data APIs
How do I get whether a day is a trading day from the Eikon Api?
Tagged:

Best Answer

  • pimchaya.wongrukun01
    pimchaya.wongrukun01
    Answer ✓

    Hello @yuyang

    From my finding, one possible way is from the answer of this question, you can use Timeseries / Date functionality available in pandas data frame. This example adds a column to the data frame containing dates adjusted to weekdays:

    df = ek.get_timeseries('PTT.BK','CLOSE',interval='daily',start_date='2020-05-01') 

    from pandas.tseries.offsets import * 

    df['Trading Day'] = df.index + Day(1) - BDay(1) 

    df

    The example output shows trading day of PTT.BK which is a RIC in The Stock Exchange of Thailand:

    image

Categories