{"id":1922,"date":"2024-04-29T18:54:35","date_gmt":"2024-04-29T18:54:35","guid":{"rendered":"https:\/\/live-portfellow-com.vserver.zonevs.eu\/?p=1922"},"modified":"2024-05-30T20:33:40","modified_gmt":"2024-05-30T20:33:40","slug":"how-to-configure-ib-import","status":"publish","type":"post","link":"https:\/\/www2.portfellow.com\/et\/how-to-configure-ib-import\/","title":{"rendered":"How to configure Interactive Brokers import"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

How to configure Interactive Brokers automatic import<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

From this page you can find the guide how to create a Flex Query ID and Token to enable automatic transaction import from Interactive Brokers.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 1: Log into your Interactive Brokers account<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

Click “Log in” and then click “Portal Login”<\/p>

\"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 2: Go to Flex Queries page<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

From the menu choose:\u00a0Reporting -> Flex Queries<\/b><\/p>

\"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 3:\u00a0Start creating new Flex Query Report<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

Click on the “+” icon, to start configuring the report<\/p>

\"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 4:\u00a0Configure \"Cash Transactions\"<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t
  1. From the “Sections” list, click on the “Cash Transactions”.
    1. Choose all options, except Summary<\/li>
    2. Click “Select All” to select all fields<\/li>
    3. Click “Save”<\/li><\/ol><\/li><\/ol>

      \"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

      \n\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 5:\u00a0Configure \"Trades\"<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t
      1. From the “Sections” list, click on the “Trades”.
        1. Choose only “Execution”<\/li>
        2. Click “Select All” to select all fields<\/li>
        3. Click “Save”<\/li><\/ol><\/li><\/ol>

          \"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

          \n\t\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 6:\u00a0Fill \"Delivery Configurations\" and \"General Configuration\"<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t
          1. Choose format “XML”<\/li>
          2. Choose period “Last 30 Calendar Days”<\/li>
          3. Set Date Format: yyyy-MM-dd<\/li>
          4. Set Time Format: HH:mm:ss<\/li>
          5. Set Date\/Time Separator: ; (semi-colon)<\/li>
          6. Set all other options: “No”<\/li>
          7. Click “Save”<\/li><\/ol>

            \"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 7: Get and save the Query ID<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

            From the report list, click on the name of the created report and there you can see field Query ID<\/strong>. Copy the number to Portfellow.<\/p>

            \"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 8: Go to Flex Web Services settings<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

            From the “Flex Queries page” click on the cog icon next to the “Flex Web Service Configuration”.<\/p>

            \"\"<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 9: Enable Flex Web Services<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

            On the new window tick the “Flex Web Services Status” checkbox, choose 1 Year and leave the IP address field empty and click Generate New Token and click “Save” if needed.<\/p>

            \"\"<\/p>

            \u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 10: Save the Current Token<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

            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.<\/p>

            Copy “Current Token” field to Portfellow.\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStep 11: Enter the Flex Query ID and Token to Portfellow<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

            Copy “Current Token” field to Portfellow.\u00a0<\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t