Stock & Option Transactions in Comma Delimited Format
You can prepare stock & option transactions in Comma Delimited Format (CSV) using Excel or text editors.
A sample file is shown below for your reference.
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,1500,31.35,9.99
10/19/2007,Buy to Cover,YGE,1500,32.45,9.99
11/02/2007,Buy to Open,AAZ DEC07 Call,2,1.25,9.99
11/22/2007,Sell to Close,AAZ DEC07 Call,2,1.65,9.99
The Action code must be one of the following:
- Buy
- Sell
- Sell Short
- Buy to Cover
- Buy to Open
- Sell to Close
- Sell to Open
- Buy to Close