Import from Interactive Brokers

How to Set Up Interactive Brokers Flex Queries for Manual and Automatic File Imports

You can find screenshots within the "Add assets" part of the website.

Step 1: Create an Activity Flex Query

1. Log into the Interactive Brokers website and navigate to the 'Reports' page.

2. Select 'Flex Queries' from the menu.

3. Click the '+' button next to 'Activity Flex Query'.

4. Enter a Query Name and, under the Sections list, select 'Cash Transactions'.

5. Select all groups except Summary, then check the 'Select All' checkbox for fields, and click Save.

6. Next, under Sections, select 'Trades'.

7. Choose 'Execution', check 'Select All' for fields, and click Save.

8. In the 'Delivery Configuration' section:

   • Change the Format to CSV.

   • Ensure both 'Include column headers' and 'Include section code and line descriptor' are checked.

9. Under 'General Configuration', set all toggles to 'No'.

   • Set the Date Format to 'yyyy-MM-dd'.

   • Set the Time Format to 'HH:mm

     ', with a single space between the date and time.

10. Click Continue and then Save Changes.

Step 2: Run the Activity Flex Query

1. Return to the Flex Queries page.

2. Click the right arrow next to the created query and select 'Run', choosing the desired period.

3. Download the file and upload it to WealthBee.

Step 3: AutoSync for Interactive Brokers (Automatic File Import)

To enable AutoSync, you need to configure both the Historical Update and Trade Confirmations reports.

1. Set up the Historical Update under the relevant tab.

2. Configure Trade Confirmations as detailed below.

3. Once both are set, add the AutoSync Configuration above.

Step 4: Create a Trade Confirmation Flex Query

1. Log into the Interactive Brokers website and go to the 'Reports' page.

2. Select 'Flex Queries', then click the '+' next to 'Trade Confirmation Flex Query'.

3. Enter a Query Name and select 'Trade Confirmation' under the Sections list.

4. Select All fields using the 'Select All' checkbox, then click Save.

5. In Delivery Configuration, change the Format to CSV.

6. Under General Configuration, ensure all toggles are set to 'No', then click Create.