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

jess.xu · March 2018

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!

Alex Putkov.1 · March 2018

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

jess.xu · March 2018

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

Alex Putkov.1 · March 2018

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

jess.xu · March 2018

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?

Alex Putkov.1 · March 2018

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

Best Answer