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.
Best Answer
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.