Expert Dialog

Question #69: Duplicate event

I have this issue: "Duplicate event id: 0" but i dont have any duplicates

Answer by Dr. Markus Schimmer:
For guidance on how to resolve issues with your data, please see our page on the handling of error codes:
Question #68: Multiple grouping variables

For my master thesis, I need to execute an event study with 2 moderators: one is the strategy used for the event (three possible strategies) and one is the sector of the brand of the event (two possible sectors). Would I use two grouping variables to model this? Or is there another method to do this?

Answer by Dr. Markus Schimmer:
If you have two or more grouping variables that each have different values, you can apply two approaches, you can do the following: 1) Perform a full enumeration of the individual cases you have and set this as a new grouping variable. In your case, this would give you 6 values for the new grouping variable, with each value describing a distinct strategy-sector combination. 2) If you need to make statements about either of your grouping variables, re-run the analysis with only this grouping variable. In your example, combining both approaches will let you make statements about the strategies as such, the sectors as such, and as per the combination of both.
Question #67: Event Window

In my Anlaysis report, I get "The event window seems to include an unexpected number of days the firm's stock has not been traded on" for some of my events. Could you please tell me what exactly this means?

Answer by Dr. Markus Schimmer:
The message suggests that your price data holds more gaps than one would expect - meaning, there are more nontrading days than weekends. Ultimately, there might be two reasons for this: either there were several public holidays at this stock market or your data has gaps.
Question #66: EventStudy- Multiple events and firms

I have two sub-sets of events, "good news" (15 events) and "bad news" (17 events), which I wish to see their effect of different sectors of the FTSE. Could you guide me into how I can test for these subsets of events on a specific sector at once?

Answer by Dr. Markus Schimmer:
That's simple. Please use the grouping variable in the request file and label those lines that represent good news with "good" and those that represent bad news with "bad". Note: When you download the sample data, you will find the grouping variable to hold "addition" as a value since the sample data represents an excerpt of an index reconstitution study - unluckily, I only picked additions and missed out to pick a single deletion.
Question #65: Event Window

I'm encountering difficulty with the estimation window. Most research papers I have found take a [-120;-11] estimation window with a [-1;1] event window. But in the app when I try to put in that estimation window I get an "Event Data import" error. I have seen you answer this question before saying that the estimation window needs to have one positive number. How can I use the [-120;-11] window with the app?

Answer by Dr. Markus Schimmer:
The request file should have the following structure: Event ID; Firm ID; Market ID; Event Date; Grouping Variable; Start Event Window; End Event Window; End of Estimation Window; Estimation Window Length. This means that for your estimation window, you should have -11, 120 in the two very right columns of the CSV/XLS file.
Question #64: Multiple Events for one company

I'm trying to do an event study to look at the CAAR of stock prices during an M&A announcement. Some companies have had multiple announcements for different transactions. How can I put that in my data? It come back saying "Duplicate entry in event data" if I put the company name in twice. Do I need to change the name of the company? Delete duplicates? Would that not affect my results?

Answer by Dr. Markus Schimmer:
Each transaction is to be considered as an individual event. And each line in your request file has to have a unique ID as a reference in the first column. The error message you received suggests that you have used multiple times the same number/ID in this column. The company name is only used to retrieve the corresponding closing price data from the firm data file. Thus, if one firm has multiple events/lines in the request file, you should also list the company name multiple times.
Question #63: Generating AAR CAAR AND T-TEST

Can I conduct a complete event study using your app?

Answer by Dr. Markus Schimmer:
Yes, the research apps on this website will give you ARs, AARs, CARs, CAARs, and all test statistics at the respective levels of analysis - probably one of the most complete sets of statistics any solution will provide to you.
Question #62: Multiple Events which all affect the same Companies in one Study


I'm doing my Thesis right now and I have to test if certain events at single firms do have an effect on a group of other firms all in the same market. How would you recommend me doing this? All Events seperate? I got about 200 single Events and 50 firms spread globally

Answer by Dr. Markus Schimmer:
You have to fully enumerate the events per each company. Your request file will thus hold a larger number of lines. You can use the grouping variable to create meaningful subsets from this overall universe of events.
Question #61: Problem with grouping in CAAR and AAR results

I'm trying to conduct event study with two different groups. I have multiple event days and two groups. Event study tool gives me results from all the different days separately but doesn't show the grouped results in CAAR and AAR file. What could be the problem?

Answer by Dr. Markus Schimmer:
You need to assign two different labels/values to your overall set of events - using the column "grouping variable" in the request file. If the AAR and CAAR results are not correctly calculated, then there is an issue with the data quality of single events that are to be grouped. Try this: Go to your AR and CAR files and search for events that have no results. Discard those events from your request file and re-do your analysis. Like this, you sort out the events that caused the AAR/CAAR aggregation to fail and you should get meaningful AAR and CAAR results.
Question #60: event study intraday

I intend to use intraday event studies with a sample of 1,200 profit announcements issued after the close and before the opening of the B3 stock exchange. Would you have an example of intraday event study implementation to make available (excel, R or other format)? I have read many articles on the subject however, nothing very practical. I would like to adopt some of the novel techniques for detecting jumps. If you can suggest some specific practical literature for reading.

Answer by Dr. Markus Schimmer:
We are working on an intraday EST research app, however, its release may still take some time. In the meantime, I suggest you pick any current publication on the topic and go through its references to navigate the respective research on the subject. One such current publication is: "A Note on Intraday Event Studies" by Ben R. Marshall, Nick Nguyen & Nuttawat Visaltanachoti - it can be found here: