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

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

Find more posts tagged with

refinitiv-dataplatform-eikon

#content

Accepted answers

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

All comments

Jirapongse

@catolica_user119

Thanks for reaching out to us.

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

I hope that this information is of help

catolica_user119

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

EXPLORE OUR SITES