|
|
Generic Trade Data Format 1
|
|
If your online broker is not in the list of supported brokers, you can create a spread sheet file (XLS)
using MS Excel or a comma delimited text file (CSV) using text editors such as NotePad, WordPad and MS Word.
|
|
|
The 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 above XLS file in MS Excel looks like the following.
|
|
|
|
The CSV 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,Short,YGE,500,31.35,9.99 |
| 10/19/2007,Cover,YGE,500,32.45,9.99 |
|
|
The above CSV file in NotePad looks like the following.
|
|
|
|
|
|
Generic Format 1