Upgrade from Eikon -> Workspace. Learn about programming differences.

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 ●1 ●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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apipricingexchanges
icon clock
10 |1500

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

Alex Putkov.1 avatar image   Alex Putkov.1

@laura.troost
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

@laura.troost

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply.

Otherwise, you may share an answer and then accept it. This will guide all community members who have a similar question.

Thanks,

AHS

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an 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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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