Beginner: Event Study, Error: Duplicate Event ID: 0

[Lorenz Klein]

Dear all
I am currently writing my master thesis about abnormal returns for a certain equity after the company announced M&A deals. For this, my professor asked me to use the following website: https://eventstudytools.com
Under Research Apps --> bARC Calculator I am supposed to upload three files:
1.) A Request Data file
2.) A Firm Data file
3.) A Market Data file.

Structure of file 1)

• Event ID [Integer]: A unique event identifier.
• Firm ID [String]: The firm name or stock ID. This ID must match the ID in the firm data.
• Market ID [String]: The reference market ID. This ID must match the ID in the market data.
• Event Date [30.04.1997]: Date of the event.
• Grouping Variable [String]: This column is used to group events. Most test statistics are based on looking at groups.
• Start Event Window [Integer]: This integer value defines the start of the event window. This value must smaller or equal zero (e.g. trading days before event).
• End Event Window [Integer]: This integer value defines the end of the event window. This value must greater or equal zero (e.g. trading days after event).
• End of Estimation Window [Integer]: This negative value defines the end of the estimation window (counted from event day).
• Estimation Window Length [Integer]: Length of the estimation window.

Structure of file 2)

• Firm ID [String]: The firm or stock ID. This ID must match the ID in the Firm ID in the request file.
• Date [30.04.1997]: Date of the closing price.
• Closing Price [Double]: Closing price of volume of that day.

Structure of file 3)

• Market ID [String]: The market ID or stock ID. This ID must match the ID in the Market ID in the request file.
• Date [30.04.1997]: Date of the closing price.
• Closing Price [Double]: Closing price of volume of that day.

When I upload the three respective files, the following error comes up: Duplicate Event ID: 0

My problem: I am not using any Event ID (File 1) ) which includes a 0. As a result, my analysis can not run until the end.


Does anyone has any experience with this program or could help me?

Thank you very much,
Lorenz

[Phil Bromiley]

You'll increase your chances of a useful answer by following the FAQ on asking questions - provide Stata code in code delimiters, readable Stata output, and sample data using dataex

This question does not pertain to Stata so it is no surprise you didn't get a quick answer.