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