To connect Interactive Brokers (IB) to Exirio and enable all the metrics in your account, you need to configure a Flex Query within IB. The process should take between 2 and 5 minutes; if you have any trouble with this process, please drop us an email at support@exirio.com and we will be happy to help. 

Please note that if you follow the instructions provided by Plaid in the connection dialog to get IB's Query and Token, you will get balances but not your historical trades. Please follow the process described below to obtain your transactions too.

Enabling the connection in IB

1. Log into Interactive Brokers

1.1. Log into you Interactive Brokers Account Management

https://www.interactivebrokers.com/sso/Login

 

 2. Activate Flex Web Services

    2.1 On the top right of the screen, select "Manage Account"


    

    2.2. Scroll down and on the right you will find the section "Reporting", click on "Configure".


    

    2.3. Click the box to enable the Flex Web Service.


    

    2.4 Copy/Paste the Token somewhere else, you will need it later.


Note that the Token has an expiry date, after which you will need to come back here and generate a new one to keep the connection alive.

3. Create Flex Query

    3.1. On the top menu, click on Reports-Flex Queries.


    

    3.2. Click on the '+' "Create" button in Activity Flex Query.


    

    3.3. Enter a name for the new Query, e.g. Exirio


    

    3.4. Select the information that will be contained in the Query

Select the following Sections. When a dialog box asks you to choose details within those sections, just select everything with "Select All". >

  • Account Information

  • Cash Report

  • Cash Transactions

  • Open Positions

  • Trades


In Delivery Configuration:

  • Select Period: Last 365 Calendar Days.

  • Leave everything else with the default option.

Once you have selected all the required options, click "Continue", "Create" and "OK".


3.5. Get and copy the Flex Query

Back on the main page of Activity Flex Query, click on the 'i' info button.


Copy/Write down the Query ID, you will need it later. Close the window clicking on the X on the top right.


4. Log into Exirio and enter those details

    4.1 Add Holding and enter the details

Finally, return to the Exirio app, click on the Add Holding + button, select "Connect external institution" (you might have reached these instructions from there already) and follow the screens to select Interactive Brokers and enter your details: username, password, Query ID (the one you have created in step 3) and Token (the one you have copied in step 2).

Your Interactive Brokers data will now synchronize and appear in Exirio.

    4.2 Further optional configuration

Please note that due to current limitations of the Interactive Brokers and Plaid API, if you want to have a full view of your investments you have to manually input/edit:

  • Transactions older than 1 year (if any). Exirio creates a balancing Transaction with date 1 year ago that you can edit if the Transaction happened further in the past. Or add several Transactions if there is more than one.

  • Cash positions (if substantially different from zero). At the moment IB does not send cash positions to Exirio and you will have to add them manually.