How can I use python to get issued bonds of an issuer for a given issuer's Ticker?

For example, I want to get the bonds issued by BABA, I can use Advanced Search app or debt structure of BABA to see the results on eikon workspace, but how can I get those bonds by python eikon api?


the results are just like the picture shows:image

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • aramyan.h
    aramyan.h admin
    Answer ✓

    Hi @sunminghui


    You can use Search capabilities of Refinitiv Data Libraries for Python. The best way to get the query is to use the Advanced Search app itself. You can build the filters in the Advanced Search, the export the query as shown below:

    screenshot-2023-11-14-at-122437.png

    After you copy the code from the below output and run it in codebook or in your local IDE, it should provide the same output as you see in Advanced Search app.

    screenshot-2023-11-14-at-122509.png

    See the code below:

    import refinitiv.data as rd
    rd.open_session()

    rd.discovery.search(
    view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
    top = 10,
    filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and IsActive eq true and ((IssuerOrgid eq '100906681')))",
    select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,IssuerOrgid"
    )


    Hope this helps, let me know if any further questions.


    Best regards,

    Haykaz

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.