Eikon bond identifier query retrieves unrelated bond ISIN

I have a list of ISINs but the problem is that some of them are 'Corresponding 144A ISIN' or 'Corresponding Regulation S ISIN', of the same bond. I am trying to find these duplicates and group them using eikon python API.
The problem is that sometimes the API returns seemingly unrelated bond identifiers.
For example, US887317AS48 is an ISIN of a bond from "Warner Media LLC". When I search the other identifiers for this bond using the following code
df, err = ek.get_data(
instruments = ['US887317AS48'],
fields = [
'TR.BondIdentifier',
'TR.BondIdentifierType']
)
I will receive US00206RJJ23 as the corresponding Registered ISIN if df. However, US00206RJJ23 belongs to a bond from AT&T!!! The two bonds differ in the coupon, maturity, and almost everything. There is no way to assume the two ISIN codes are referring to the same issue.
I would really appreciate any help.
Instrument Bond Identifier Identifier Type
0 US00206RJJ23 A2R3HM Wertpapier
1 US00206RJJ23 US887317AS48 Corresponding Registered ISIN
2 US00206RJJ23 887317AS4 Corresponding Registered Cusip
3 US00206RJJ23 US00206RMD16 Corresponding 144A ISIN
4 US00206RJJ23 00206RMD1 Corresponding 144A Cusip
5 US00206RJJ23 BK946P9 Sedol
6 US00206RJJ23 USU04644CV73 Corresponding Regulation S ISIN
7 US00206RJJ23 T4833813 NASD Bond Symbol
8 US00206RJJ23 US00206RJJ23 ISIN
9 US00206RJJ23 00206RJJ2 Cusip
10 US00206RJJ23 201121469 Common Code
Best Answer
-
Hi Alireza,
I tried your codes with both ISIN "US887317AS48 " and "US00206RJJ23" and return correct results as expected.
Please also be noted that AT&T completed acquisition of 100% shares of Time Warner Inc in 2018, later Time Warner Inc delisted and renamed to Warner Media LLC.
0
Answers
-
Hi @alireza.aghaee ,
I also cannot reproduce an issue you faced. If the issue still persists, could you please provide the version of Eikon Desktop, Eikon Data API Python library, and Python for further investigation?
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
- 616 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
- 652 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 中文论坛