Single Event Study Sheet

We offer an accessible Google Sheets template designed to demonstrate the practical implementation of Event Studies directly within your browser using the GoogleFinance API. Still, your data could also be copied into the sheet. Accessing the provided Google Sheets link will guide you through a detailed, step-by-step example showcasing the execution of event studies using this platform. All you need to do is enter the firm and reference the market stock symbol and the beginning and end date of the daily data extraction. The GoogleFinance API will automatically fetch the relevant (daily and adjusted) data directly into your Google Sheet. Afterwards, you define the Event Date, the Event Window, and the Estimation Window. All other stuff is performed automatically in the sheet for you.