question

Upvotes
Accepted
135 15 10 10

From bond ticker to issuer information with Python

Hello! I have a list of bond tickers, e.g. LHNLF , UBSNL and I am trying to download sectors of activity of the issuers from the field TR.TRBCActivity. How can I do that? Is there a specific parameter I need to set to get this working? Many thanks!

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apibondssectors
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
86.2k 292 53 79

@alex.yermolayev

From my finding, Eikon Data APIs can't retrieve data by using these tickers because the get_symbology method can't convert these tickers to RICs.

Therefore, you need to directly use RICs in order to get the data.

I have used Eikon Excel to find RICs for those tickers.


1576479872288.png (15.6 KiB)
icon clock
10 |1500

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

To add to the response by @jirapongse.phuriphanvichai, in Excel you could use RSearch function to retrieve the list of bond RICs given a bond ticker. The example below retrieves the list of active bonds RICs with the ticker LHNLF. This functionality is not yet available through Eikon Data APIs. The only Eikon API that currently provides this capability is legacy RSearch COM library of Eikon COM APIs.

=RSearch("BOND","DBSTicker:LHNLF IsActive:Yes")

Hello! Many thanks for the reply. When will bond search functionality be available in Eikon Data API?

The search functionality is not available in Eikon Data API.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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