Importing your trades from Interactive Brokers into TradeReview involves a one-time setup in your Interactive Brokers account. After completing this setup, future imports will be quick and easy. Follow the steps below to get started.
One-Time Setup in Interactive Brokers
Step 1: Start by logging into your Interactive Brokers Client Portal.
Step 2: In the main menu, click on "Performance and Statements," and from the dropdown, select “Flex Queries.”
Step 3: Create a New Trade Confirmation Flex Query by Clicking on the plus icon next to the Trade Confirmation Flex Query title.
Step 4: Enter the name "TradeReview" next to the Query Name. Select "Trade Confirmation" under Sections, and a pop-up will appear.
From the pop-up, click on Executions and ensure "Select All" is checked. Scroll down and click "SAVE."
Set General Configurations
Under General Configurations, set the following:
Date Format: Select "yyyyMMdd"
Time Format: Select "HHmmss"
Date/Time Separator: Select "semi-colon"
Click on "Continue."
Step 5: A new window will appear for you to review the query. Click "Create." A confirmation window will appear. Click "Ok."
Step 6: Interactive Brokers will take you back to the Flex Queries page.
Click the blue arrow icon pointing to the right next to the Flex Query you just created called TradeReview.
Step 7: Select the date range of trades you would like to import (e.g., Last 365 Calendar Days). Then select CSV for the file format and hit RUN. A CSV file will be downloaded to your computer.
Uploading the exported file into TradeReview
1. Visit the TradeReview import page here or by clicking the "+" button on the sidebar.
2. Select Your Account
Select the account to which you want to import trades