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