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
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/Query ID will be presented. If expired, you can renew token directly within IBKR portal and enter the new credentials into Sharesight)
2 - Log into Sharesight account.
3 - Click on the Account menu from any page in Sharesight.
4 - Click onto the Connections option.
5 - Click the Add New Connection button to add your Interactive Brokers account.
6- Set connection type as Interactive Brokers (Web Service).
7 - Enter the following details:
A) Your Interactive Brokers (Web Service) account name.
B) The Web Service Token and Query id from step 1.
C) Click the Create Integration button once finished.
8 - You’ll now see your IB integration appear on the manage connections page.
9 - Return to the portfolio overview page you wish to link to Interactive Brokers and click the Settings tab.
10 - Click on Integration, then set the Integration option as Interactive Broker (Web Service).
11 - Then add your saved connection from earlier.
12 - Enter your Interactive Brokers account ID in the text box underneath. Select your email notification preferences.
13 - Click the Create Integration button to finalise the connection.
Import historical trades
Embedded content:https://www.youtube.com/watch?v=_jc94usXXpg
IBKR only trades over the past 7 days after you setup the integration.
To import trades older than 7 days:
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 Overview page, select Brokers tab.
14 - Search Interactive Brokers.
15 - Select Upload a file.