Import your brokerage trade history into TradeLog:
Note: Your specific Import Filter was selected when you created your data file in Step 1 of this Quick Start Guide.
If this needs to be changed, please click Options, Import Filter from the main menu and choose the appropriate Import filter for your broker.
IMPORTANT: Please import a full 13 months worth of data. January 1 through January 31 of the next tax year. January of next tax year trades are required for properly calculating wash sales. Do NOT import January of next tax year trades if you have elected MTM for this tax year.
Please do not import past January 31 of the next tax year as this will skew the profit/loss calculations for the current tax year.
Please do not import any closed positions from any year prior to the current tax year as this also will skew the profit/loss calculations for the current tax year.
-
Please see the lessons for importing in our Online Tutorial for a video discussion of how to use this function in TradeLog.
The Import Speed Button on the toolbar should now display the name of your broker (ex. Fidelity Imp).
For many brokers we recommend using BrokerConnect, if available. This is the easiest method of importing. Following are the basic steps for importing with BrokerConnect, the data required for connecting may vary depending on your broker:
-
Click the Import Speed Button.
-
Enter your Customer ID and PIN that you use to log into your brokerage account online. Then enter the unique account number that you wish to import from.
-
Select a date range by clicking one of the radio buttons as seen below. There will be different selections per broker.
Note: For some brokers similar to the example provided here, there will be a 90 day limit per import. Repeat steps A through C until all data has been imported.
Trades are matched by ticker description and matched for buys, sells, partial fills and short positions – even if your broker doesn't flag short sales on your reports. Our software uses "open a trade, close a trade" terminology rather than "buy" and "sell", which eliminates confusion as to whether your positions are long or short. (See:
How TradeLog Works for details.)
If you traded Options and you had contracts that were exercised or assigned, please see our instructions on how to account for this within TradeLog. (See:
Option Exercise / Assign)
If you traded Options and your broker did not record the expiring transactions be sure to use the TradeLog function to properly expire the options. (See:
Expire Options for details.)
