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
- 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 中文论坛