For a deeper look into our World Check One API, look into:

Overview |  Quickstart |  Documentation |  Downloads

question

Upvotes
Accepted
catolica_user119 avatar image
1 ●0 ●0 ●2

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 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

refinitiv-dataplatform-eikon#content
1682522466710.png (157.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
83.1k ●281 ●53 ●77

@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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
catolica_user119 avatar image
1 ●0 ●0 ●2

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.