How do I get the closing prices of the 10-first trading days for all stocks listed at german stock e

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

Best Answer

  • @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