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

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.

Find more posts tagged with

python

eikon

rics

time-series

workspace

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().

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().