Configure Flex Queries with AI

Generate institutional-grade reports using natural language prompts.

Complex Data, Without the Complexity.

Describe the data you need and IBKR automatically configures the corresponding Flex Query for Activity or Trade Confirmation reporting.

No manual field selection
No complex query setup

From Prompt to Export in Seconds.

Access sophisticated reporting workflows through a faster, more intuitive interface built for portfolio management, reconciliation and operational reporting.

Create reports using natural-language prompts
Automatically configure Activity and Trade Confirmation Flex Queries
Preview query structures and selected data before downloading
Export reports as CSV, XML or text formats for downstream workflows

Sample Query Prompts

You can generate Flex Queries with statements such as:

Positions

"Show me unrealized gains and losses for all open positions"
Tax Reporting

"Realized short-term and long-term gains by symbol year to date"
Income

"All dividends and interest received across my accounts this year"
Performance

"Monthly account performance including fees and commissions"
Cash Flow

"Net deposits and withdrawals by account for the last quarter"
Trade Activity

"Show me all trades executed this quarter along with my current open positions and unrealized P&L"
Tax Reporting

"Realized gains year to date and total dividends received, broken down by account"
Corporate Actions

"List all corporate actions for each account this year"
Account Settings

"Show me the dividend reinvestment settings and tax lot matching method for each client account"
Performance

"Net asset value summary by account at year-end compared to start of year"

USER GUIDES

Configure Flex Queries with AI

For more information on generating flex queries, visit IBKR Guides.