Error Handling: Event Study Calculators
The research apps of this website require certain input formats, which are described on the instruction pages and exemplified through the sample files available for download on the instruction page. If your data does not match the research apps´ input requirements, the event study calculators will prompt you error messages.
As a general approach to overcome data file issues, please perform the following steps:
- Store your files as CSV files
- Open your CSV files in a text editor, such as Notepad
- Download the CSV sample files from the instructions page and open them in Notepad
- Perform a side-by-side comparison between your files and the sample files - in 98% of the cases, you will find the issue through this process
Please find in the below table guidance on several specific error messages you may find in the Analysis Report file.
| ERROR CODE | REASON(s) | MITIGATION MEASURES |
|---|---|---|
| "Wrong number of columns" |
Your files entail a column structure that differs from the required standard |
|
| "Wrong number of columns" |
You use an Apple computer that uses a different line delimiter in CSV files than regular Windows PCs - resulting in inflated column numbers |
|
| "Application error" | Your data is not consistent, e.g., IDs in your input files are not unique, you have duplicate entries |
|
| "Duplicate event id: 0" | Your file format is likely not a standard CSV file, but, for example, a UTF8 CSV file |
|