Interactive Brokers
Connect your Interactive Brokers account with Sharesight to sync your ongoing trades into your Sharesight portfolio. All Sharesight and Sharesight Professional users can connect their Interactive Brokers account to their Sharesight portfolio.
Note: We only import standard buy and sell trades via the integration. Short selling transactions, including short and cover trade types, are not supported.
Jump to:
How to connect your Interactive Brokers account
Embedded content: https://www.youtube.com/watch?v=rYmq3T6_wk8
Please note that this connection will only import your ongoing trades.
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:
A) Your Interactive Brokers (Web Service) account name (i.e IBKR).
B) Token and Query id from step 1.
C) 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.
Import historical trades
Embedded content:https://www.youtube.com/watch?v=_jc94usXXpg
To import historical trades:
1 - Log into your Interactive Brokers account.
2 - Click on the Reports tab & select Flex Queries.
3 - Click '+' next to Activity Flex Query.
4 - Select Trades under Sections.
5 - Select Executions on the pop up window.
6 - Tick SELECT ALL and click Save.
7 - Enter a Query Name.
8 - Change Date Format to mm/dd/yyyy under General Configuration.
9 - Click Create.
10 - Run the Activity Flex Query.
11 - Under Period, select Custom Date Range to cover all trades.
12 - Set Format as CSV, click Run and download your trades.
13 - In Sharesight Investments page, click Add investment > Upload via broker.
14 - Search Interactive Brokers.
15 - Select Upload a file.
Note: Your Interactive Brokers trades will be synced to your Sharesight portfolio twice per day (morning and night). These trades will only import once they have reached the settlement date in Interactive Brokers. The imported data will displayed under the “View transaction log”.
Need help with your IBKR connection?
Visit our Interactive Brokers help centre for guides on troubleshooting, token renewal, and more.