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?
df, err = ek.get_data(ric,['TR.BondISIN'])
df, err = ek.get_data(bonds_list,parameters)
df.dropna(how="any", axis=0, inplace=True)
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.