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

question

Upvotes
Accepted
55 4 0 3

How to get only top 5 peer companies list for a given isin list

Hi, I am using below code in python to pull the peers list for the given isin list. The api return more number of peers for each isin and there is no mapping for isin and peers. In the response, i need only top 5 peers for each isin and i want to map which peers belong to which isin. How to update the code ?

for isin in isin_list: peer_list.append('Peers(' + isin + ')')

df1, err = ek.get_data(instruments=peer_list, fields=["TR.PrimaryInstrument", "TR.ExchangeTicker","TR.CompanyName", "TR.ISIN"],raw_output=False);

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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

· Write an Answer
Upvotes
Accepted
4.6k 26 7 22

@uma, this is more of a python/pandas usage question, I strongly encourage you to research both. What you want can be achieved with this:

import eikon as ek 

import pandas as pd

First, let's design a function that is going to take top five peers, I have chosen the market cap as the selection parameter. After getting the data I sort by Market Cap, create a new column with my original company's ISIN code, and setting it as the index of my data frame before returning it:

def get_top_five_peers(code): 
	df, e = ek.get_data(f'PEERS({code})', ['TR.PrimaryInstrument', 'TR.ExchangeTicker','TR.CompanyName', 'TR.ISIN', 'TR.CompanyMarketCap(ShType=OUT)']) 
	res = df.sort_values(by=['Company Market Cap'], ascending=False).head(5).copy() 
	res['Peer of'] = code 
	res.set_index('Peer of', inplace=True) 
	return res 

Here is how you can use the `get_top_five_peers' function:

isins = ['US0378331005', 'GB00BH4HKS39', 'RU0009024277', 'US46625H1005'] 

df = pd.concat([get_top_five_peers(isin) for isin in isins]) 

Here is the result:


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.

Thanks for the answer. I tried the similar one before where it works for small number of isin list say upto 50. When i want to fetch for say 8000 isins, frequent get_data call results in Bad Request error. I tried even with sleep interval between calls still randomly i get server error.

Rather than pulling individual record, is there a way to pull the data in bulk ?

@uma, you are hitting a limit. To learn more, have a look at this document.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.