Retrieve list of bonds for a certain company in python

Options
ant1bball
ant1bball Explorer
in Eikon Data APIs

Hello I would like to retrieve a list of bonds for a certain instrument, say AAPL.O. For the moment i have tried using the TR.BondRIC however this only returns the code for one "plain vanilla fixed coupon bond". Is it possible to retrieve a list of all the bonds so i can then sort them by yield, yield date, and last price?

Basically i want to be able to retrieve the same info i can see in Debt&Credit->DebtStructure->All bonds by maturity. The i will sort the top 10 by yield or whichever are of interest to me.

Thanks a lot in advance,
Antonio

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    @ant1bball works for me, 140 bonds.

    image

    there are a few catches with this approach, though, but if you are looking at large companies, this should be ok.

    Otherwise, some of the borrowers issue debt through special purpose vehicles that are not connected to the borrower. For that you would need to be using the RSearch API that Alex mentioned.

Answers

Categories