I am conducting an event study (dividend announcements) with 109 companies and an event window -5/+5 and estimation window of 180.
As I am new to Stata, I have done my analysis after long hours but now I am struggling with presenting my output in a nice table.
I want it to look like the uploaded pictures (2&3).
I am using the following code:
Sorting Data & Predicting Normal Return
Code:
use "eventdates.dta", clear joinby company_id using "stockdata.dta" egen group_id = group(company_id event_date) save "data2useRP.dta", replace use "data2useRP.dta", clear sort company_id date by company_id: gen datenum=_n by company_id: gen target=datenum if date==event_date egen td=min(target), by(company_id) drop target gen dif=datenum-td by company_id: gen event_window=1 if dif>=-5 & dif<=5 egen count_event_obs=count(event_window), by(company_id) by company_id: gen estimation_window=1 if dif<-6 & dif>=-185 egen count_est_obs=count(estimation_window), by(company_id) replace event_window=0 if event_window==. replace estimation_window=0 if estimation_window==. keep if event_window | estimation_window set more off gen predicted_return=. egen id=group(company_id) forvalues i=1(1)109 { l id company_id if id==`i' & dif==0 reg ret market_return if id==`i' & estimation_window==1 predict p if id==`i' replace predicted_return = p if id==`i' & event_window==1 drop p }
Code:
sort id date gen abnormal_return=ret-predicted_return if event_window==1 by id: egen cumulative_abnormal_return = total(abnormal_return) sort id date by id: egen ar_sd = sd(abnormal_return) gen test =(1/sqrt(11)) * ( cumulative_abnormal_return /ar_sd) list company_id cumulative_abnormal_return test if dif==0 sort dif by dif: egen AAR = mean(abnormal_return) bysort company_id (dif): gen CAAR = sum(AAR) sort dif by dif: egen AAR_sd = sd(abnormal_return) gen AAR_test =(sqrt(109)) * (AAR /AAR_sd) sort dif by dif: egen CAAR_sd = sd(cumulative_abnormal_return) gen CAAR_test =(sqrt(109)) * (CAAR /CAAR_sd)
I would really appreciate it, if you can help me on this task.
Thank you a lot.
Bernd Eber
0 Response to EventStudy Ouptut table / outreg2?
Post a Comment