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

vishal.kak

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

Jirapongse

@vishal.kak

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

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

• Data Item Browser and Eikon Data API in Python
  
• How to discover available fields for Data Grid service on JET(App Studio HTML5 SDK) API using Eikon Desktop

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.

Shadab Hussain

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)

Let me know if this is what you are looking for