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

zxiaoah

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.

Jirapongse

@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('/','-')})