Guide · about 5 minutes
Set it up once: create a Flex Query and a token in IBKR, paste them into Market Matrix, and your trades come in every hour. No more file exports.
Log in to IBKR’s Client Portal. In the top menu choose Performance & Reports, then Flex Queries. Next to Activity Flex Query, click the +.
Type a name such as Market Matrix in Query Name. Under Sections, click Trades.
In the Trades window, tick Executions under Options. Click Select All under the list of fields, then click Save.
Still under Sections, click Open Positions. Tick Summary under Options, click Select All, then Save. Market Matrix then shows the trades you’re still in, with IBKR’s latest price and unrealized P&L.
Scroll down. Under Delivery Configuration choose Format XML and Period Last 365 Calendar Days. Leave General Configuration as it is (date yyyyMMdd, time HHmmss, separator semicolon). Click Continue.
IBKR shows a summary of your query. Click Create. You’re back on the Flex Queries page with the new query in the list.
Click the ⓘ next to your new query. Write down the Query ID, a number of about 7 digits.
On the right of the Flex Queries page, click the gear next to Flex Web Service Configuration. Turn the service on if it’s off, click Generate New Token and pick the longest expiry. Copy the token and keep it private, like a password.
In Market Matrix open Accounts → Add account → Interactive Brokers → Live sync. Paste the token, type the Query ID and click Connect.
IBKR takes a few minutes to build your first report. When it’s ready your IBKR account numbers appear: tick the ones to add, choose how far back to import and click Start tracking. Market Matrix then checks IBKR every hour for new trades.
You made a query with that name before. Use another name, such as Market Matrix 2.
The report only covers the last 365 days, and IBKR doesn’t build reports for an account that hasn’t been funded yet. Check that the query has the Trades section with Executions ticked, then click Ask IBKR again.
Tokens expire. Generate a new one (step 8) and connect again with it.
IBKR adds each day’s trades to this report after the market closes, so they show up the next day. A trade you’re still in shows under Open positions on Home, and becomes a trade in your journal once it’s fully closed.
The first report can take a few minutes, and longer on weekends while IBKR does maintenance. You can close the window: your accounts will be there when you come back.
The token can only download your reports. It can’t place trades or move money. Market Matrix stores it encrypted, and you can disconnect any time from Accounts.