|
|
Generic Trade Data Format 2
|
|
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.
|
| Symbol |
Quantity |
Date Acquired |
Cost |
Date Sold |
Proceeds |
Gain |
| BX |
200 |
09/05/2007 |
4446.99 |
09/11/2007 |
4561.01 |
114.02 |
| YGE |
500 |
10/18/2007 |
15665.01 |
10/19/2007 |
16234.99 |
-569.98 |
|
|
The above XLS file in MS Excel looks like the following.
|
|
|
|
The CSV file must be in the format shown below.
|
| Symbol,Quantity,Date Acquired,Cost,Date Sold,Proceeds,Gain |
| BX,200,09/05/2007,4446.99,09/11/2007,4561.01,114.02 |
| YGE,500,10/18/2007,15665.01,10/19/2007,16234.99,-569.98 |
|
|
The above CSV file in NotePad looks like the following.
|
|
|
|
|
|
Generic Format 2