question

Upvotes
Accepted
3 1 5 9

Refinitiv Eikon

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.1.png4.png

eikoneikon-data-apiworkspace#contentrefinitiv-data-librariessupporthelpdesk
1.png (130.7 KiB)
4.png (81.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Accepted
86.3k 292 53 79

@vishnu01

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
3 1 5 9

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
3 1 5 9

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.6.png5.png


6.png (70.3 KiB)
5.png (67.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
86.3k 292 53 79

@vishnu01

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
3 1 5 9

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.1.png




1.png (83.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.