Importing your trades from Interactive Broker requires this one-time setup in your Interactive broker account. You do not have to repeat steps 1-12 for each import.
For new imports, you can just follow Step 13 and click ''RUN'' to generate a file.
Log in to your Interactive Broker Client Portal
In the main menu, click on “Performance and Statements’’.
Click on "Flex Queries” under the Report section.
Click on the plus icon next to the Trade Confirmation Flex Query title.
Enter the name TradeZella next to Query Name.
Select "Trade Confirmation" under Sections.
Click Executions and ensure ''Select All'', is clicked on this Popup window.
Scroll down and Hit ‘’SAVE''.
Under General Configurations: By default you should see these configurations.
- Date Format: Select "yyyyMMdd"- Time Format: Select "HHmmss"
- Date/Time Separator: Select "semi-colon"
Click on "Continue".
A new window will show up for you to review the query, Click "Create".
A new window will show up confirming you have created your query, Click "Ok".
Interactive Broker will take you back to the Flex Queries.
Click the blue arrow icon pointing to the right next to the Flex Query you just built called TradeZella. (titled RUN)
Select the date range of trades you would like to import (example: Last 365 Calendar Days), then select CSV for the file format, and hit RUN.
A CSV file will be downloaded to your computer and you can upload that into TradeZella by clicking on the ''Add Trade'' button on the left side panel and choosing CSV.
Please Note: For importing trades in the future you can just click on the blue arrow next to the query you just created called TradeZella, following Steps 13 to 15, and select the date range of trades.