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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
zxiaoah avatar image
3 ●0 ●0 ●1

How to retrieve peers multiple mean/median for a list of companies at given date

I have a csv file containing the list of RICs and specific date for each RIC, like this:

I want to retrieve the mean and median multiple (P/E, EV/EBITDA) for each company at its specific date, and I've written the following code:

df=pd.read_csv(loc)


dataset=[]

df2=df["ticker"].values.tolist()

df3=df["date"].values.tolist()


for x in range(0,1):

keyword=df2[x]

date=df3[x]

data,err = ek.get_data('Peers("keyword")', ["TR.EVToEBITDA", "TR.PE"],{'SDate':date})

dataset.append(data)


the code is not working, especially the Peers("keyword") is treated as a string and Peers function doesn't work. I am wondering how can I modify my code to reach my goal.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonricspeers
screen-shot-2020-08-04-at-110745-am.png (91.1 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.

2 Answers

Upvote
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@zxiaoah

The date format is incorrect. The correct format is 2014-01-09.

Therefore, the code should be:

df=pd.read_csv(loc)
dataset=[]
df2=df["ticker"].values.tolist()
df3=df["date"].values.tolist()

for x in range(0,1):
    keyword=df2[x]
    date=df3[x]
    print(keyword, date)
    data,err = ek.get_data('Peers({})'.format(keyword), ["TR.EVToEBITDA", "TR.PE"],{'SDate':date.replace('/','-')})
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.

zxiaoah avatar image zxiaoah
Thank you! It works perfectly.
zxiaoah avatar image zxiaoah

Hi, I want to know if I can calculate the mean or median of the multiple of peers for a certain company within each loop? so that I can return a data frame with peer mean/median for each RIC.

Upvotes
Jirapongse avatar image
38.1k ●71 ●35 ●53

@zxiaoah

I have run this code:

data,err = ek.get_data('Peers("1353.HK")', ["TR.EVToEBITDA","TR.PE"], {'SDate':'2014-01-09'})
data

The output is:

From the result, the Peers function works fine.


1596516028950.png (22.9 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.

zxiaoah avatar image zxiaoah

Thank you! but I have a list of over 600 stocks and manually changing instrument and date takes too much time. is there a way that I can use for loop or other to do that?

chavalit-jintamalit avatar image chavalit-jintamalit zxiaoah

Hi @zxiaoah

https://www.w3schools.com/python/python_for_loops.asp

You can consider using loop in Python.

So you would have a list of RIC and Date in each loop and do the API call.

zxiaoah avatar image zxiaoah chavalit-jintamalit

Thanks! I tried to use loop in my original code (shown above) but the "keyword" is always intrepreted as a string instead of the RIC I want. Could you give me some hints on how to modify my code?

Click below to post an Idea Post Idea