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!

Find more posts tagged with

python

eikon

workspace

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'})

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'})

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'})

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.