Importing Trades via Broker Sync

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

• 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

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

‍

Importing Trades via File Upload Method

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:

1. Click on the blue arrow next to the query you created.
2. Select the date range of trades.
3. Hit RUN to generate a new CSV file.
4. 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:

1. Open the query and ensure the following configurations are set under General Configurations:
2. 1. Date Format: Select “yyyyMMdd”
   2. Time Format: Select “HHmmss”
   3. 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.