Home ∙ Support Center ∙ optionsXpress

optionsXpress Import Instructions

brokerConnect™ Import

General Procedure:

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

2. A popup dialog box will ask whether you want to import using brokerConnect™ or to import from the Web. Click YES to import using brokerConnect™.

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

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 staring from a specific date you can select the date from the drop down calendar.

The default import date range is Max. However, if you want to import one month at a time, select the 1 Month radio button.

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.

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 optionsXpress Imp button your information will be displayed in the box and you simply click the OK button to continue.

4. Click OK and TradeLog will connect to the optionsXpress web site to get your most current trade information.

5. All of your trades will be imported and matched.

NOTE: In order for you to be able to import via brokerConnect™ you must enable this in your optionsXpress user profile.

To do this click on the Account tab and select Profile:

Then click on the Trading & Web Site Preferences tab
and check the Site Access Via Software / XML API Enabled checkbox:

Click the Save Changes button and your account is now set up for API importing into TradeLog.

Web Import

General Procedure:

1. Go to the optionsXpress web site and click on the Accounts tab,
then click on Activity.

On your Account Activity page, you will see all transactions, including filled orders, deposits and withdrawals, money market sweeps, and dividends and interest. You can also select the time period and specify the transaction type.

2. Select the Period and Type from the drop down boxes and click GO.

Please make sure the Show Commissions & Reg. Fees** box is checked.

TradeLog only imports completed trades, so please select All Trades for the Type box.
Do not use Options Trades, or Stock Trades.
Do not click on "Download your activity" or "Quicken"

3. 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

4. Copy the report data to the Windows clipboard Edit, Copy or Ctrl-C shortcut

5. Run TradeLog

6. Click on the optionsXpress Imp speed button and click NO to import from the web.

7. If the Trades already imported warning dialog box pops up, it alerts you to the fact
that you may already have some trades imported up to the date shown.

You can either import from the next date onward, or import all of the trades copied.