After many frustrated days without any result to calculate the cumulative abnormal return, I need some help to know how to code the car. As you can see below, I added a picture of the situation. I want to capture the CAR t+4 : t+60. Or in other words, the starting point to calculate the car (AR) is 4 trading days (data) after the earnings announcement (anndats_act) till 60 trading days after the earnings announcement. I already merged the databases that I needed, and created a sample document based on one company with multiple earnings announcement. In this case 2015, and 2016. Otherwise, if I am testing the code, the run will take forever, if it is based on million observations
cusip8 = company code
anndats_act = earnings announcement
data = trading days
AR = Abnormal returns
For example, 24feb2015 is the earnings annoucement (anndats_act) for a certain company (cusip8). I want to capture the cumulative abnormal return (AR) from 27feb2015 (4 trading days after the earnings announcemen) till 60 trading days after earnings announcement. I want to capture the car for multiple companies that contain multiple annual earnings announcements. So, I want to create a new variable like gen car t+4 : t+60 = sum(AR) , by (cusip8 & anndats_act t+4 t+60).
I look forward to hear your suggestions how I can write the code to capture the car t+4 : t+60 for each company and unique earnings announcement.
Array
Related Posts with Programming question about the sum of each ID and specific period
Export data in histogramI am new to stata (I am using version Stata/IC 12.1 for Mac, 64-bit Intel) and succeeded in producin…
Consolidating two column variablesI have two column variables j8 and j9 and they complement each other. j8 is asking if they plan and …
analysis on two-eye datasetHello, I am trying to compare the intraocular pressure (IOP, a continuous variable) between two trea…
Intraclass correlations with meologit?Hi all, I'm revisiting my analysis for a revise & resubmit article but I'm having trouble repli…
How to introduce initial values in CMP for 4 eq. TobitsHi, I am estimating a model with 4 equations, each of them Tobit for a Time Use Survey (US edition).…
Subscribe to:
Post Comments (Atom)
0 Response to Programming question about the sum of each ID and specific period
Post a Comment