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.

Find more posts tagged with

eikon

support

workspace

eikon-data-api

helpdesk

#content

refinitiv-data-libraries

Accepted answers

Jirapongse

@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.

All comments

Jirapongse

@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

vishnu01

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.

vishnu01

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.

Jirapongse

@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.

vishnu01

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.

EXPLORE OUR SITES