How do I get the closing prices of the 10-first trading days for all stocks listed at german stock exchange for the last 20 years in eikon?

Question

Question by laura.troost · Mar 11, 2019 at 12:46 PM · eikon eikon-data-api workspace workspace-data-api refinitiv-dataplatform-eikon python pricing exchanges

How do I get the closing prices of the 10-first trading days for all stocks listed at german stock exchange for the last 20 years in eikon?

Currently I am writing my thesis investigating in IPO-Underpricing and to test one hypotheses, which explains underpricing on the german stock market I need the the closing prices of the 10-first trading days for all stocks listed at the german stock exchange over the last 20 years.

I woud be very thankful if someone could help me.

Kind regards

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 · 2019-03-12T07:49:32Z

REFINITIV

Best Answer

Answer by Zhenya Kovalyov · Mar 12, 2019 at 07:49 AM

@laura.troost

it can be done with a few steps:

Request all listed ordinary shares from Germany, first trading date
Calculate the end date for the time span you are interested in
Send one request for each equity, as the dates are unique

Attached please find the draft model for this: jupyter.zip

jupyter.zip (2.6 KiB)

0 · 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.

How do I get the closing prices of the 10-first trading days for all stocks listed at german stock exchange for the last 20 years in eikon?

1 Reply

Watch this question

Related Questions