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.
Best Answer
-
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'})
dfOtherwise, 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.
1
Answers
-
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.
0 -
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.
0 -
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.
0 -
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.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛