Eikon bond identifier query retrieves unrelated bond ISIN

Question

question

alireza.aghaee

3 ●0 ●0 ●3

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

eikon-data-api #technology bonds isin

Dec 11, 2022 at 11:43 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aramyan.h Dec 19, 2022 at 12:27 PM

Hi @alireza.aghaee ,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Answer 1 · 2022-12-12T04:22:31Z

frank.ling1

166 ●2 ●1 ●3

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.

1.png (336.9 KiB)

2.png (196.1 KiB)

Dec 12, 2022 at 04:22 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2022-12-13T02:47:48Z

raksina.samasiri

14.2k ●30 ●5 ●10

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?

1670899606567.png (34.2 KiB)

Dec 13, 2022 at 02:47 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Q&A Forum

question

Eikon bond identifier query retrieves unrelated bond ISIN

2 Answers

Write an Answer

question

Eikon bond identifier query retrieves unrelated bond ISIN

2 Answers

Write an Answer

Related Questions