Stock Portfolio Tracker logoStock Portfolio Tracker logo

How to download your stock transactions from Interactive Brokers

Having access to your full trading history is crucial for analyzing your portfolio, tracking dividends, and making informed decisions. Interactive Brokers allows you to download your trade data so you can review your investments in detail. Once downloaded, you can easily import your trades into Stock Portfolio Tracker to monitor your portfolio, track performance, and gain insights across all your investments.

Why you should download your stock trading data

- Understand performance: Track which trades generate the most profit.
- Monitor dividends: Keep an accurate record of income-generating assets.
- Plan your portfolio: Spot trends and rebalance accordingly.
- Maintain records: Essential for personal finance tracking or tax purposes.

Steps to download your Interactive Brokers stock trades

Follow the steps below to download your transaction history:

  1. Login to your Interactive Brokers account
  2. Click on the Reports tab and select Flex Queries
  3. Click '+' next to Activity Flex Query
  4. Select Trades under Sections
  5. Select Executions on the pop up window
  6. Tick SELECT ALL and click Save
  7. Enter a Query Name
  8. Change Date Format to mm/dd/yyyy under General Configuration
  9. Click Create
  10. Run the Activity Flex Query
  11. Under Period, select Custom Date Range to cover all trades
  12. Set Format as CSV, click Run and download your trades
  13. Upload your file below. (You will be able to review the import before it is saved.)

Pro Tip: If your broker has multiple account types (e.g., standard, retirement, or ISA), export each separately to avoid mixing data.

Things to keep in mind

- Date range limitations: Some brokers restrict how far back you can export. Multiple exports may be needed for long histories.
- File formats: CSV is best for analysis; PDF can serve for record-keeping.
- Data verification: Ensure no transactions are missing and all dates are correct.
- File organization: Use clear names like Interactive Brokers_trades_YYYY-MM-DD.csv for easy access.

Using your exported data

Once you have your Interactive Brokers trading history: - Analyze performance trends across stocks, ETFs, crypto, funds, and more. - Track dividend income over time. - Evaluate portfolio allocation and risk exposure. - Keep a personal record for taxes or audits.

Tips for smooth exporting

- Export smaller date ranges first to avoid timeouts.
- Do it outside market hours for faster download speeds.
- Maintain backups of your files in secure storage.