Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by ant1bball · Jun 12, 2018 at 04:42 AM · bonds#python api#pythonbond pricesbond schedules

Retrieve list of bonds for a certain company in python

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Jun 12, 2018 at 04:29 PM

@ant1bball works for me, 140 bonds.

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.


screen-shot-2018-06-12-at-212531.png (121.7 KiB)
Comment
ant1bball
jirapongse.phuriphanvichai

People who like this

2 Show 4 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
ant1bball · Jun 12, 2018 at 05:40 PM 0
Share

Thanks! I think i can survive with this for the moment. I was looking directly in the eikon data item browser thats why i didnt see the list (facepalm)

If i query for BondRIC i get 2443 results, while querying for BondISIN returns the 140 you mention. What is the difference between them? Do the BondRIC show these "special" debt issuances you mention?

Would you have an example/link of the RSearch for Bonds? might be useful for other users because the tutorial Alex mentioned is just a generic initialisation of an RSearch manager not how to search for bonds using .NET.

avatar image
REFINITIV
Alex Putkov. ♦♦ ant1bball · Jun 12, 2018 at 06:07 PM 0
Share

ISIN is an issue level identifier whereas RIC is a quote level (issue + price source). Typically there are several RICs corresponding to an ISIN.

avatar image
REFINITIV
Alex Putkov. ♦♦ ant1bball · Jun 12, 2018 at 06:09 PM 0
Share

The tutorial for RSearch COM API contains a downloadable example providing a complete implementation of the criteria search: you fill out the criteria in a form and retrieve the result. To find out what criteria you can use watch a video tutorial titled "Retrieve the list of options in Excel" available from the main Eikon menu - Help - Tutorials and Training, which shows how to use Search wizard in Excel to construct RSearch function. In RSearch COM library you can use the same arguments as in the RSearch function in Excel.

avatar image
ant1bball Alex Putkov. ♦♦ · Jun 13, 2018 at 02:05 AM 0
Share

Thanks alex :)

avatar image
REFINITIV
Answer by Alex Putkov. · Jun 12, 2018 at 09:50 AM

The only Eikon API that currently provides the capability you're looking for is the RSearch library of Eikon COM APIs. See the following tutorial for an example of using RSearch COM library in a custom .NET application.
https://developers.thomsonreuters.com/eikon-com/eikon-desktop-data-api/learning?content=806&type=learning_material_item

Comment
ant1bball

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
ant1bball · Jun 12, 2018 at 03:17 PM 0
Share

Is there an ETA on the implementation of this feature on the python API?

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Detecting a company has filed its quarterly/end of year report

Python API Cannot Post 404 Error

Download bond prices via Python API

Eikon python api Response 404

No data available for the requested date range​​ (HCN.TO)

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges