Washems! Input File Format
 

Please remember:  The file should contain one entry per line and have a comma between each of the fields. To accomplish this, the Excel entries should be saved as a ‘comma delimited file’ otherwise known as a ‘csv’ file.

There should be no imbedded commas, double quotes, single quotes or decimal points in any of the fields.

All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. example: 02/04/04 or 02/04/2004 NOT 2/2/04

1. Required fields:
   1. Security (stock) name - up to 50 characters long with no imbedded commas;
   2. Merger Date - mm/dd/yy or mm/dd/yyyy or blank;
   3. Option or Stock - "Call", "Put", or blank for stock;
   4. Option expiration month - 2 numeric positions, 01 through 12 - or blank for stock;.
   5. Option strike price - Do not use decimal points; eg., 42 1/2 not 42.5 - or blank for stock;
   6. Date Acquired - in the format mm/dd/yy or mm/dd/yyyy;
   7. Date Sold - in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank (spaces);
   8. Number of shares/lots - maximum of 9 digits (999999999) no commas;
   9. Cost - maximum of 9 digits (999999999) no commas;
   10. Proceeds - maximum of 9 digits (999999999) no commas - or blank if the lot is still open;;
   11. Gain or Loss - maximum value 999999999 without decimals and commas - or blank if the lot is still open.

1. Errors:
   1. Security's Name: Contains a comma (',') within the name.
   2. Invalid Merger Date - month must have 2 digits.
   3. Type of Transaction: 'CALL' should not be within quotes (").
   4. Option Strike Price: Don't use the decimal, use '1/2' instead.
   5. Close Date: Use '/' instead of '-' as the delimiter.
   6. Number of Lots/Shares: '(100)' should be '-100'.
   7. Cost: Leave out the decimal and the cents.
   8. Proceeds: Use whole dollars and no decimals or cents.
   9. Gain/Loss: Show negative number as '-201' (rounded).

Once 5 or more errors have been found in the file, the program ends. At this point, please review your input file and correct all errors before attempting to recalculate.