Importing Trades From Your Broker: CSV Exports Without the Headaches
How to export trades from your broker, which report to choose, common CSV problems with dates, symbols and time zones, and how to check an import is complete.
A guide to the main sections of a brokerage statement, what each line means, how to spot fees and corporate actions, and how to reconcile your statement with your journal.
Broker statements are dense, and every broker formats them differently. But most contain the same building blocks. Knowing where to look helps you verify your trades, spot fees and keep your journal accurate.
Opening and closing account value, deposits and withdrawals, and the change in value for the period. Remember that the change in value includes deposits, so it is not the same as your trading result. See cash flow in a trading account.
Open positions at the end of the period: quantity, cost basis, market value and unrealized gain or loss. For options, check the expiration dates; for futures, the contract months.
Every execution: date, time, symbol, side, quantity, price, commission and fees. This is the section your journal imports.
Dividends, interest, fees, margin interest, transfers and, where relevant, financing charges and funding payments.
Some statements, and the year-end tax forms, show realized gains and losses by lot, with short-term and long-term separated and wash sale adjustments noted. See the wash sale rule.
Once a month:
Differences usually mean a missing import, a fee not attached to a trade, or a corporate action.
When you import from your broker, TradeThink reads trades, fees and cash movements, groups executions into trades and shows deposits, withdrawals, dividends and fees on the transactions page. The import guides list which report to download from each broker. Related: importing trades from CSV.
How to export trades from your broker, which report to choose, common CSV problems with dates, symbols and time zones, and how to check an import is complete.
How the old US pattern day trader rule and $25,000 minimum worked, what FINRA's new intraday margin standards change from June 2026, and what still applies.
How compounding works in a trading account, why small consistent returns grow large over time, why drawdowns hurt compounding, and how to set realistic expectations.