ek.get_data returns wrong informations
Hi,
Our process of pulling data is to pull TR.FiIssuerOrganization using ISIN of a security via ek.get_data and then use that org_id to perform another ek.get_data call to get all the fields needed for that organization.
However, we've been getting some cases where the information seemed incorrect. I'll be listing out several case examples:
1. ISIN="KR6066261AA9"
- Below is the data from isin pull
- ['KR6066261AA9', '165496', 'LGCRPS', 'LGCRP', 'S&I CORP']
- Below is the data from org_id pull
- ['165496', '3 Banken Portfolio-Mix A', '', 'http://www.sni.co.kr/', '82237731114', '', '', '', '', '', '', '', '', None, '', '', '4295881132', 'Austria', '2002-01-01', None, '', '', 'Service Company', 'Service - Other']
As you can see, the get_data pulled a Fund profile instead of S&I Corp.
2. ISIN=
- Below is the data from isin pull
- ['CND100045HT7', '75877', 'SHSHI', 'GEFRN', 'SHANGHAI SHIMAO CO LTD']
- Below is the data from org_id pull
- ['75877', 'Shanghai Shimao Co Ltd', 'http://www.shimaoco.com', '862120203388', '862120203399', 60102030, '600823', 15979976791.86, 2615, '', 'AAA', 'Real Estate Development', '', '2021-12-31', 149304753980, '4297714707', 'China', '1992-07-01', None, '', '', 'Other Financial', 'Real Estate Investment Trust']
As you can see, The ticker information of one doesn't match the other. (SHSHI != 600823)
3. ISIN="SGXF51098246"
- Below is the data from isin pull
- ['SGXF51098246', '42122', 'HPPS', 'HLDIN', 'HOTEL PROPERTIES LTD']
- Below is the data from org_id pull
- ['42122', 'Hotel Properties Ltd', 'https://www.hotelprop.com.sg/', '6567345250', '6567320347', 25301020, 'H15', 1788711560.93, '', '', '', 'Hotels, Resorts & Cruise Lines', None, '2020-12-31', 3388229000, '5042257290', 'Singapore', '1980-01-28', None, '', '', 'Service Company', 'Lodging']
As you can see, The ticker information of one doesn't match the other. (HPPS != H15)
I would consider Case2 and Case3 to be similar but these are the three cases we've observed so far and would like to know how we can pull the correct information.
Thank you so much for your time.
Best Answer
-
1. If you don't restrict the type of input, you're running the risk of ambiguity, where the same exact code may refer to multiple entities, as is the case in this example. 165496 is the Org ID for S&I Corp, and it's also WKN (German Wertpapierkennnummer) for 3 Banken Portfolio-Mix T fund. To restrict the input type to Org ID, append "@orgid" to the Org ID number. E.g.
ek.get_data('165496@orgid', ['TR.CommonName'])
returns "S&I Corp".
2. You didn't specify the fields you're using, but I'm guessing you're not using the same field names in the 1st and 2nd request, as the 1st request returns the fixed income ticker for the bond with ISIN CND100045HT7, whereas the 2nd request returns the exchange ticker for the issuer's common stock.
3. Same as #2.
1
Categories
- All Categories
- 6 AHS
- 39 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛