Extracting IBES analyst level detailed forecasts using python on single year and longer horizons

fgf505

Dear LSEG Team,

I want to pull the IBES analyst-level, detailed forecasts from the workspace using Python.

I am using the following formula in Excel:

=@RDP .Data("MSFT.O;AAPL.O", "TR.EPSEstValue.fperiod;TR.EPSEstValue.analystname;TR.EPSEstValue.analystcode;TR.EPSEstValue.date;TR.EPSEstValue","Period=FY1990:FY2024 RH=IN CH=fd")

I seek the same variables, but instead I want to extract this data using Python.

The formula pulls forecasts on a 1-year forecast horizon from 1990 to 2024. How do we adjust the code for longer horizon forecasts, 2-5 years historically?

Jirapongse

@fgf505

Thank you for reaching out to us.

You can use the LSEG Data Library for Python to retrieve that data. The code looks like this:

import lseg.data as ld

ld.open_session()

df = ld.get_data(

    universe = ["MSFT.O","AAPL.O"],

    fields = ["TR.EPSEstValue.fperiod","TR.EPSEstValue.analystname","TR.EPSEstValue.analystcode","TR.EPSEstValue.date;TR.EPSEstValue"],

    parameters = {"Period":"FY1990:FY2024"})

df

Other examples are available on GitHub.

You can use the Formula Builder tool to search for fields and parameters that can provide the longer horizon forecasts. Otherwise, please contact the helpdesk support team directly via LSEG Support and ask for TR.xxx fields and parameters that can provide the required data.