The Ultimate IBKR Trading Journal: Sync & Analyze Your Trades Automatically

Sync your Interactive Brokers account or upload your Flex Query export. TradeBB maps your stocks, options, futures, and forex trades into a structured performance journal so you can see which strategies, instruments, and sessions drive your P&L.

Interactive Brokers uses a highly secure system called "Flex Queries" to share data. Setting up your Interactive Brokers trading journal requires a quick, one-time configuration. Once completed, TradeBB will securely parse your complex options and multi-asset trades automatically.

Follow this step-by-step guide to retrieve your Flex Query ID and Flex Token to complete the integration.

Step 1: Access Flex Queries

1. Log in to your account on the official Interactive Brokers website.
2. In the top navigation bar, click on Performance & Reports.
3. Select Flex Queries from the menu.

Step 2: Create a New Trade Query

1. On the Flex Queries tab, locate the Active Flex Queries section.
2. Click the + (Plus) icon on the right side to create a new query.
3. Name your query: Give it a recognizable name (e.g., "TradeBB Journal").
4. Under "Select Sections," choose Trades.

Step 3: Configure Trades Data

1. A "Trades" configuration window will pop up.
2. Select Executions from the options.
3. Check the box for Select All to ensure all necessary data points are captured for your trading journal.
4. Scroll to the bottom and click Save.

Pro Tip: Make sure to check Select All under Executions.  This ensures TradeBB receives the critical commission and fee data needed to calculate your exact Net PnL

Step 4: Delivery Settings & History

1. Format: Under "Delivery Configuration," change the format to CSV and ensure "Include Header/Column Names" is checked.
2. Time Period: Set the period to Last 365 Days.
3. Click Continue.

Step 5: Finalize and Create

1. You will be taken to the "Review Your Activity Flex Query" page.
2. Review your settings, scroll to the bottom, and click Create.
3. You should see a confirmation message: "Create an Activity Flex Query - Complete."
4. Click OK.

Step 6: Get Your Query ID

1. Return to the Flex Queries tab.
2. Find the query name you just created.
3. Click the icon (indicated by the red arrow) next to your query.
4. Copy the Query ID.

Step 7: Get Your Flex Token

1. On the same page, click on Flex Web Service Configuration.
2. Follow the prompt to generate/view your token.
3. Copy the Current Token(Flex Token). (Remember, this is the long string).

Important Note: Interactive Brokers often delays new Flex Tokens by up to 24 hours. If your Auto-Sync doesn't pull data immediately, don't worry—this is a broker limitation. For instant access to today's trades, use the File Import method below.

Step 8: Connect to TradeBB

Need to review today's setups immediately? Uploading a CSV is the fastest way to update your Interactive Brokers trading journal. Configure your export settings once, and generate your report anytime.

Follow this guide to configure your export settings and upload your data to TradeBB.

Step 1: Access Flex Queries

1. Log in to the Interactive Brokers website.
2. Navigate to Performance & Reports > Flex Queries.
3. Locate the Trade Confirmation Flex Query section and click the + (Plus) icon.

Step 2: Configure the Query

1. Query Name: Enter a name (e.g.,    TradeBB-Import).
2. Under "Select Sections," click on Trade Confirmation.
3. In the popup window, select Executions and check Select All.
4. Scroll down and click Save.

Step 3: Set Format

1. Format: Ensure CSV is selected.
2. Date/Time Format: Match the settings shown in the screenshot (standard format recommended).
3. Click Continue.

Step 4: Finalize

1. Review your settings on the summary page.
2. Scroll to the bottom and click Create.
3. Once you see the "Complete" status, click Ok.

Step 5:Exporting Your Data

Whenever you want to update your trading journal:

1. Go back to the Flex Queries page in IBKR.
2. Locate your saved query (TradeBB-Import).
3. Click the Run icon (Arrow) next to the query name.
4. The CSV file will automatically download to your computer.

Step 6:Upload to TradeBB

1. Upload the CSV file you just downloaded from IBKR.
2. Done! TradeBB will instantly analyze your new trade data.

Upload the CSV to TradeBB. Our engine will instantly clean the raw data, and generate your updated equity curve.

Interactive Brokers gives you access to virtually every tradable market on the planet. Stocks, ETFs, options, futures, forex, bonds, funds — all from a single account with some of the lowest commissions in the industry.  That breadth is exactly what makes IBKR the platform of choice for serious, multi-asset traders.

But breadth creates complexity. And complexity makes it harder to see what is actually working.

TradeBB takes the trade data IBKR already records and organizes it into the kind of structured performance analysis that answers the questions IBKR's own reporting tools were never designed to answer.

Setup-level performance tracking

Every trader has repeating patterns. Maybe you sell premium on SPY weeklies, buy breakouts on momentum stocks, trade crude oil futures around inventory reports, or run iron condors on high-IV names. TradeBB lets you tag each trade with the setup that triggered it. Over time, the platform calculates win rate, average R-multiple, expectancy, and total P&L for each setup type.

Drawdown and risk management metrics

TradeBB calculates maximum drawdown, profit factor, average winner vs. average loser, consecutive loss streaks, and drawdown recovery time. When you trade multiple asset classes with different volatility profiles and margin requirements, understanding your aggregate drawdown behavior is critical. TradeBB shows you how deep your drawdowns go, how long they last, which asset classes contribute most to drawdown, and which behaviors trigger them.

Options strategy analysis

IBKR supports a full range of multi-leg option strategies — verticals, iron condors, strangles, calendars, butterflies, and more. 4 5 6 TradeBB lets you tag and group these strategies so you can compare performance across strategy types. See whether your credit spreads outperform your debit spreads, whether your iron condors on indices produce better risk-adjusted returns than single-name strangles, and whether your directional plays beat your premium-selling strategies over time.