Finding stock price changes on specific dates

simo18aj

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.

zoya faberov

Hello @simo18aj,

From my understanding, if you have CUSIPs of the parent stocks, and the target dates, you can convert it to RIC and request the closing price on the specific day and the next day, to determine the change.

Would something like this be what you are looking for?

With result: