Eikon bond identifier query retrieves unrelated bond ISIN

alireza.aghaee

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

frank.ling1

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.