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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
uma avatar image
55 ●2 ●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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Zhenya Kovalyov avatar image
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:


screenshot-2018-12-04-at-160224.png (291.0 KiB)
icon clock
10 |1500

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

uma avatar image uma

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 ?

Zhenya Kovalyov avatar image Zhenya Kovalyov uma

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

Click below to post an Idea Post Idea