Wheelytics Logo

How to Set Up Flex Reports in IBKR for Wheelytics

Why do I need two Flex Reports?

Wheelytics uses two separate Flex Reports to import your options trade data from Interactive Brokers (IBKR):

  • Activity Flex Query – used both for initial historical import and for daily background syncs. This query helps capture trades that may appear in the report outside of market hours (e.g., on weekends or after expiration events). You can set any date range, but the report must include all required trade fields for proper processing. We recommend selecting “Last 365 Calendar Days” for the broadest coverage.

  • Trade Confirmation Flex Query – used for importing real-time trade updates during market hours. It runs automatically once per hour while markets are open.

Using both reports ensures complete, reliable, and continuous tracking of your options trades — including delayed or off-hours activity.

1. Create Activity Flex Query (Historical Report)

  1. Log in to your Interactive Brokers account
  2. Navigate to Performance & Reports → Flex Queries → Create New Activity Flex Query
  3. Name the query: Wheelytics Activity Report
  4. Under Sections, choose: Trades
  5. Make sure Execution is checked
  6. Under Field Selection, click Select All or manually include the following required fields:
  • Account Id
  • Trade ID
  • Symbol
  • Underlying Symbol
  • Description
  • Strike
  • Expiry
  • Quantity
  • Trade Price
  • Proceeds
  • Net Cash
  • Trade Date
  • Buy/Sell
  • Put/Call
  • Ib Commission
  • Open Close Indicator
  • Date/Time
  1. Under Period, select the range you wish to import — we recommend “Last 365 Calendar Days” for full coverage, but shorter or custom periods are also supported.
  2. In the Flex Web Service Configuration, enable: Flex Web Service Status
  3. Leave all other settings as default and click Continue, then Create.

This report will be used for both initial import and daily background syncs to capture delayed trades outside regular market hours.

2. Create Daily Flex Report (Trade Confirmation Flex Query)

  1. Go to Performance & Reports → Flex Queries → Create New Trade Confirmation Flex Query
  2. Name the query: Wheelytics Daily Trade Confirmations
  3. Select the following fields:
  • Account Id
  • Trade ID
  • Symbol
  • Underlying Symbol
  • Description
  • Strike
  • Expiry
  • Quantity
  • Price
  • Proceeds
  • Net Cash
  • Trade Date
  • Buy/Sell
  • Put/Call
  • Commission
  • Date/Time
  1. The Period is automatically set to: Today
  2. In Flex Web Service Configuration, enable: Flex Web Service Status
  3. Leave all other settings as default and click Continue, then Create.

This report is used for hourly syncs during market hours to keep your dashboard up to date in near real time.

What are the required fields?

Below is the full list of required fields for Wheelytics to process your trades correctly:

FieldDescription
Account IdIBKR account identifier
Trade IDUnique trade identifier
SymbolOption or stock symbol
Underlying SymbolUnderlying asset symbol
DescriptionHuman-readable description
StrikeOption strike price
ExpiryExpiration date of the option
QuantityNumber of contracts
Trade Price / PriceExecution price per contract (depends on report type)
ProceedsTotal trade value before commissions
Net CashProceeds minus commissions
Trade DateDate of the trade
Buy/SellBUY or SELL indicator
Put/CallType of option (PUT or CALL)
Ib Commission / CommissionIBKR commission for the trade
Open Close IndicatorIndicates if the trade opened or closed a position
Date/TimeFull timestamp of the trade

Where do I enter the Query ID and Token?

Go to the IBKR page in your Wheelytics account:

  • Current Token – your current token from IBKR
  • Activity Flex Query ID – used for historical import and daily background sync
  • Trade Confirmation Flex Query ID – used for real-time updates during market hours