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!
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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'})
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'})
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.
