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

Import or sync your Interactive Brokers trades into TradeBB and turn your IBKR trade history into a structured trading journal with P&L tracking, reports, notes, tags, calendar views, and multi-account analysis.

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

Recommended: Transaction History CSV

Go to:

IBKR Client Portal → Performance & Reports → Transaction History

Select your date range, download the CSV file, and upload the original file to TradeBB.

IBKR official guide:
https://www.ibkrguides.com/clientportal/transaction-history.htm