Broker API HubMenu

Get your Interactive Brokers trade history into a spreadsheet

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.

Independent and unofficialChecked For: Non-coders

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.

Steps

  1. Open Statements

    Log in to Client Portal and go to Performance & Reports, then Statements (or Menu, Reporting, Statements).

    ibkrguides.comchecked

  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.

    ibkrguides.comchecked

  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.

    ibkrguides.comchecked

  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.

    ibkrguides.comchecked

  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.

    ibkrguides.comchecked

  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.

    Unverifiedibkrguides.com

Sources

Sections