Download your Interactive Brokers actions

With Interactive Brokers you can convert your broker history to our Google Sheets template. To convert your broker actions, you need to download your broker history.

For Interactive Brokers there are two CSV exports needed. A “Transactions” file for all the transactions. And a “Cash Transactions” file for Dividend, Bookings and Expenses.

Step 1: Log in to Interactive Brokers.

Step 2: Go to the menu item Performance & Reports and select Flex Queries.

“Transactions” setup

To create the export, we first need to setup the right export settings. So the future exports can be downloaded more easily. This CSV is needed for your Transactions.

Step 1: Click on the "+" sign in Trade Confirmation Flex Query and give it a Query Name (e.g. Transactions).

Step 2: Click the Trade Confirmation button and Select All the possible options and click om the Save button.

Step 3: Choose CSV as the format option.

Step 4: All the other settings you can keep them as default. Select Continue on the bottom of the page. And finally review and create the Transactions file.

“Transactions” download

Step 1: When the one-time setup is done. You can download the Transaction Query by pressing the Run button.

Step 2: Select the investing Period and please be sure that the CSV format is selected as well.

365 days is the longest possible period. For example, if you want to export 2 years of data, you need to download two separate files, each for 1 calendar year.

“Cash Transactions” setup

To create the export, we first need to setup the right export settings. So the future exports can be downloaded more easily. This CSV is needed for your Dividends, Bookings and Expenses.

Step 1: Click on the "+" sign in Activity Flex Query and give it a Query Name (e.g. Cash Transactions).

Step 2: Click the Cash Transactions button and Select All the possible options and click on the Save button.

Step 3: Choose CSV as the format option.

Step 4: All the other settings you can keep them as default. Select Continue on the bottom of the page.

“Cash Transactions” download