Generic Format - Transaction History

If your online broker is not in the list of supported brokers, you can create a spreadsheet file (XLS) using MS Excel or a Comma Delimited text file (CSV) using text editors such as NotePad, WordPad and MS Word. The CSV or XLS file must be in the format shown below.

Date,Action,Symbol,Quantity,Price,Commission
09/05/2007,Buy,BX,200,22.17,12.99
09/11/2007,Sell,BX,200,22.87,12.99
10/18/2007,Sell Short,YGE,500,31.35,9.99
10/19/2007,Buy to Cover,YGE,500,32.45,9.99

The CSV file in NotePad looks like the following.

The XLS file in MS Excel looks like the following. After entering all your trades, please save it as a Comma Delimited (*.csv) file.