Get cumulative abnormal returns

Question

Question by lorenzo.cerreta · Oct 18, 2020 at 03:16 PM · python api timeseries eikonapi price

Get cumulative abnormal returns

I need to estimate CAR for a bunch of bonds issuers, so I am starting by getting their closing price. I am unable to resample with a single index and get the data on different columns.

bonds, err = ek.get_data(
    df['Ultimate Parent ID'],
    ['TR.PriceClose.date', 'TR.PriceClose'],
    {'SDate': '2020-01-01',
     'EDate': '2020-10-01'})

What I get is:

I would prefer to get a single timeseries with a column for each instrument, but I am unable to rearrange the df. Should I use ek.get_timeseries instead?

capture.png (12.0 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2020-10-19T05:37:46Z

REFINITIV

Best Answer

Answer by chavalit.jintamalit · Oct 19, 2020 at 05:37 AM

Hi @lorenzo.cerreta

You can use pivot() and transpose() functions from dataframe.

Here is an example:

ahs.png (40.3 KiB)

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

lorenzo.cerreta · Oct 19, 2020 at 06:49 AM 0

Share

Thanks for the great answer!

Get cumulative abnormal returns

1 Reply

Watch this question

Related Questions