Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
vishal.kak avatar image
9 ●1 ●8 ●13

how can I retrieve bond type from isin using eikon data api

Can I use get_data Eikon data API to get the bond type (e.g Treasury, savings, agency, municipal, and corporate ) from isin

e.g

df, e = ek.get_data(['US912828D564', ...,...],['TR.***BOND TYPE***'])


Is there a TR.*** that could return me the bond type

eikon-data-api
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.

Shadab Hussain avatar image   Shadab Hussain

Hi @vishal.kak ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.


Thanks,

AHS

zoya faberov avatar image   zoya faberov

Hello @vishal.kak ,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
78.9k ●250 ●52 ●74

@vishal.kak

I checked and found that the fields could be TR.FiSovereignClassDescription and TR.FiInstrumentTypeDescription.

1642744083345.png

You can find other fields by using the Data Item Browser tool. Please refer to the following resources.

Otherwise, you can contact the Eikon Excel support team directly via MyRefiniv and ask for TR fields which can be used with the =TR excel function to retrieve the required information.


1642744083345.png (26.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.

Upvotes
Shadab Hussain avatar image
884 ●4 ●2 ●8

Hi @vishal.kak ,

In addition to @Jirapongse answer, here is the code for data item for the Bond Type:

df, err = ek.get_data(
instruments = ['912828D56='],
fields = ['TR.FiSovereignClassDescription','TR.FiInstrumentTypeDescription', 'TR.FiAssetTypeDescription']
)

display(df)

1642746416839.png

Let me know if this is what you are looking for


1642746416839.png (36.3 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.

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.