Comma Delimited (CSV)
|
|
Comma Delimited is a built-in feature of TXF Creator, which can handle trade data from many different online brokers.
If your broker is not directly supported by TXF Express, this feature is right for you. The Comma Delimited feature
handles two types of trade data:
If you have downloaded an Excel file (XLS) from your broker, you need to convert it to Comma Delimited (CSV) using Microsoft Excel.
|
|
Note that the Comma Delimited feature is not available for TXF Online.
|
|
Transactions
If you have a history of transactions including Buy, Sell, Shell Short, Buy to Cover, Buy to Open, Sell to Closs, Sell to Open, and Buy to Close, your trade data may look like the following.
|
| 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 |
|
|
Step 1: Choose Comma Delimited (*.csv) as your broker in TXF Creator.
After choosing your data file and tax year, click on the Continue >> button.
|
|
|
|
|
Step 2: Choose column indexes. The column indexes have a purple background. For the given sample,
choose 1 for column Date, 2 for column Action, 3 for column Symbol,
4 for column Quantity, 5 for column Price, 6 for column Commission.
Click on the Continue >> button.
|
|
|
|
|
Step 3: Verify your capital gain/loss.
Click on the Continue >> button.
|
|
|
|
|
Step 4: View your working history.
|
|
|
|
|
Realized Gain/Loss
If you have a history of realized gains and losses (e.g., Cost Basis and Proceeds), your trade data may look like the following.
|
| 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 |
|
|
Step 1: Choose Comma Delimited (*.csv) as your broker in TXF Creator.
After choosing your data file and tax year, click on the Continue >> button.
|
|
|
|
|
Step 2: Choose Realized Gain/Loss from the drop down menu on the top-left cornor.
|
|
|
|
|
Step 3: Choose column indexes. The column indexes have a purple background. For the given sample,
choose 1 for column Symbol, 2 for column Quantity, 3 for column Date Acquired,
4 for column Cost Basis, 5 for column Date Sold, 6 for column Proceeds.
Click on the Continue >> button.
|
|
|
|
|
Step 4: Verify your capital gain/loss.
Click on the Continue >> button.
|
|
|
|
|
Step 5: View your working history.
|
|
|
|
Comma Delimited