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
Probit or logit?Dear community? Is there any difference in using probit or logit regression when i have binary DV? …
Strata option in Bootstrap commandHello everybody, for my PhD thesis I am developing a DiD model that captures the effects of a partic…
Panel Data model: DIagnostic testingHi stata community. I really need help. I have a long panel T=17 and N=8(countries). These are the s…
Loop regexm to search for multiple strings stored as observationsDear Statalists, I have sucessfully used regexm to search for one string (a diagnose code, for exam…
Speed of StataDear All, I am using stata 15.1. I noticed something that I cannot explain. I am using the command …
Subscribe to:
Post Comments (Atom)
0 Response to Programming question about the sum of each ID and specific period
Post a Comment