{"id":2372,"date":"2024-05-30T20:18:23","date_gmt":"2024-05-30T20:18:23","guid":{"rendered":"https:\/\/live-portfellow-com.vserver.zonevs.eu\/?post_type=docs&#038;p=2372"},"modified":"2025-02-04T16:36:09","modified_gmt":"2025-02-04T16:36:09","password":"","slug":"kuidas-seadistada-interactive-brokers-automaatne-import","status":"publish","type":"docs","link":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/","title":{"rendered":"Interactive Brokers andmete import"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Kuidas saada Query ID ja Token?<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Logi sisse Interactive Brokers keskkonda<\/li>\n\n\n\n<li>Mine Interactive Brokers kodulehele.<\/li>\n\n\n\n<li>Mine Flex Queries lehele\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Men\u00fc\u00fcst vali: Reporting --&gt; Flex Queries<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"657\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45-1024x657.png\" alt=\"\" class=\"wp-image-1930\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45-1024x657.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45-300x193.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45-768x493.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45-1536x986.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.37.45.png 2022w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Seadista raporti sektsioonid<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kl\u00f5psa \"+\", et alustada uue Flex Query Report loomist.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"699\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-1024x699.png\" alt=\"\" class=\"wp-image-1931\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-1024x699.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-300x205.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-768x525.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-1536x1049.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.38.12-2048x1399.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Seadista \"Cash Transactions\"<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"Sections\" listist vali \"Cash Transactions\"\n<ol class=\"wp-block-list\">\n<li>Vali k\u00f5ik, v\u00e4lja arvatud \"Summary\"<\/li>\n\n\n\n<li>Vajuta \"Select all\"<\/li>\n\n\n\n<li>Vajuta \"Save\"<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-1024x605.png\" alt=\"\" class=\"wp-image-1932\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-1024x605.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-300x177.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-768x453.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-1536x907.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.39.30-2048x1209.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Seadista \"Trades\"<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"Sections\" listist vajuta \"Trades\" ja vali k\u00f5ik.\n<ol class=\"wp-block-list\">\n<li>Choose only &#8220;Execution&#8221;<\/li>\n\n\n\n<li>Vajuta \"Select all\"<\/li>\n\n\n\n<li>Vajuta \"Save\"<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"616\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-1024x616.png\" alt=\"\" class=\"wp-image-1933\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-1024x616.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-300x180.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-768x462.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-1536x924.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.40.10-2048x1232.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Seadista \"Forex Balances\"<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"Sections\" nimekirjast vali ainult \"Forex Balances\"\n<ol class=\"wp-block-list\">\n<li>Vali ainult \"Summary\"<\/li>\n\n\n\n<li>Vajuta \"Select all\"<\/li>\n\n\n\n<li>Vajuta \"Save\"<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"487\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-1024x487.png\" alt=\"\" class=\"wp-image-3905\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-1024x487.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-300x143.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-768x365.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-1536x731.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-2048x974.png 2048w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-18x9.png 18w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-10-15-at-20.55.10-360x171.png 360w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&nbsp;<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>T\u00e4ida \"Delivery Configurations\" ja \"General Configuration\"<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vali formaat: XML<\/li>\n\n\n\n<li>Vali periood: Last 30 Calendar Days.<\/li>\n\n\n\n<li>M\u00e4\u00e4ra Date Format: yyyy-MM-dd.<\/li>\n\n\n\n<li>M\u00e4\u00e4ra Time Format: HH:mm:ss.<\/li>\n\n\n\n<li>M\u00e4\u00e4ra Date\/Time Separator: ; (semikoolon)<\/li>\n\n\n\n<li>K\u00f5ik teised valikud: \"No\"<\/li>\n\n\n\n<li>Vajuta \"Save\"<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"622\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-1024x622.png\" alt=\"\" class=\"wp-image-1935\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-1024x622.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-300x182.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-768x466.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-1536x933.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.44.00-2048x1244.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Leia ja salvesta Query ID<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Raporti loetelus kl\u00f5psa loodud raporti nimel.\nN\u00e4ed v\u00e4lja nimega Query ID.\nKopeeri see number Portfellow\u2019sse.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"553\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-1024x553.png\" alt=\"\" class=\"wp-image-1936\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-1024x553.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-300x162.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-768x415.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-1536x829.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-29-at-20.42.35-2048x1105.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mine Flex Web Services seadistustesse<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Flex Queries lehelt kl\u00f5psa hammasratta ikoonil Flex Web Service Configuration k\u00f5rval.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"432\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-1024x432.jpg\" alt=\"\" class=\"wp-image-1985\" style=\"width:841px;height:auto\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-1024x432.jpg 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-300x127.jpg 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-768x324.jpg 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-1536x649.jpg 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Click-here-2048x865.jpg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Salvesta Current Token<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Avanenud aknas m\u00e4rgi \"Flex Web Services Status\" linnukesega.<\/li>\n\n\n\n<li>Vali 1 Year kehtivuse perioodiks.<\/li>\n\n\n\n<li>J\u00e4ta IP address v\u00e4li t\u00fchjaks.<\/li>\n\n\n\n<li>Kl\u00f5psa \"Generate New Token\".<\/li>\n\n\n\n<li>Vajadusel kl\u00f5psa \"Save\".<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"367\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-1024x367.png\" alt=\"\" class=\"wp-image-1987\" srcset=\"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-1024x367.png 1024w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-300x108.png 300w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-768x276.png 768w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-1536x551.png 1536w, https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-07-at-17.34.55-2048x735.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Kinnita Current Tokeni salevstus<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kui Activation Period on liiga l\u00fchike, kl\u00f5psa \"Generate New Token\" ja vali kehtivusajaks 1 year.\nKui eelmine token hakkab umbes aasta p\u00e4rast aeguma, tuleb see nupp uuesti vajutada.<\/li>\n\n\n\n<li>Kopeeri Current Token v\u00e4\u00e4rtus Portfellow\u2019sse.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sisesta Flex Query ID ja Token vastavatesse v\u00e4ljadele Portfellow\u2019s.<\/strong><\/h3>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Getting Query Id and Token Start creating new Flex Query Report Configure &#8220;Cash Transactions&#8221; Configure &#8220;Trades&#8221; Configure &#8220;Forex Balances&#8221; &nbsp; Fill &#8220;Delivery Configurations&#8221; and &#8220;General Configuration&#8221; Get and save the Query ID Go to Flex Web Services settings Enable Flex Web Services Save the Current Token Enter the Flex Query ID and Token to Portfellow<\/p>","protected":false},"author":1,"featured_media":2304,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"doc_category":[23],"doc_tag":[],"class_list":["post-2372","docs","type-docs","status-publish","has-post-thumbnail","hentry","doc_category-getting-started"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Getting Query Id and Token Go to Interactive Brokers homepage Click &quot;Log in&quot; and then click &quot;Portal Login&quot; Go to Flex Queries page From the menu choose: Reporting -&gt; Flex Queries Start creating new Flex Query Report Click on the &quot;+&quot; icon, to start configuring the report Configure &quot;Cash Transactions&quot; From the &quot;Sections&quot; list, click on\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Portfellow\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Portfellow - Investment Portfolio Tracker\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow\" \/>\n\t\t<meta property=\"og:description\" content=\"Getting Query Id and Token Go to Interactive Brokers homepage Click &quot;Log in&quot; and then click &quot;Portal Login&quot; Go to Flex Queries page From the menu choose: Reporting -&gt; Flex Queries Start creating new Flex Query Report Click on the &quot;+&quot; icon, to start configuring the report Configure &quot;Cash Transactions&quot; From the &quot;Sections&quot; list, click on\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-05-30T20:18:23+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-02-04T16:36:09+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Getting Query Id and Token Go to Interactive Brokers homepage Click &quot;Log in&quot; and then click &quot;Portal Login&quot; Go to Flex Queries page From the menu choose: Reporting -&gt; Flex Queries Start creating new Flex Query Report Click on the &quot;+&quot; icon, to start configuring the report Configure &quot;Cash Transactions&quot; From the &quot;Sections&quot; list, click on\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www2.portfellow.com\\\/et\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/#listItem\",\"name\":\"Help\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/#listItem\",\"position\":2,\"name\":\"Help\",\"item\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help-category\\\/getting-started\\\/#listItem\",\"name\":\"Getting started\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help-category\\\/getting-started\\\/#listItem\",\"position\":3,\"name\":\"Getting started\",\"item\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help-category\\\/getting-started\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#listItem\",\"name\":\"How To Set Up Interactive Brokers&#8217; Automatic Import?\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/#listItem\",\"name\":\"Help\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#listItem\",\"position\":4,\"name\":\"How To Set Up Interactive Brokers&#8217; Automatic Import?\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help-category\\\/getting-started\\\/#listItem\",\"name\":\"Getting started\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/#organization\",\"name\":\"Portfellow\",\"description\":\"Investment Portfolio Tracker\",\"url\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/author\\\/admin\\\/\",\"name\":\"Portfellow\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#webpage\",\"url\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/\",\"name\":\"How To Set Up Interactive Brokers\\u2019 Automatic Import? - Portfellow\",\"description\":\"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\",\"inLanguage\":\"et\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/author\\\/admin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www2.portfellow.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/Portfellow-blog-2.png\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#mainImage\",\"width\":1280,\"height\":720},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/help\\\/kuidas-seadistada-interactive-brokers-automaatne-import\\\/#mainImage\"},\"datePublished\":\"2024-05-30T20:18:23+00:00\",\"dateModified\":\"2025-02-04T16:36:09+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/#website\",\"url\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/\",\"name\":\"Portfellow\",\"description\":\"Investment Portfolio Tracker\",\"inLanguage\":\"et\",\"publisher\":{\"@id\":\"https:\\\/\\\/www2.portfellow.com\\\/et\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow","description":"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","canonical_url":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et#listItem","position":1,"name":"Home","item":"https:\/\/www2.portfellow.com\/et","nextItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help\/#listItem","name":"Help"}},{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help\/#listItem","position":2,"name":"Help","item":"https:\/\/www2.portfellow.com\/et\/help\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/#listItem","name":"Getting started"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/#listItem","position":3,"name":"Getting started","item":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#listItem","name":"How To Set Up Interactive Brokers&#8217; Automatic Import?"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help\/#listItem","name":"Help"}},{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#listItem","position":4,"name":"How To Set Up Interactive Brokers&#8217; Automatic Import?","previousItem":{"@type":"ListItem","@id":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/#listItem","name":"Getting started"}}]},{"@type":"Organization","@id":"https:\/\/www2.portfellow.com\/et\/#organization","name":"Portfellow","description":"Investment Portfolio Tracker","url":"https:\/\/www2.portfellow.com\/et\/"},{"@type":"Person","@id":"https:\/\/www2.portfellow.com\/et\/author\/admin\/#author","url":"https:\/\/www2.portfellow.com\/et\/author\/admin\/","name":"Portfellow"},{"@type":"WebPage","@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#webpage","url":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/","name":"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow","description":"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","inLanguage":"et","isPartOf":{"@id":"https:\/\/www2.portfellow.com\/et\/#website"},"breadcrumb":{"@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#breadcrumblist"},"author":{"@id":"https:\/\/www2.portfellow.com\/et\/author\/admin\/#author"},"creator":{"@id":"https:\/\/www2.portfellow.com\/et\/author\/admin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www2.portfellow.com\/wp-content\/uploads\/2024\/04\/Portfellow-blog-2.png","@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#mainImage","width":1280,"height":720},"primaryImageOfPage":{"@id":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/#mainImage"},"datePublished":"2024-05-30T20:18:23+00:00","dateModified":"2025-02-04T16:36:09+00:00"},{"@type":"WebSite","@id":"https:\/\/www2.portfellow.com\/et\/#website","url":"https:\/\/www2.portfellow.com\/et\/","name":"Portfellow","description":"Investment Portfolio Tracker","inLanguage":"et","publisher":{"@id":"https:\/\/www2.portfellow.com\/et\/#organization"}}]},"og:locale":"et_EE","og:site_name":"Portfellow - Investment Portfolio Tracker","og:type":"article","og:title":"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow","og:description":"Getting Query Id and Token Go to Interactive Brokers homepage Click &quot;Log in&quot; and then click &quot;Portal Login&quot; Go to Flex Queries page From the menu choose: Reporting -&gt; Flex Queries Start creating new Flex Query Report Click on the &quot;+&quot; icon, to start configuring the report Configure &quot;Cash Transactions&quot; From the &quot;Sections&quot; list, click on","og:url":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/","article:published_time":"2024-05-30T20:18:23+00:00","article:modified_time":"2025-02-04T16:36:09+00:00","twitter:card":"summary_large_image","twitter:title":"How To Set Up Interactive Brokers\u2019 Automatic Import? - Portfellow","twitter:description":"Getting Query Id and Token Go to Interactive Brokers homepage Click &quot;Log in&quot; and then click &quot;Portal Login&quot; Go to Flex Queries page From the menu choose: Reporting -&gt; Flex Queries Start creating new Flex Query Report Click on the &quot;+&quot; icon, to start configuring the report Configure &quot;Cash Transactions&quot; From the &quot;Sections&quot; list, click on"},"aioseo_meta_data":{"post_id":"2372","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-09-05 09:00:10","updated":"2025-06-04 08:16:28","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www2.portfellow.com\/et\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www2.portfellow.com\/et\/help\/\" title=\"Help\">Help<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/\" title=\"Getting started\">Getting started<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow To Set Up Interactive Brokers\u2019 Automatic Import?\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www2.portfellow.com\/et"},{"label":"Help","link":"https:\/\/www2.portfellow.com\/et\/help\/"},{"label":"Getting started","link":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/"},{"label":"How To Set Up Interactive Brokers&#8217; Automatic Import?","link":"https:\/\/www2.portfellow.com\/et\/help\/kuidas-seadistada-interactive-brokers-automaatne-import\/"}],"year_month":"2026-07","word_count":301,"total_views":"2875","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Portfellow","author_nicename":"admin","author_url":"https:\/\/www2.portfellow.com\/et\/author\/admin\/"},"doc_category_info":[{"term_name":"Getting started","term_url":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/"}],"doc_tag_info":[],"jetpack_sharing_enabled":true,"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/comments?post=2372"}],"version-history":[{"count":3,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2372\/revisions"}],"predecessor-version":[{"id":4277,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2372\/revisions\/4277"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/media\/2304"}],"wp:attachment":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/media?parent=2372"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/doc_category?post=2372"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/doc_tag?post=2372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}