Interactive Brokers automaatse impordi seadistamine

Getting Query Id and Token

• Go to Interactive Brokers homepage
• Click “Log in” and then click “Portal Login”
• Go to Flex Queries page
  • From the menu choose: Reporting -> Flex Queries

Start creating new Flex Query Report

• Click on the “+” icon, to start configuring the report

Configure “Cash Transactions”

• From the “Sections” list, click on the “Cash Transactions”.
  1. Choose all options, except Summary
  2. Click “Select All” to select all fields
  3. Click “Save”

Configure “Trades”

• From the “Sections” list, click on the “Trades”.
  1. Choose only “Execution”
  2. Click “Select All” to select all fields
  3. Click “Save”

Configure “Forex Balances”

• From the “Sections” list, click on the “Forex Balances”.
  1. Choose only “Summary”
  2. Click “Select All” to select all fields
  3. Click “Save”

 

Fill “Delivery Configurations” and “General Configuration”

• Choose format “XML”
• Choose period “Last 30 Calendar Days”
• Set Date Format: yyyy-MM-dd
• Set Time Format: HH:mm:ss
• Set Date/Time Separator: ; (semi-colon)
• Set all other options: “No”
• Click “Save”

Get and save the Query ID

• From the report list, click on the name of the created report and there you can see field Query ID. Copy the number to Portfellow.

Go to Flex Web Services settings

• From the “Flex Queries page” click on the cog icon next to the “Flex Web Service Configuration”.

Enable Flex Web Services

• On the new window tick the “Flex Web Services Status” checkbox
• Choose 1 Year
• Leave the IP address field empty
• Click Generate New Token
• Click “Save” if needed

Save the Current Token

• If the Activation Period is too short, you can click on the “Generate New Token” field and choose 1 year expiry time. You need to click this button also to generate a new token, when previous one expires in about 1 year.
• Copy “Current Token” field for Portfellow.

Enter the Flex Query ID and Token to Portfellow