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
Creating Fixed effectHey, i have a panel data, i need to add a Race_grade fixed effect and i have two separate variables …
Deriving change over time by change in groups of variablesI'm running a regression to try to explain how long people spend in a hospital's A&E (ER) depart…
Create a continuous variable for blood pressure using two variablesDear List, I wonder if any of you know how to make a continuous blood pressure variable from two va…
Merge m:m in a panel, can't merge BY two variablesHello, I have tried to look for similar queries but couldn't find any. Thanks in advance for readin…
Using asdoc to export two-sample t-test by groups and other summary statisticsHi, I would like to export summary statistics (two sample t-test of the difference of the two group…
Subscribe to:
Post Comments (Atom)
0 Response to Programming question about the sum of each ID and specific period
Post a Comment