For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
36 1 2 4

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.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonricstime-series
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
36 1 2 4

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea