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.
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 reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
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.
Hello, I am planning a similar project.
Unfortunately, the formula does not work for me.
For the BMW share, I used the German stock exchange abbreviation "BMW" instead of FB. Both with and without "0".
=TR("BMW.O","TR.PriceClose","EDate=20120518 CH=Fd RH=Date")
=TR("BMW","TR.PriceClose","EDate=20120518 CH=Fd RH=Date")
Could you please help me
