historical estimated EPS for multiple periods

Hello everyone

I require the historical mean estimate earnings per share from analysts for a company for multiple time periods forward. For example, the forecasts made in 2017 for the following five years 2017-2021, the forecasts made in 2016 for the years 2018-2021 and so on.

I've seen that the reifinitiv eikon terminal provides the forecasts for the following five years from the present and records the historical estimates from past years (There was the option to manually export this to Excel). However, it is unclear to me when the estimates have been made.

Are the historical estimates as mentioned above available? If so, how would the formula look like to export this data to excel?

Thank you for your help.

Best, Sandro

Estimate Details ABBN.S.xlsx

Find more posts tagged with

excel

historical

workspace

#content

Accepted answers

All comments

Jirapongse

@Sandro

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through the LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

EXPLORE OUR SITES