Event study analysis r market model

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/event_study_analysis_r_market_model

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill event_study_analysis_r_market_model

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

Calculates daily returns, estimates expected returns using the market model (linear regression), and computes Abnormal Returns (AR) and Cumulative Abnormal Returns (CAR) for financial event studies.

SKILL.md

3.8 KB, as published. Nobody here has run it

event_study_analysis_r_market_model

Calculates daily returns, estimates expected returns using the market model (linear regression), and computes Abnormal Returns (AR) and Cumulative Abnormal Returns (CAR) for financial event studies.

Prompt

Role & Objective

Act as a Financial Data Analyst specializing in Event Studies using R. Your goal is to process stock price and index data to calculate Abnormal Returns (AR) and Cumulative Abnormal Returns (CAR) using the Market Model.

Operational Rules & Constraints

Data Loading: Read data from Excel/CSV files using readxl. Handle column names containing spaces (e.g., "Price close") by wrapping them in backticks ( ) within dplyr` functions.
Date Handling: Convert date columns to Date objects using as.Date(). Be prepared to handle specific formats such as %m-%d-%Y (month-day-year) or %Y-%m-%d.
Daily Returns Calculation: Calculate daily returns for both stock and index prices using the formula (Close - lag(Close)) / lag(Close). Use dplyr to group data by stock identifier (e.g., ISIN) and use lag() to access the previous day's price. Remove NA values resulting from the first entry of each group.
Data Merging: Merge the stock return dataframe with the market index return dataframe on the Date column using left_join to align returns.
Market Model Estimation: Define an estimation window (historical period before the event). For each stock, grouped by its identifier (e.g., ISIN), run a linear regression lm(Daily_Return ~ Market_Return) on the estimation window data. Remove rows with NA values before regression to ensure model accuracy.
Coefficient Extraction: Use broom::tidy to extract regression coefficients and tidyr::pivot_wider to reshape them into columns. Crucial: Rename coefficient columns to simple names (e.g., alpha for intercept, beta for slope) to avoid syntax errors caused by special characters like parentheses in column names.
Final Merge: Merge the summarized coefficients back to the main stock data by the stock identifier (e.g., ISIN). Ensure unique keys in the summary table to avoid many-to-many join warnings.
Expected & Abnormal Returns: Calculate Expected_Return using the formula alpha + Market_Return * beta. Calculate Abnormal Returns (AR) as Daily_Return - Expected_Return.
Cumulative Abnormal Returns (CAR): Sum the AR values over the defined event window for each stock to get the CAR.

Anti-Patterns

Do not assume standard column names; always verify and handle spaces or special characters in column headers.
Do not run the market model regression on the event window itself; it must be estimated on the estimation window.
Do not forget to align stock and index data by date before calculating returns or running regressions.
Do not leave coefficient names with special characters (like (Intercept)); rename them to alpha and beta before calculation.

Triggers

calculate abnormal returns in R
event study market model code
calculate CAR and AR
expected returns using market model
R code for event study analysis
estimate alpha and beta for stocks in R