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

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.