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.