API Python Query
I am currently gathering company financial data through Eikon Data API (Python). I have a situation where the only working metric for the 2500+ company identification is the company's full name. I have also tickers and 6-digit CUSIP codes (obtained from the SDC Platinum M&A Database); however, the tickers are for EU companies only and often produce wrong results, and the 6-digit CUSIP codes do not seem to match the CUSIP codes available in the Refinitiv Eikon system. I have multiple problems and questions regarding the data extraction process through API (using Python): 1) Would it be possible to match the companies through the firms' Tickers, filtering out the USA and other stock exchanges, leaving just the Europe Area ones? 2) Are there any links to match the 6-digit CUSIP from SDC Platinum with the codes available (RIC, CUSIP, ISIN) in the Eikon Platform? 3) Are there any filters that would allow the API script to also search for delisted/inactive companies? 4) Are there any filters that would also allow for the script to search for "FormallyKnownAsName"? There seems to be such entry an entry in the Data Item Browser; however, putting it as an xeq filter does not seem to recognize it. Perhaps there is a place to look up such filters? 5) Are there any clear guides on how to work around API limits to extract larger-size outputs in one ask? I hope you will be able to shed some light on at least some of these questions. Feel free to direct me further with this inquiry if necessary.
Best Answer
-
What you are asking above would be possible using the Search capabilities of Refinitiv data libraries for Python. You can learn more about the APIs in this reference guide.
This article would be very useful for building the search queries and this article for easy identification of properties and values. Please have a look at those resources, build your query and if any questions regarding that feel free to repost here and we will be happy to look into it.
Hope this helps.
Best regards,
Haykaz
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 中文论坛