This setup is a one-time process. Once completed, past trades for the selected date range will be imported, and future trades will be imported automatically on a daily basis.
Note: Same-day trades may not appear immediately due to broker delays (typically within 24 hours). For immediate import, use the CSV upload option in TradeZella.
To connect your Interactive Broker account with TradeZella, follow these steps:
1. Initial Setup and Integration:
Visit the TradeZella Broker Sync page or click on "Add Trade" in the left sidebar and then navigate to the 'Broker Sync' tab.
Once you're on the broker sync tab, click on "Add New Broker" and select IBKR.
Flex Token and Report ID: You'll need to input a Flex Token and Report ID(Activity Flex Query ID) to sync your IBKR account with Tradezella.
2. Steps to Retrieve Flex Token and Report ID(Activity Flex Query ID):
Log in to your Interactive Broker Web Portal.
Navigate to the Flex Queries page:
Click on Performance and Reports > Flex Queries
Obtain Flex Token
Obtain Flex Token
Click on the settings(gear) icon next to the "Flex Web Service Configuration"
A pop-up window will appear. From there, check "Flex Web Service Status" and set the activation period to one year (e.g., 2024-2025).
Click on Generate a new Flex Token button.
Click on the save button.
Copy the Flex Token ID into your clipboard.
Steps to Retrieve Report ID
Steps to Retrieve Report ID
Click on the plus icon next to Activity Flex Query in the Flex Queries page and create a new query.
Name the query (e.g., "TradeZella") and choose "Trades" under Sections.
Important Step → Inside "Trades", select "Executions" and then 'Select All'. Scroll to the bottom and click the save button to save.
For Delivery Configurations, choose CSV format with column headers enabled.
If you have multiple accounts, select the account for which you want to create this query.
Leave all settings as default
Select the desired "Period.” I recommend you select the last 365 days!
Important Step → Under General Configuration, make sure that the following configuration are selected:
Date Format: 'yyyy-MM-dd',
Time Format 'HH:mm:ss',
Date/Time Separator ' 'single space.
Click continue, then create, and confirm with "Ok".
Open the Flex Query again by clicking the info icon (i Icon) and copy the Activity Flex Query ID (Report ID).
3. Integration on TradeZella:
In TradeZella, enter the copied Flex Token into the "Flex Token" field.
Enter the copied Activity Flex Query ID into the "Report ID" field.
Click "CONNECT" to initiate the integration.
TradeZella will sync the selected account, and you will see the sync status on the broker sync page here.
Common Issues:
Ensure there is at least one day-old trade in your account for synchronization.
Select the correct Date time format and correct date time sepreateeor
Date format: yyyy-MM-dd
Time format: HH:mm:ss
Date/Time Separator: ‘ ‘ (single-space)
For further troubleshooting of Interactive Brokers (IBKR) Sync Issues, check out the help article here.
By following these steps, your Interactive Broker account will be successfully linked with TradeZella, allowing for automated trade imports and historical data retrieval.
Need further support? Contact our support team at support@tradezella.com