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

zxiaoah
zxiaoah Newcomer
in Eikon Data APIs

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

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.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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

Answers

Categories