Dear all,
I have a M&A deal list for public US companies from 2010 till 2021. I know want to match ESG scores to the target and acquirer, containing the scores 3 years prior to the merger event. Is it possible to easily do this in screener or should I input the list of acquirers and targets seperately, extract esg data and match to M&A event master file? I only have access to the web version of Thomson Reuters.