# Get your Interactive Brokers trade history into a spreadsheet Independent and unofficial. Not affiliated with or endorsed by any broker or platform named here. Educational only: nothing here is advice, and nothing here recommends a broker or a trade. This is the markdown version of https://openbrokerapi.com/guides/ibkr-trade-history, written from the same records as that page. Risk warning: CFDs and spread bets are complex instruments and come with a high risk of losing money rapidly due to leverage. You can lose money on these products, and each provider publishes its own loss figure under FCA rules. You should consider whether you understand how they work and whether you can afford to take the high risk of losing your money. Automated and API trading can amplify losses through bugs, connectivity failures and runaway orders. Two routes in Client Portal: an Activity Statement for a quick CSV, or a Flex Query when you want only the trade columns you choose. Every desktop step is confirmed in IBKR's own guides; a mobile export is not. - Checked: 2026-09-18 - For: Non-coders - About: [Interactive Brokers](https://openbrokerapi.com/brokers/ibkr) ## Steps ### 1. Open Statements Log in to Client Portal and go to Performance & Reports, then Statements (or Menu, Reporting, Statements). Status: verified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/runstatement.htm), checked 2026-09-18. ### 2. Run the Activity Statement Click the blue Run arrow next to the statement. Choose a period: Daily, Custom Date Range, Monthly, Annually or Year to Date. Status: verified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/runstatement.htm), checked 2026-09-18. ### 3. Pick CSV Choose CSV as the format and save the file. IBKR says CSV opens in Excel and similar programs; PDF and HTML are also offered. Status: verified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/runstatement.htm), checked 2026-09-18. ### 4. Or build a Flex Query For a clean trades only sheet, go to Performance & Reports, then Flex Queries, and click + for an Activity Flex Query. Name it, tick the Trades section and the fields you want, and drag them into order. Status: verified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/activityflex.htm), checked 2026-09-18. ### 5. Choose format and period Set delivery format to CSV (XML, pipe or tab text are also offered) and a period such as Last 365 Calendar Days or Year to Date, then save and run it. Status: verified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/activityflex.htm), checked 2026-09-18. ### 6. On the mobile app We could not confirm a statement or Flex Query export from the IBKR mobile app. Use Client Portal in a browser. Status: unverified. Source: [ibkrguides.com](https://www.ibkrguides.com/orgportal/performanceandstatements/runstatement.htm), no checked date recorded. ## Sources - Status: verified. Source: [IBKR guides: how to run a statement](https://www.ibkrguides.com/orgportal/performanceandstatements/runstatement.htm), checked 2026-09-18. - Status: verified. Source: [IBKR guides: create an Activity Flex Query](https://www.ibkrguides.com/orgportal/performanceandstatements/activityflex.htm), checked 2026-09-18. - Status: verified. Source: [IBKR guides: Trades Flex fields](https://www.ibkrguides.com/reportingreference/reportguide/tradesfq.htm), checked 2026-09-18. - Status: verified. Source: [IBKR Campus: Client Portal reports](https://www.interactivebrokers.com/campus/trading-lessons/client-portal-reporting/), checked 2026-09-18. - Status: verified. Source: [gov.uk: Self Assessment tax returns, deadlines](https://www.gov.uk/self-assessment-tax-returns/deadlines), checked 2026-09-18. ## More on the Interactive Brokers API - [Interactive Brokers API quickstart](https://openbrokerapi.com/brokers/ibkr/quickstart): From credentials to a first call on a demo account, step by step. - [Interactive Brokers API error codes](https://openbrokerapi.com/errors/ibkr): 511 decoded, each with what it means, and the fix where the source gives one. - [Interactive Brokers API endpoints](https://openbrokerapi.com/brokers/ibkr/endpoints): 23 documented, each with its method, path, parameters and source. - [Interactive Brokers API page](https://openbrokerapi.com/brokers/ibkr): The full record: access, authentication, limits and the source for each. - [IBKR API without TWS: headless IB Gateway options](https://openbrokerapi.com/guides/ibkr-headless-gateway): Guide - [The three Interactive Brokers REST front doors compared](https://openbrokerapi.com/guides/ibkr-rest-front-doors): Guide - [Interactive Brokers MCP servers, compared](https://openbrokerapi.com/guides/interactive-brokers-mcp-servers): Guide ## Licence and how to cite The records behind this page are all rights reserved. This file is the page itself, at its own address, in another format. It is not part of the CC BY 4.0 downloads listed at https://openbrokerapi.com/data. Quote from it with a link to the page. Cite as: Get your Interactive Brokers trade history into a spreadsheet. Broker API Hub, https://openbrokerapi.com/guides/ibkr-trade-history, newest check 2026-09-18. Where you rely on a single figure, cite the source and the checked date printed beside it as well. Where this page and a broker's own documentation differ, the documentation wins.