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

jess.xu
jess.xu
in Eikon Data APIs

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!

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

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

Answers

  • jess.xu
    jess.xu

    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
    Alex Putkov.1

    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
    jess.xu

    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
    Alex Putkov.1

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

Categories