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.
Resolver not registered: react.asset.discussionTagsAsset
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.
Permission Problem You need the session.valid permission to do that.
