Back to brokers & apps

Importing historical trades from IBKR

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

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”.

What if my trades go back more than a year?

IBKR only allow a date selection of 365 days per query or each transaction file download.

How to import all historical trades since inception

  1. After you created the Flex Queries, run it, set period to Year to Date > Run. This covers the current calendar year.

  2. Run the same flex queries, set period to Custom date range > From Date 01 Jan YYYY > To Date 31 Dec YYYY for the previous calendar year.

  3. Repeat for all calendar year until inception year.

Still need help?

If your token is renewed but trades are still not syncing, contact our support team.