Is it possible to get a earnings per share forecast with a Refinitiv Eikon Datastream Query in Excel

catolica_user119
catolica_user119 Newcomer
in World-Check One

I found a forecast for EARNINGS PER SHARE forecast in excel.

With the webversion it is possible1682522466710.png


but changes need to be done to the following query to find this information in excel?

=@DSGRID("LS&PCOMP";"P;EPS1FD12;WC05476;DPS1FD12;EPS;DPS";"1990-06-30";"2023-04-23";"Y";"RowHeader=true;TimeSeriesList=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=true;QuarterlyTSFormat=false;MonthlyTSFormat=False";"")


Thanks for your help

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @catolica_user119

    Thanks for reaching out to us.

    You can try the EPS1MN field that represents Earnings per Share Mean FY1.

    For more information, please contact the Refinitiv Eikon with Datastream for Office support team directly via MyRefinitiv. The support team can verify if the required fields are available on Datastream.

    I hope that this information is of help

Answers

Categories