Back to brokers & apps

Setting up your IBKR connection

Embedded content: https://www.youtube.com/watch?v=rYmq3T6_wk8

IBKR connection only import past 7 days and ongoing trades. For how to import historical trades, go to Importing historical trades from IBKR.

1 - Get the Web Service details (token/Query ID) from Interactive Broker Portal

Select Performance & Reports > Third Party Reports > Third-Party Services (gear icon) > Select Sharesight > Save.

Token and Query ID will be presented.

2 - Log into Sharesight account.

3 - Click Account on the top right.

4 - Click Connections > Add Connection.

5 - Set connection type: Interactive Brokers (Web Service).

6 - Enter the following details:

  • Your Interactive Brokers (Web Service) account name (i.e IBKR).

  • Token and Query id from step 1.

  • Click Create Connection.

7 - Return to the Portfolio Investments page you wish to link to Interactive Brokers.

8 - Click Settings

9 - Under Integration, click Interactive Broker (Web Service).

10 - Select the Connection you added earlier.

11 - Enter your Interactive Brokers account ID.

12 - Click Create Integration to complete the setup.

How do I know if the IBKR integration is setup correctly?

The transaction log should show the transactions. Sometimes, it might take 24-48 hours to see transactions.

Most of the time, it will show Unsuccessful status with a No valid trades to import description. This means the integration is successful. This status just means no trade are imported because you haven’t make any trade for the day. Not an error.

For a full explanation of transaction log statuses, see Understanding the IBKR transaction log.

If the transaction log shows No transactions found 48 hours after the integration setup, check the below:

  1. Make sure both token and query ID (locate them in Connections page or go Account > Connections) match what's in your Interactive Brokers account.

  2. The connection is added to a specific portfolio (Settings > Integrations > Interactive Brokers (Web service) > Connection).

  3. Buy or sell trades are imported on settlement date. This is usually 2 days after the trade date.

  4. The integration only import trades made over the past 7 days. Follow the steps here to import all trades history.