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.
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
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?
Please see attached @raksina.samasiri
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} )
Could you please revise the rics_list code to expand and include all US public firms, instead of the four companies? Thank you.
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'
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.
