TD Ameritrade Import Instructions

NOTES: In their trade history reports TD Ameritrade and Freetrade use 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.

Dividend Reinvestments - Please import from the downloadable CSV file if you have dividend reinvestments as the Transaction History report is missing important information on these types of transactions.

TD Ameritrade Website

There are now 3 different methods of importing transaction history from TDAmeritrade into TradeLog:

brokerConnect™ Import of CSV file - recommended import.
Web Import of Transaction History - includes time of day - not recommended for dividend reinvestments.
CSV File download - does not include time of day.

Ameritrade brokerConnect Import of CSV file.

General Procedure:

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

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

Please note that this dialog box will only popup if you selected "Select each time" as your default import method from Options, Import Filters. You can make brokerConnect your default import method to save one keystroke when importing.

3. A popup dialog box allows you to enter your User Name and Password.
Note: This will only work for those accounts where your user name and password logs you in to one specific account and does not alow you to switch accounts after you are logged in.

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 maximum date range is 12 months.

If you are a really active trader, please 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.

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

Ameritrade Transaction History Import

NOTE: Please do NOT use if you have Dividend Reinvestments as this report does not provide enough information on this type of transaction.

Sample Online Transaction History Report:

General Procedure:

1. Log on to your Ameritrade trading account web site and click on Portfolio & Accounts
and then click on History & Statements.

2. Select a date range for the report and click the View button.

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 Ameritrade Imp speed button.

7. Click YES after the following popup dialog box appears

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

IMPORTANT NOTES:

Ameritrade limits the number of transactions per page to 200, therefore you must select and copy one page at a time till all of your trades have been imported. If you have more than a few pages to import, we suggest you switch to the CSV file import.
It has been noticed that the last trade transaction on a page is sometimes duplicated on the top of the next page, resulting in mismatched trade in TradeLog due to these duplicate entries. Please review the last trade on each page and the first trade on the next page to see if this is the case.

After importing you may use the TradeLog Find, Duplicate Trades function to locate these to delete one of them.

Ameritrade downloaded CSV file Import

General Procedure:

1. Log on to your Ameritrade trading account web site and click on Portfolio & Accounts
and then click on History & Statements.

2. Select a date range for the report and click the Download button.

3. Please wait until a File Download box pops up.

Click the Save button (DO NOT click the open button)

4. A Windows Save As dialog box allows you to select where on your hard drive
you are going to save this file.

     Please select your "my documents\tradelog\import" folder
     (or whatever folder you are using as your data file folder
       - there should be an import folder under this folder)

Click the Save button to save the CSV file to your hard drive.

5. Run TradeLog

6. Click on the Ameritrade Imp speed button

7. Click NO after the following popup dialog box appears

8. Select the CSV file you just saved from the next popup dialog box and
click the Open button

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

Freetrade and OLD Ameritrade web site

General Procedure:

Log on to your Ameritrade trading account web site and Click on the myAccount Tab.
Click on Account Details - Transactions.
Select a date range for the report and click the View Transactions button
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
Copy the report data to the Windows clipboard Edit, Copy or Ctrl-C shortcut
Run TradeLog
Click on the Ameritrade Imp speed button and the trades will be automatically imported and matched.

Ameritrade cancelled and corrected trades:

The old Ameritrade Account Details - Transactions report used an an unusual method to indicate cancelled or corrected trades in their trade history report that makes matching and deleting them automatically upon import impossible. We are still waiting to see how the new Account History will handle cancelled and corrected trades.

Cancelled or corrected trades are indicated as follows:

A buy transaction with a positive amount - a buy transaction is usually negative.
A sell transaction with a negative amount - a sell transaction is usually negative.

Example:

06-02-2003 1176161105 Buy or Sell Security BUY 2650.000 SHARES MPOW @ 0.825 2197.24

- Notice that the amount 2197.24 is positive rather than negative!

06-02-2003 Buy or Sell Security SELL 100.000 SHARES COST @ 37.301 -3718.93

- Notice that the amount -3718.93 is negative rather than positive!

Please note that absolutely no other indication is given as to what these transactions really mean! Sometimes these transactions are canceling a previous buy or sell transaction, and both should be deleted before import. In other cases these are corrected trades and should be imported.

No automated set of rules exists to filter these out, so we leave the decision making process up to the user by flagging these transactions with an "X" in the TradeLog open/close column.

You must then decide the following for each transaction marked with an X:

If this transaction is canceling other buy or sell transaction and therefore both the trade marked with an X as well as the matching trade should be deleted.
Or whether this transaction has no match and should simply be deleted.
Or whether this is a corrections trade and should be imported as a valid buy or sell. If so you should change the X in the open/close column to an O or C.
Or whether this is a valid sale transaction where the price is so low that the commission causes the amount to be negative rather than positive. If so you should change the X in the open/close column to an O or C.

PLEASE NOTE: We have found no other way to deal with these. Please complain to Ameritrade to look into this and make their trade history report more user friendly!