I would like to study impacts of venture capital financing of entrepreneurial firms on their post-IPO performance.
Questions would be like: Does the total venture capital financing volume have an impact of the post-IPO performance?
In order to examine these questions I want to use two different data soruces within Eikon.
I used the "PE Screener" or "Private Equity Screener" to collect data about the venture capital activities of entrepreneurial firms before they went public.
I used the Screener for public companies to collect data on firms that went public in the same time period.
(Only three companies for simplification)
The problem now is that I have two excel files that I want to merge and I couldn't find an identifier variable for companies that match each other between the screeners. I tried to "build" an identifier with Name, founding date, date of IPO etc. but it turned out that these variables differ between the screeners.
Does anyone have an idea to solve this problem? Like knowing an identifier that Ihave missed or another approach collecting the data?
If you need further Information on this issue, I would be happy to provide it here.
Thank you very much in advance!
All the best