I ran into some issues retrieving the data.
There is data for some RICS on the UI, but when I try to get the data via the API, it returns NA. Additionally, if I use the SDate and EDate parameters to collect data for a range of certain dates, I also receive data for earlier dates. However, I only want the data in those precise ranges.
I need your assistance to fix this problem.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
3
●0 ●3 ●8
Refinitiv Eikon
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
79.2k
●251 ●52 ●74
Thank you for reaching out to us.
You can use the Data Item Browser tool to check the available fields for each RIC.
I checked and found that TR.TotalRevenue is not a valid field for JPM. You can use the TR.F.TotRevenue field instead.
df, err = ek.get_data(instruments=["JPM"],
fields=['TR.F.TotRevenue','TR.F.TotRevenue.periodenddate','TR.F.TotRevenue.calcdate'],
parameters={'Period':'FQ0','Frq':'FQ','SDate':'2018-01-01','EDate':'2023-08-08'})
df
Otherwise, you can also contact the Eikon Excel support team directly via MyRefinitiv to verify the data of those fields and RICs. Typically, the API can retrieve the same data as the =TR function in Eikon Excel.
3
●0 ●3 ●8
I want to get the data for shortsale ratio and trailing PE i'm using this fileds 'TR.PriceSalesRatioActValue' 'TR.SHORTSALERATIO' but not getting the data.
3
●0 ●3 ●8
I'M using the SDate and EDate but still I'm getting the data of prior dates also for some stocks and I for ebita and estimates I'm getting duplicates dates. I attached the screenshots. please help me out.
79.2k
●251 ●52 ●74
As this forum is more for programming type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket with our helpdesk.
That way a Content specialist can work closely with you and verify the assumption.
3
●0 ●3 ●8
There are now two significant problems.
1. The time series data for EBITA , Cost of Goods, and Broker Estimates (not smart estimates) are what we are after. However, if we specify SDate and EDate, we get the data for earlier dates along with some duplicates and NA values. All we need is a way to fetch these data points either per reporting period (e.g. period ending 31st ,March,30th June etc.) or per actual reporting date(eg. 20 th April period ending 31st March, 18 July for period ending 30th June etc.) we need both reporting date and period end date in the API response to store it accurately. And we need data from 2010 onwards as initial load and load whenever new quarterly earnings are released.
2. We wish to retrieve data for around 4000 rics, but when we attempt to do so, one security after the other , after a 100 calls, we receive a backend error and an HTTP timeout Exception.
