How can I retrieve historical price data on Excel for a list of 1000+ companies after an IPO?

Question

Question by alessandro.ciarla · Jan 14, 2021 at 05:08 PM · eikon eikon-data-api eikon-com-api historical time-series pricing

How can I retrieve historical price data on Excel for a list of 1000+ companies after an IPO?

I am interested in studying the performance of all the European companies that did an IPO between 2000 and 2020. I have downloaded the list of IPOs but now I don't know how to create a file which includes the historical price data for all the companies in the list.

Any help would be really appreciated.

Thank you.

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 · 2021-01-14T22:26:52Z

REFINITIV

Best Answer

Answer by Alex Putkov.1 · Jan 14, 2021 at 10:26 PM

There's a number of ways to retrieve price history for stocks. Here's an example of a worksheet function retrieving daily price history for Facebook from IPO date until today given the stock RIC (FB.O) and IPO date.

=TR("FB.O","TR.PriceClose","EDate=20120518 CH=Fd RH=Date")

For more details refer to the Help for Eikon Excel add-in.

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 can I retrieve historical price data on Excel for a list of 1000+ companies after an IPO?

1 Reply

Watch this question

Related Questions