hi, previously we used eikon excel formula to retrieve these data:
=@RDP.Data(C3:C1902;"TR.AnnAdjustedEPS;TR.AnnAdjustedEPS.currency;"&"TR.EpsSmartEst;TR.EpsSmartEst.currency;"&"TR.BVPSTotalEquity;TR.BVPSTotalEquity.currency;"&"TR.FCFPSMeanEstimate;TR.FCFPSMeanEstimate.currency;"&"TR.TotalRevenue;TR.TotalRevenue.currency";"CH=Fd";F2)
In codebook for workspace some of the fields were not found. Could you please advise whether these fields will have same names for python script? And for how many securities at once can we retrieve these data?
Thank a lot
1
●0 ●0 ●0
EPS Fundamental data to retrieve via Workspace
Also, when I retrieve the data with this formula via excel it gets only the numeric value.
However, when I use this formula in python, I receive a whole data frame, for example:
I can clean it and get only value, but I suppose it affects the data load and slows the process a lot.
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
Hello @stoxxindex
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
10.2k
●18 ●6 ●9
@stoxxindex Thanks for your question - so the following code works well for me using the Refinitiv Data Libraries in Codebook:
import refinitiv.data as rd
rd.open_session()
rd.get_data( universe=['VOD.L'], fields=["TR.AnnAdjustedEPS","TR.AnnAdjustedEPS.currency","TR.EpsSmartEst","TR.EpsSmartEst.currency","TR.BVPSTotalEquity","TR.BVPSTotalEquity.currency","TR.FCFPSMeanEstimate","TR.FCFPSMeanEstimate.currency","TR.TotalRevenue","TR.TotalRevenue.currency"] )
This is for one company - I notice on your excel formula you were trying to pull data for around 1900 instruments and say 10 fields - this is above the data limit for the get_data function which is 10,000 datapoints per API call. You can find out more about data limits and throttles here. You might want to break that down into max 500 Instruments per call and make 4 calls in a loop. I hope this can help.
