ⓘ Disclaimer

This page may contain affiliate links. We may earn a commission if you make a purchase through these links. Nothing on this website should be construed as financial advice. Learn more.

Interactive Brokers Trading Journal: Auto Sync or Free Flex Query Import

ⓘ Disclaimer

This page may contain affiliate links. We may earn a commission if you make a purchase through these links. Nothing on this website should be construed as financial advice. Learn more.

Looking for an Interactive Brokers trading journal? The Financial Tech Wiz Trading Journal syncs IBKR stock, ETF and options trades automatically with Broker Auto Sync, a paid feature ($19 a month or $119 a year). Free accounts import IBKR trades with a Flex Query instead, with unlimited trades.

Journal your IBKR trades

Create a free account

Financial Tech Wiz Trading Journal

Import IBKR trades with Flex Query for free, then see win rate and P&L by symbol, hold time and time of day.

Free account, no card. Paid adds Broker Auto Sync, the AI Trading Coach and today’s scan results.

Key Takeaways

  • Free: export your Interactive Brokers trades as a CSV and upload it under Import & Sync Trades, Import a file, Interactive Brokers. Paid: Broker Auto Sync connects Interactive Brokers once and brings in new trades every morning.
  • Choose the journal destinations for each broker account. Broker Auto Sync brings in the 2 years before you connect; older years come from Flex Query files under Add older history (CSV).
  • On the free account you can also import through the IBKR Flex Web Service with your Flex token and query ID, or upload a Flex Query CSV.

How to export your Interactive Brokers trades as a CSV

Follow these steps in Interactive Brokers to download a file the journal can read. Menu names can shift when Interactive Brokers updates its site, so if a label differs, look for the trade or transaction history export.

  1. Sign in to the IBKR Client Portal and open Performance & Reports, then Flex Queries (or Menu, Reporting, Flex Queries).
  2. Click the + beside Activity Flex Query and give the query a name.
  3. In Sections, open Trades, choose Executions and tick Select All so the file has Symbol, Date/Time, Buy/Sell, Quantity, Trade Price, Commission, Asset Category, Strike, Expiry and Multiplier. Save the section.
  4. In Delivery Configuration set Format to CSV, then click Continue and Create.
  5. Back on the Flex Queries page, click the Run arrow next to your query, set Period to a custom date range, keep the format as CSV and click Run. Download the file.

Or skip the file with the Flex Web Service (free)

  1. On the same Flex Queries page in IBKR, open Flex Web Service Configuration, turn the service on and copy the token. Copy your query’s ID from the Flex Queries list too.
  2. In the journal’s Interactive Brokers importer, choose Connect via API, paste the Flex Web Service Token and the Flex Query ID, and save them if you want later imports to reuse them.
  3. Click Fetch Trades from IBKR, check the preview and import. Each fetch runs when you click it; it does not run on a schedule.

Which dates and file type to choose

Date range: IBKR limits a Flex run to about a year, so run one file per year with dates that do not overlap. File type: CSV. Choose Executions in the Trades section; the Symbol Summary, Orders and Closed Lots levels are not fill by fill.

Common mistakes

  • Uploading the default Activity Statement (the formatted report) instead of a Flex Query CSV.
  • Leaving out Buy/Sell, Trade Price or Asset Category, which makes options and side detection fail.
  • Running overlapping date ranges, which brings the same fills in twice.
  • Opening the CSV in a spreadsheet and saving it again before you upload. That can change dates and number formats; upload the file exactly as downloaded.

Import it into the Financial Tech Wiz Trading Journal

File imports work on the free account, with no card. Here is the exact path in the journal:

  1. Sign in to the journal and pick the journal these trades belong in from the top bar. If the top bar shows All Accounts, the import window asks which one to use.
  2. Open Import & Sync Trades from the menu (or click Import trades on the Trades page) and stay on the Import a file tab.
  3. Pick Interactive Brokers from the broker grid. The import window opens on Upload CSV; Connect via API is the free Flex Web Service option described above.
  4. Drop the CSV into the upload box, or click the box to browse for it.
  5. Check the preview: Matched Trades (buys paired with sells), Open Positions (buys or sells without a match yet) and any rows marked as errors. Turn on Include open positions if you also want positions that are still open.
  6. Click Import (the button shows how many trades it will add).
Financial Tech Wiz Trading Journal import window with the Interactive Brokers Flex Query setup steps: create a Trade Confirmation Flex Query, turn on Flex Web Service, copy the token and query ID
Connect via API uses a Flex Query ID and token, also on the free account; the import window lists each step.

Rows that are not trades, such as deposits, dividends and interest, are skipped and counted in the preview, and nothing is saved until you click Import. For newer trades later, export only the dates since your last file and import it the same way; if two files overlap, search Trades for the same symbol and date first. If the journal picked in the top bar is a verified broker account, only Auto sync can add its trades, so pick another journal for file imports; trades from before Interactive Brokers’ synced history starts go into that account through Add older history (CSV), described below.

Already a member? Open Import & Sync Trades.

Broker Auto Sync (paid)

Broker Auto Sync is the hands-off option: connect Interactive Brokers once and new trades come in on their own. It is on the paid plan ($19 a month or $119 a year); the CSV import above stays free.

  1. Open Import & Sync Trades from the menu and choose the Auto sync tab.
  2. Click Connect a broker (Connect your first broker the first time) and choose Interactive Brokers.
  3. The connection window asks for an Interactive Brokers Flex Query ID and token; follow its prompts to create them in IBKR’s Performance & Reports area and paste them in. The connection is read-only: the journal cannot place, change or cancel orders.
  4. Optional, once an account is linked: set Sync trades from on its journal link to leave older trades out of that journal (they are hidden, not deleted). Leave it empty to bring in everything Interactive Brokers sends, which is the 2 years before you connect.
  5. Link each Interactive Brokers account to a journal: tap a journal under the account, use Give each its own journal, or pick two or more accounts and choose Create and import for a combined journal.
  6. Leave the sync icon on for automatic updates, or turn it off on a link for a one-time import.

After that, a full refresh runs every morning before the market opens, and new activity can arrive sooner when Interactive Brokers reports it. Use Sync now or Sync all to ask for an update at any time; broker processing can delay new fills. With auto sync on, unlinking the account or disconnecting the broker removes that account’s synced trades from the journal, so turn auto sync off on the link first if you want to keep them.

Trades older than Interactive Brokers’ 2 years

Interactive Brokers sends the 2 years of trades before the day you connect, and that start date does not move. See how far back each broker’s history goes. To bring in older trades:

  1. Download your older Interactive Brokers history as a CSV with the steps above.
  2. On the Auto sync tab, under the linked Interactive Brokers account, press Add older history (CSV). Interactive Brokers is already picked as the broker the file comes from. Use a Flex Query trades CSV (one per year, as above) or an Activity statement CSV; each file can be up to 8 MB. Choose the file and press Preview.
  3. The preview shows how many fills from before Interactive Brokers’ history starts will be added and how many it leaves out because Interactive Brokers already sends them. Nothing is saved until you press Save.

From the day Interactive Brokers’ history starts, Interactive Brokers’ own data is used, so nothing counts twice, and later Interactive Brokers sales close the shares bought in your file first. If you upload another file later, rows already saved from an earlier file are left out, so only new rows are added. You can delete a file at any time.

No file? Under Held at your broker before its history starts, add those shares in one click. The suggested price makes your journal’s cost basis match Interactive Brokers’, so your profit and loss match too.

Once saved, older trades stay in your journal even after Interactive Brokers’ 2-year window moves forward. Each sync keeps your notes, tags, stops and reviews on the trades it updates. Trades come only from executions Interactive Brokers reports; holdings never create trades. An open trade’s chart marks each buy Interactive Brokers reported and can reach back years.

Manual entry and every file import are part of the free account. For the rest of the app, from journals to analytics, see the complete journal setup guide. The trade logging guide covers manual entries and file imports step by step.

How automatic and one-time imports work

New broker links default to automatic sync. The sync icon beside a journal link turns automatic updates off or on for that destination. With automatic sync enabled, the journal requests updates each morning before the market opens. New activity can also arrive sooner when your broker reports it, and broker processing can delay new fills.

Use Sync now for one broker account or Sync all to request a refresh across linked accounts. These controls ask the broker connection to return available data; they do not guarantee that a broker has already delivered every latest transaction.

To make a one-time import, turn automatic sync off for the relevant journal link. Imported trades remain in place and you can still request a manual sync. Before unlinking an account, check its setting: unlinking or disconnecting the broker with automatic sync on removes the trades that account brought into that journal, while trades remain when automatic sync is off.

Sync trades from on a journal link is optional; trades opened before it stay out of that journal, hidden rather than deleted, until you move the date earlier. For normal updates, use Sync now or the scheduled sync. You do not need to clear all journal trades first.

Check these details if trades are missing

  • Confirm the broker connection is active. If it shows Needs reconnect, use Reconnect, then request a sync.
  • Check that the correct Interactive Brokers account is linked to the journal you are viewing. A connection does not automatically route every account to the same journal.
  • Confirm the broker has made the activity available to its connected feed and that the trade is within the 2 years before you connected. Older trades come in through Add older history (CSV).
  • Check the asset type. Treasury bills and bonds are skipped, and Broker Auto Sync does not currently import futures.
  • Before trying another import path, search for the symbol and trade date so you do not create a duplicate record.

If the account is linked correctly and the trade is available at the broker but still does not appear, save the sync result and contact support with the broker name, journal destination, and trade date. Do not send brokerage passwords or account statements with unneeded personal details.

Keep a note of the last successful refresh date so you can distinguish a broker-feed delay from a journal destination or file-format issue.

What to expect from imported Interactive Brokers activity

The broker connection can import activity available through the connected Interactive Brokers account’s feed. Broker Auto Sync imports stocks, ETFs, options (including expirations, assignments and exercises), crypto and forex as the broker reports them. Interactive Brokers sends the 2 years before you connect, and the journal cannot guarantee every asset offered by Interactive Brokers. Treasury bills and bonds are skipped by the current broker importer.

Broker Auto Sync does not currently import futures, even though Interactive Brokers offers them. Futures come in through file imports instead, such as the IBKR Flex Query CSV or Flex Web Service import, or through manual entry. Charts, trade replay and MAE/MFE are not available for futures.

Compatible multi-leg options fills can be grouped when the broker supplies a usable shared order reference and the legs match the supported structure. Fills without a usable common reference or compatible structure fall back to individual matching. Review imported option trades before relying on their grouping, and avoid overlapping manual entries for fills already synced.

For option positions, the journal can show win rate and P&L across your options positions, broken down by symbol and hold duration. Analytics summarize recorded trades; tags and notes are searchable in Trades but do not filter aggregate Analytics results. The best trading journals comparison can help you compare workflows and analysis tools.

You can also review the equity curve and P&L graphs, compare recorded trade outcomes across periods, and, on a paid plan, use the AI Trading Coach to ask questions about your journal’s trades and statistics. These views depend on the records and prices available in the journal. They are analysis aids, not a reconciliation of every Interactive Brokers account movement.

Review performance without assuming an exact broker balance

Automated Portfolio Performance estimates a curve from logged trades and available prices, subject to market-data coverage and cash-flow assumptions. Recording a starting balance and cash flows can make the estimate closer to your account history. You do not need to enter a daily balance for this curve.

Manual Portfolio Performance uses separately recorded net liquidity. It is useful when you want to compare balances you entered over time. These methods answer different questions, and neither promises an exact reconstruction of your Interactive Brokers statement. Learn how to log and review your trades before comparing performance across periods.

Review your IBKR results

Financial Tech Wiz Trading Journal

Keep Flex imports, manual trades and notes in one journal, then review your results by symbol and hold time.

Start free

Free account, no card. Paid adds Broker Auto Sync, the AI Trading Coach and today’s scan results.

What the Free Account and Paid Plans Include

The free account covers manual entry, CSV imports, R multiples, the journal analytics, delayed final scan results and the equity curves of our backtested trend following and mean reversion strategies. Free journals can join the leaderboard after 30 closed trades over 60 days, and free accounts can connect their own journal to Claude or ChatGPT through the MCP server. Paid plans add Broker Auto Sync, the AI Trading Coach, today’s live and intraday scan results for every scanner, the full Official Breakout, Official Dip and Official Combo backtests, and the full API and MCP tool set, including scanner and system data. The Daily Pivot Breakout Scanner has scan history back to 2000; each other scanner’s free page states when its own history starts. The free scanner pages are five trading sessions delayed. Results on historical data are hypothetical and do not guarantee future returns.

Still weighing your options? Compare all trading journals side by side on price, broker sync and analytics, with prices checked November 2026.

Frequently Asked Questions

How do I connect Interactive Brokers to a trading journal?

On the free account, upload a Flex Query CSV or fetch trades through the IBKR Flex Web Service under Import & Sync Trades, Import a file, Interactive Brokers. On the paid plan, open Import & Sync Trades, choose the Auto sync tab, then Connect a broker and Interactive Brokers, paste the Flex Query ID and token the connection window asks for, and link each broker account to its intended journal.

Does the Interactive Brokers connection keep syncing trades?

New broker links default to automatic sync. The journal requests available updates each morning before the market opens. You can turn automatic sync off for an individual journal link and use Sync now or Sync all to request a refresh when needed.

Will the journal import my complete IBKR history?

Broker Auto Sync brings in the 2 years before you connect. For older years, run one Flex Query file per year (Interactive Brokers limits a run to about a year) and upload them under Add older history (CSV); Interactive Brokers’ own data takes over from where its 2 years start. This is not a guarantee of every asset in the account.

Can I import an IBKR Flex Query file?

Yes. Upload a Flex Query CSV with the Interactive Brokers importer, or save your Flex Web Service token and query ID to import directly. Both work on the free account; Broker Auto Sync is the paid option for automatic daily updates.

Financial Tech Wiz / Free resources

Build a clearer picture of your trading.

Start with a free journal account. Keep your trades organized, review your results, and build a consistent review routine.

Your free journal account includes the template and tools by email:

  • Free Google Sheets and Excel trading journal template
  • Indicators, watchlists, and scanners
  • Access to the free trading community

Ready for automatic trade tracking? Explore the Financial Tech Wiz Trading Journal.

Free journal. No card needed.

Related Resources

  • stock rover review
    Stock Rover Review 2026: Features, Pricing, Pros and Cons
  • tradervue review
    Tradervue Review 2026: Pricing, Free Plan and Verdict
  • trade ideas dashboard
    Trade Ideas Review 2026: Holly AI, Money Machine, Pricing
  • tradingview review
    TradingView Review (2026): Is It Worth It?
  • trendspider review image
    TrendSpider Review (2026): Pros, Cons and Who It Is For
  • optionomegareviewthumbnail
    Option Omega Review 2026: Backtest, Automate, Pricing
  • best options backtesting software
    Best Options Backtesting Software
  • tradingview vs trendspider comparison
    TrendSpider vs TradingView (2026): Which Charting Platform Is Better?