get_timeseries: is it possible to choose the Description/ Name instead of the RIC.

calvin.lam
calvin.lam
in Eikon Data APIs

Thanks. I am trying to use get_timeseries to pull the description of the RIC instead of the RIC code. This make more sense for the data, table.

So instead of

data = EK.get_timeseries(rics, fields='Close', start_date=start, end_date=end)

Do this

data = EK.get_timeseries(rics -->EK.TR_Field('CF_NAME')<--, fields='Close', start_date=start, end_date=end)

Looks silly when typed out... since we do a RiC to call

In get_data, you can call but it comes out as a tuple?

fields=[EK.TR_Field('CF_NAME'),EK.TR_Field('CF_CLOSE')]

data_desc = EK.get_data('CLc1',fields)

Thanks.

Tagged:

Best Answer

  • calvin.lam
    calvin.lam
    Answer ✓

    Actually managed to answer my own question. Very useful the get_timeseries return a dataframe.

    First, build a dictionary, with rics and its name. I am hoping there is a automated way to D/L ric description.

    Next append rics keys into a list and data=EK.get_timeseries.

    Lastly, simply data.columns=RIC_DICT.values().

Categories