Importing your trades from Interactive Brokers into TradeZella 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 "TradeZella" 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 TradeZella.
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 TradeZella
Visit the TradeZella File Upload page at TradeZella File Upload.
Select the account where you want to upload this file, choose Interactive Brokers from the broker list, and upload your saved CSV file. TradeZella will handle the rest.
For Future File Imports
For future imports, you only need to follow steps 6 and 7:
Click on the blue arrow next to the query you created.
Select the date range of trades.
Hit RUN to generate a new CSV file.
Upload the newly generated CSV file.
By following these steps, you ensure that your trading data is always up-to-date in TradeZella, allowing you to leverage its powerful features for your trading analysis and tracking.
Common Errors
If your file upload is giving you an issue:
Go to the import history page.
Click on the dropdown right next to the file upload you just did.
Scroll to the right. If you see an invalid date and time, it means that you missed a step.
To resolve this:
Open the query and ensure the following configurations are set under General Configurations:
Date Format: Select “yyyyMMdd”
Time Format: Select “HHmmss”
Date/Time Separator: Select “semi-colon”
After these steps, you should be able to re-run the import and get your trades imported into TradeZella.
Need further support? Contact our support team at support@tradezella.com