analyst forecast data and actual EPS data for all US firms

John.Cajayon

Hello team, reaching out on behalf of a client.

Could you please help me with getting the analyst forecast data and actual EPS data for all US firms from 2000-2024 via Python?

We cannot use Excel since the number of firms is too large. 

raksina.samasiri

Hi @John.Cajayon ,

Are there any specific field name (data item name) used to retrieve data in Excel and screener syntax used in Excel? If so, please provide it here.

You can also check these articles demonstrate how to fetch instrument of specific criteria

https://developers.lseg.com/en/article-catalog/article/find-your-right-companies-with-screener-eikon-data-apis-python

https://developers.lseg.com/en/article-catalog/article/Find-content-and-functionality-using-Refinitiv-Data-Library-with-Eikon-Advanced-Search

John.Cajayon

Hello @raksina.samasiri thank you for your response

We are using TR.EPSMean and TR.EPSActValue in a monthly interval

It seems I wasn't able to upload the Excel file due to permission issues.

=@RDP.Data($B$9:$B$508,"TR.EPSMean","Period=#1 SDate=#2 EDate=#3 Frq=#4 CH=IN RH=calcdate NULL=- CODE=MULTI",$E$8:$SK$5008,Workaround!$C$13,$C$3,$C$4,Workaround!$C$18)

=@RDP.Data($B$9:$B$508,"TR.EPSActValue","Period=#1 SDate=#2 EDate=#3 Frq=#4 CH=IN RH=calcdate NULL=- CODE=MULTI",$E$8:$SK$5008,Workaround!$C$3,$C$3,$C$4,Workaround!$C$8)

Can this be replicated in Python for all US firms?

John.Cajayon

https://community.developers.refinitiv.com/discussion/comment/124062#Comment_124062

Hello @raksina.samasiri thank you for your response

We are using TR.EPSMean and TR.EPSActValue in a monthly interval

It seems I wasn't able to upload the Excel file due to permission issues.

=@RDP.Data($B$9:$B$508,"TR.EPSMean","Period=#1 SDate=#2 EDate=#3 Frq=#4 CH=IN RH=calcdate NULL=- CODE=MULTI",$E$8:$SK$5008,Workaround!$C$13,$C$3,$C$4,Workaround!$C$18)

=@RDP.Data($B$9:$B$508,"TR.EPSActValue","Period=#1 SDate=#2 EDate=#3 Frq=#4 CH=IN RH=calcdate NULL=- CODE=MULTI",$E$8:$SK$5008,Workaround!$C$3,$C$3,$C$4,Workaround!$C$8)

Can this be replicated in Python for all US firms?

John.Cajayon

https://community.developers.refinitiv.com/discussion/comment/124062#Comment_124062

EPS Template.xlsx

Please see attached @raksina.samasiri

raksina.samasiri

Hi @John.Cajayon ,

This code can be used, the parameters can be adjusted in the variables start_date, end_date, period, frequency. And the list of instrument is assigned into rics_list Python list

import lseg.data as ld

ld.open_session()




start_date = '2000-01-01'

end_date = '2024-12-31'

period = 'NTM'

rics_list = ['AAPL.O', 'MSFT.O', 'GOOGL.O', 'AMZN.O']

frequency = 'M'




ld.get_data(

    universe=rics_list,

    fields=['TR.EPSMean.date', 'TR.EPSMean', 'TR.EPSActValue.date', 'TR.EPSActValue'],

    parameters={'Period':period, 'SDate':start_date, 'EDate':end_date, 'Frq':frequency}

)

hchoi2

https://community.developers.refinitiv.com/discussion/comment/124083#Comment_124083

Could you please revise the rics_list code to expand and include all US public firms, instead of the four companies? Thank you.

raksina.samasiri

Hi @hchoi2 ,

You can either use Advanced search or Screener application and create the Python list with the RIC list out of the result.

In case this could be of help, I've converted the RICs in your Excel sheet to Python List and put in the text file below, you can just copy and paste them into parameter 'universe'

2025-eps-rics.txt

However, please check the Usage and Limits Guideline section in https://developers.lseg.com/en/api-catalog/lseg-data-platform/lseg-data-library-for-python/documentation to not exceed limits, you will need to do like diving the list into chunks and call the function in loop with these input.