What is the code to gather all analyst EPS estimates?

Carl_Cruz

Query: Good afternoon. I am trying to use the API with Python to gather all analyst EPS estimates, including ones that were subsequently revised, for AAPL in 1FQ2019. I am not sure if I have errors in my code or if I do not have access to the necessary data.

Raising this on behalf of the client. We built the formula =@RDP .Data("META.O","TR.EPSEstValue","Period=1FQ2019,Frq=FQ,SDate=2017-10-01,EDate=2019-01-29 CH=IN;Fd;fperiod RH=brokername;date") for Excel. However, when we run this on CODEBK, we are not getting the same format. Can you help us with the correct code?

Jirapongse

@Carl_Cruz

Thank you for reaching out to us.

The API doesn't support the CH and RH parameters used by Excel. However, the client can use the Python to reformat the data. For example:

df = ld.get_data(
    universe = ['META.O'],
    fields = ['TR.EPSEstValue','TR.EPSEstValue.Brokername','TR.EPSEstValue.fperiod','TR.EPSEstValue.Date'],
    parameters = {'Period':'1FQ2019',
                  'Frq':'FQ',
                  'SDate':'2017-10-01',
                  'EDate':'2019-01-29'}
)

df_list=[]
for company in pd.unique(df["Broker Name"]):
    df_list.append(df[df["Broker Name"]==company])

new_df = pd.concat(df_list)
new_df

This is a sample code and has not been fully tested. Therefore, we do not provide official support for it. Clients are encouraged to test and modify the code according to their specific requirements.