Python API - Error retrieving Fundamental data via get_history - Temporary data retrieval issue

I am extracting fundamental data and am receiving random errors on a large number of instruments (>2000 items) error: "Unable to resolve and collect data for all requested identifiers and fields". Even though the refinitiv workspace tells me it’s a "temporary" issue, over a week or so attempting it multiple times I always get this error. What is going on?
The breakdown of the problem, highlights a) the python code and error, b) the workspace and c) a selection of these instruments for which this counts.
A) Simplified code and error
The simplified code that I am following is as follows:
import lseg.data as ld
from lseg.data.content._header_type import HeaderType
ld.open_session()
parameters = {
"SDate": '-30Y',
"EDate": '-1d',
"FRQ": "FY", # frequency, full year
"Curn": "EUR",
"Scale": 3,
}
fundamental_df = ld.get_history(universe=['5000678616'],
fields="TR.F.TotRevenue",
header_type=HeaderType.NAME,
interval="1Y",
parameters = parameters)
ld.close_session()
The error:
Unable to resolve and collect data for all requested identifiers and fields. Requested universes: ['5000678616']. Requested fields: ['TR.F.TOTREVENUE']
Workspace
If you go into the workspace, you retrieve the error "Temporary data retrieval issue, please try again". See screenshot. This seems to suggest that it’s a temporary issue, and I must try again. However, running the code over a period of multiple days and weeks this seems to persist.
C) Example instruments.
I can provide you a list of over 2000 items with this error, a small random selection of these items are the following with which you can test.
5000678616
4295909227
4295917510
5082539508
5050267279
5067486052
5084951620
5054881763
4296378835
4296137840
5037016660
Thanks
Best Answer
-
Hi @r.fernandez ,
I checked some of the ids you have above, and it doesn't seem we have TR.F.TotRevenue data for those Private/Delisted companies. If you check them in Workspace Data Item Browser, you will see no data is returned there. See an example for4296378835:
This suggests that the issue is not related to the library but rather to the content. To learn why no data is retrieved for those companies (I am assuming that is because these are private/delisted ones) I would advice raising a content query via Helpdesk.
Hope this helps.
Best regards,
Haykaz
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 651 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛