TradeStation Securities Import Instructions

TradeLog offers 3 different import methods for TradeStation Securities:

brokerConnect™ Import  |  Download File   |  Web Import of Trades & Other Transactions

NOTES:  

  1. The Tax Activity report is specifically designed for tax purposes and now includes history right up to yesterday. This is the recommended report for TradeLog.

    This report provides descriptive information on option trades such as underlying security ticker, expiration date, and strike price.  Therefore, when manually entering your open option positions from last tax year, you must enter them using the proper long-hand option format so that TradeLog can properly match them with the closing positions upon import.

    Example:  "DELL MAR06 30 CALL"

  2. The Trades & Other Transactions (obsolete) report only provides option ticker symbols, and does not provide any descriptive information about the specific option traded such as underlying security ticker, expiration date, and strike price, while the Tax Activity report provides this information.

brokerConnect - Tax Activity

General Procedure: 

1.  Run TradeLog and click on the TradeStation Imp button.

2.  A popup dialog box will ask you to select your import method.
     Select brokerConnect and click OK.

3.  A popup dialog box allows you to enter your
User Name, Password, and Account Number. 

This information gets encrypted and is stored in your TradeLog data file.  It only needs to be entered once for each brokerage account.

The next time you click the TradeStation Imp button your information will be displayed in the box and you simply click the OK button to continue.

The From date pick box shows the from date that will be used for this import. You can use the default date or if you want to import a specific day or you can select the first of the month date from the drop down calendar fro a specific month.

The To date pick box allows you to select your own end date for a custom date range import. The default date range is 3 months.

Select 1 Month to import one month at a time. 

Clicking on the Timeout button allows you to increase the time TradeLog will wait for a response. This may be necessary if you have a slow internet connection or large amounts of data.  You may also have to reduce the date range as well and import in smaller chucks.

4.  Click OK and TradeLog will connect to the TradeStation web site to get your most current trade information. TradeLog will automatically login to your account.  Please do not click any keys while TradeLog gets your data!

5.  Your trades will be automatically imported and matched.


Download File - Tax Activity

General Procedure:

  1. Login to your online TradeStation account at www.tradestation.com
     
  2. From the Account Services menu,
    select Balances, Positions, & Activity
    then select Tax Activity


     
  3. In the Trade Date section, specify the Trade Date Range you would like to download.  Please note that TradeStation restricts the downloading of trade data to a three month period per download.
     


     

  4. In the Account ID section, choose All from the Security Type drop-down menu. 
    Do not select "Equities Only" or "Options Only"
     
  5. Choose All from the Transaction Type drop-down menu.
     
  6. Select TradeLog (.csv) from the File Type drop-down menu.

  7. Click on the Download button.

    Download the report as a *.csv file (a plain text, comma separated file) and save it to your computer in the "C:\My Documents\TradeLog\Import" folder.

    You should name the file something like Q1.csv or Jan-Mar.csv, then Q2.csv or Apr-Jun.csv, etc.

    NOTE:
    If the csv file opens in your web browser rather than popping up a File Download dialog box, then there may be a problem with your Windows file associations for csv files. This may be due to the latest update for Windows XP, but we cannot be sure.

    For instructions on how to fix this click here

  8. Run TradeLog.
     
  9. Click the Tradestation Imp speed button to begin the import process.
     
  10. Click No to Import from the downloaded Tradestation *.csv file.


     
  11. A TradeStation Import window will appear.  Navigate to and select the appropriate report to be imported.

  12. Click the "Open" button to import the report.

  13. All of your trades will be automatically imported and matched.  

  14. A Confirmation window will appear.  Click YES to save all imported trade data.
     
  15. Repeat the above procedure for each quarter of the year and for January of next tax year.

Trades & Other Transactions import
(Obsolete)

NOTE:  In their Trades & Other Transaction report TradeStation Securities uses option symbols for option trades rather than option descriptions.  Therefore, when manually entering your open option positions from last tax year, you must enter them using the proper option symbol so that TradeLog can properly match them with the closing positions upon import.

General Procedure:

  1. Login to your online TradeStation account at www.tradestation.com
  2. From the Account Services menu,
    select Balances, Positions & Activity and then
    select Trades & Other Transactions.


     
  3. In the Trade Date section, specify the Trade Date Range you would like to download. 

    Please note that TradeStation restricts the downloading of trade data to a three month period per download.


     
     
  4. Choose All Transactions from the transaction Type drop-down menu. 
     
  5. Select All Symbols.  
     
  6. Select Exclude Broken/Cancelled Trades.
     
  7. Click on the View/Download button and the report will be displayed as follows:


     

  8. Use Edit, Select All. (Ctrl-A shortcut) to select the entire page.
    ... or ...
    Use your mouse to select the report table. 
    Please make sure you select the field name header line. 
    For tips on selecting a report table with your mouse see:
    Selecting a report table with your mouse       
     

  9. Copy the report data using your web browsers Edit, Copy command:
    (Right-click, Copy or Ctrl-C keyboard shortcut)
     
  10. Run TradeLog.
     
  11. Click the Tradestation Imp speed button to begin the import process.
     
  12. Click Yes to Import from web


     
  13. All of your trades will be automatically imported and matched.  
     
  14. If your transactions span more than one page, click the Next button to display the next page and repeat steps 9 through 16.