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

catolica_user119

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

With the webversion it is possible

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

Jirapongse

@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

catolica_user119

Hi Jirapongse, thank you for yor answer. This was really helpful.