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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 2 4 5

Bond data retrieval

Hi

I have to get for a list of companies their bond data (seniority, duration, yield)

Following code works, but maybe there is a more efficient way to do it, in one request?

Thanks

ric='AAPL.O'

parameters=['TR.FISeniorityTypeDescription','TR.DurationAnalytics','TR.FiMaturityStandardYield']

df, err = ek.get_data(ric,['TR.BondISIN'])

bonds_list=df['Bond ISIN'].to_list()

df, err = ek.get_data(bonds_list,parameters)

df.dropna(how="any", axis=0, inplace=True)

df

get-bond-data.jpg

eikoneikon-data-apipythonbonds
get-bond-data.jpg (74.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.

1 Answer

Upvotes
Accepted
56.1k 145 45 65

@elie

I am not sure that you can do this in one request.

However, you can contact the Eikon Excel support team directly via MyRefinitiv to confirm it by asking for the =TR formula in Eikon Excel which can be used to retrieve the data you would like to get.

If the formula is available, we can apply it to the get_data method in Eikon Data API. That way a content specialist can work closely with you to find a way to get the required data.

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.