Interactive Brokers - Import

Visit the Interactive Brokers website and log in to the web application using your credentials.

Find the Performance & Reports section in your account dashboard and select Flex Queries.

Click 'Create' on Activity Flex Query. Note that this configuration process is only needed once - afterwards you'll just run the prepared queries.

Select 'Cash Transaction' from the available sections to create your first query for cash transactions.

Leave default options selected and pick these specific fields: Currency, Symbol, Description, ISIN, Date/Time, Amount, Type, FIGI.

Scroll down to the delivery configuration section and change the format to CSV.

Scroll down to General Configuration and set the correct date format, time format, and separator. Save this query when complete.

Repeat the last steps but this time choose 'Trades'

Select these fields: Currency, Symbol, Description, ISIN, Date/Time, Quantity, TradePrice, Trade Money, Taxes, IB Commission, IB Commission Currency, Buy/Sell, FIGI.

Use the same delivery configuration (CSV format) as the previous Cash Transactions query.

Use the same general configuration (date format, time format, separator) as the previous Cash Transactions query. Save this query.

Run both the Cash Transactions and Trades reports.

Run both the Cash Transactions and Trades reports for your specified date range. The system will generate the CSV files for download.

The generated CSV files can now be imported directly into FundStat. Once configured, you no longer need to set up these queries again - simply run them whenever you need updated trades or cash transactions from your broker.