Comma Delimited Customized Conversion

Comma Delimited (CSV) Customized Conversion is a built-in feature of iScheduleD Portfolio Manager and TXF Creator, which can handle stock and option trade data from many different brokers. If your broker is not directly supported by TXF Express, this feature is right for you. The Comma Delimited feature processes 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 or other spreadsheet applications. Please note that TXF Online does not support the Comma Delimited Customized Conversion.

Transactions

If you have a history of transactions including Buy, Sell, Shell Short, Buy to Cover, Buy to Open, Sell to Close, 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
11/11/2007,Buy to Open,.AXZ,10,2.45,9.95
12/09/2007,Sell to Close,.AXZ,10,3.15,9.95

 

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.

Choose CSV file and tax year

 

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.

Choose proper column indexes

 

Step 3: Verify your capital gain/loss. Click on the Continue >> button.

Verify short/long term capital gains and losses

 

Step 4: View your working history.

View TXF Creator 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
.AXZ,10,11/11/2007,2459.95,12/09/2007,3140.05,680.10

 

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.

Choose CSV file and broker

 

Step 2: Choose Realized Gain/Loss from the drop down menu on the top-left cornor.

Choose Realized Gain/Loss

 

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.

Enter proper column indexes

 

Step 4: Verify your capital gain/loss. Click on the Continue >> button.

Verify capital gains and losses

 

Step 5: View your working history.

View TXF Creator working history