Bond data retrieval

elie

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

Jirapongse

@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.