Make an excel spreadsheet about the following deals:

- The biggest 20 M&As done by NASDAQ 100 or SP 100 firms on or before 2018

- The biggest 10 M&As done by NASDAQ 100 or SP 100 firms in the year 2019 and 2020

Pls collect the following information about the deals:

- Acquirer name and ticker

- Acquiree name and ticker

- Date of M&A announcement

- Stock price of the acquirer one day before the announcement

- Stock price of the acquirer one day after the announcement

- Stock price of the acquirer one year before the announcement

- Stock price of the acquirer one year after the announcement (if any)

- Stock price of the acquiree one day before the announcement

- Stock price of the acquiree one day after the announcement

- Stock price of the acquiree one year before the announcement

- Stock price of the acquiree one year after the announcement (if any)

- What is the term of the merger? (e.g., 21.5 billion in stock and 12 billion in cash)

- Deal close date

Could you also give some clues how to find these information. Thank you