I have a list of mergers and their respective rank, announcement, and effective date. I also have the ultimate parent of the target companies in the mergers. What I want to know is what the change in the stock price of the ultimate parent is on the different dates. Further I would like to know what the change in other indices such as the S&P500 is on the dates (the dates are different for each merger and I can't thus just make a list of companies).
Is there a way for me to link the data set on the mergers with the stock price of the ultimate parents on the dates somehow?
I can only get a CUSIP 6 digit code for each company but no share price in the mergers & acquisitions advanced search function which I used to create the list.