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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
laura.troost avatar image
1 ●0 ●1 ●1

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpricingexchanges
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.

1 Answer

Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

@laura.troost

it can be done with a few steps:

  1. Request all listed ordinary shares from Germany, first trading date
  2. Calculate the end date for the time span you are interested in
  3. 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)
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.

Click below to post an Idea Post Idea