You are here

Error Handling: Event Study Calculators

If your data does not match the research apps´ input requirements, the event study calculators will prompt you error messages. Please find guidance on how to overcome these issues In the below table. Alternatively, if you remain to have challenges in compiling functional firm and market data files for our abnormal return calculators, consider using our data file compilation service. It will save you plenty of time and its revenues allow us to evolve this website.

ERROR CODE REASON(s) MITIGATION MEASURES
"Wrong number of columns"

Your files entail a column structure that differs from the required standard
  • Open CSV in a text editor and search for spare semicolons at the end of each line
  • Discard those semicolons/column delimiters
"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
  • Upload your data in XLS or XLSX format
  • Use a Windows PC to save CSV files
"Application error" Your data is not consistent, e.g., IDs in your input files are not unique, you have duplicate entries
  • Review your data and fix inconsistencies
"Duplicate event id: 0" Your file format is likely not a standard CSV file, but, for example, a UTF8 CSV file
  • Transform your CSV file into a standard CSV file (i.e., store as file type "CSV (MS-DOS)" in Excel)
  • Alternatively, store and upload your data in XLS or XLSX format