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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
26 3 2 6

Adding year/qtr/date to data frame retrieved from get_data function

Is there a way to pull the corresponding date/FQ/FY to the dataframe?

E.g. eikon.get_data('AAPL.O', 'TR.EVToSales(SDate=0,EDate=-11,Frq=M)')

I would like to add a date column for the corresponding the EV/Sales over the last 12 months.

Thank you!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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.

Upvotes
Accepted
39.2k 75 11 27

You need to add TR.EVToSales.date to the fields list, e.g.

eikon.get_data(['AAPL.O'], ['TR.EVToSales.date', 'TR.EVToSales'],{'SDate':'0', 'EDate':'-11', 'Frq':'M'})

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.

Upvotes
26 3 2 6

Thanks for the quick reply. However, there may be some misalignment due to the N/As. e.g.

eikon.get_data('TTWO.O', ['TR.EVToEBITDA.date', 'TR.EVToEBITDA'],{'SDate':'2000-01-01', 'EDate':'2018-03-26', 'Frq':'M'})

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.

Yes, this is a very unfortunate known issue for which there's no workaround. The fix is expected by the end of April.

Thx for letting us know. It'd be nice to stay informed when it will be fixed. Also any plans to expand "get_timeseries" to metrics other than price?

There are no plans to make timeseries of fundamental metrics available through get_timeseries, as they are already available through get_data.

Click below to post an Idea Post Idea