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

Question

question

calvin.lam

36 ●1 ●2 ●4

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.

Feb 24, 2019 at 02:32 AM

10 |1500

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

Answer 1 · 2019-02-24T04:59:16Z

calvin.lam

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

Feb 24, 2019 at 04:59 AM

10 |1500

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