{"id":26329,"date":"2021-07-27T10:34:20","date_gmt":"2021-07-27T14:34:20","guid":{"rendered":"https:\/\/wealthica.com\/blog\/?p=26329"},"modified":"2021-07-29T10:39:34","modified_gmt":"2021-07-29T14:39:34","slug":"interactive-brokers-api-guide","status":"publish","type":"post","link":"https:\/\/wealthica.com\/blog\/interactive-brokers-api-guide\/","title":{"rendered":"Why you Don\u2019t Need an Interactive Brokers API Documentation"},"content":{"rendered":"\n<p>Interactive Brokers is easily one of the biggest discount brokers out there. But even as a customer, you are probably diversified across many other financial institutions too.<\/p>\n\n\n\n<p><strong>So, an Interactive Brokers API guide would hypothetically help you connect your brokerage account with a third-party app.<\/strong> But that would mean you would still need to find a way to also connect that app with your bank and other brokerage accounts. Frustrating, isn\u2019t it?<\/p>\n\n\n\n<p>Well, here\u2019s some good news: Interactive Brokers <em>does <\/em>support API integration.<\/p>\n\n\n\n<p>But here\u2019s the better news\u2026 You don\u2019t need an Interactive Brokers API documentation to do what you want. There\u2019s an easier but still free way called <strong>Wealthica<\/strong>.<\/p>\n\n\n\n<p><strong>Wealthica is a free third-party app that allows you to connect your IB data to it, along with brokerage and banking information of other accounts.<\/strong> This way, you\u2019ll be able to view all of your holdings, transactions, and assets like cash in one place. No more signing in to each one of your brokerage and bank accounts.<\/p>\n\n\n\n<p>And the greatest thing? The process will only take a few minutes (including time spent going through this guide).<\/p>\n\n\n\n<p>In this article we will:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Help you understand what API technology allows you to do with your IB account,<\/strong><strong><br><\/strong><\/li><li><strong>Illustrate how Wealthica uses it to connect your IB account with it,<\/strong><strong><br><\/strong><\/li><li><strong>Show you how to connect your IB account with Wealthica, and<\/strong><strong><br><\/strong><\/li><li><strong>Guide you through the process of exporting your IB data to a spreadsheet.<\/strong><\/li><\/ul>\n\n\n\n<p>If that sounds good, let\u2019s get started right away!<\/p>\n\n\n\n<div id=\"rtoc-mokuji-wrapper\" class=\"rtoc-mokuji-content frame2 preset1 animation-fade rtoc_open default\" data-id=\"26329\" data-theme=\"Kicker Child\">\n\t\t\t<div id=\"rtoc-mokuji-title\" class=\" rtoc_left\">\n\t\t\t<button class=\"rtoc_open_close rtoc_open\"><\/button>\n\t\t\t<span>Contents<\/span>\n\t\t\t<\/div><ol class=\"rtoc-mokuji decimal_ol level-1\"><li class=\"rtoc-item\"><a href=\"#rtoc-1\">Easiest and Fastest Interactive Brokers Web API Integration<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-2\">How To Use Wealthica to Securely Access your Interactive Brokers Investment Data<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-3\">How To Export your IB Data to A Spreadsheet Using Wealthica<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-4\">What\u2019s Next?<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-5\">Frequent Questions about Interactive Brokers API and Wealthica<\/a><ul class=\"rtoc-mokuji mokuji_ul level-2\"><li class=\"rtoc-item\"><a href=\"#rtoc-6\">How Can I export all of my Interactive Brokers holdings and transactions to a spreadsheet?<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-7\">Does Wealthica Use Interactive Brokers API to access your data?<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-8\">Can I see investment data from other brokerage accounts along with Interactive Brokers information?<\/a><\/li><\/ul><\/li><\/ol><\/div><h2 id=\"rtoc-1\"  class=\"wp-block-heading\">Easiest and Fastest Interactive Brokers Web API Integration<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"320\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-1024x320.png\" alt=\"interactive brokers web api\" class=\"wp-image-26338\" srcset=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-1024x320.png 1024w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-300x94.png 300w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-768x240.png 768w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-1536x480.png 1536w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W-1200x375.png 1200w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/IB-API-W.png 1588w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/stockchase.com\/discover\/questrade-vs-competitors-review\/#interactive-brokers-vs-questrade\" class=\"rank-math-link\" rel=\"noopener\">Interactive Brokers<\/a> is one of the few financial institutions that support <a href=\"https:\/\/tray.io\/blog\/what-is-an-api-integration-for-non-technical-people\" rel=\"noopener\">API integration<\/a>. This way, it\u2019s both easy <em>and <\/em>secure to access your account data through our third-party app, <strong>Wealthica<\/strong>.<\/p>\n\n\n\n<p><strong>The benefit of doing so is that Wealthica already supports connection with more than 170 financial institutions.<\/strong> That means that you can have all of your investment and asset data in one place.<\/p>\n\n\n\n<p>The idea is that, besides saving tons of time, you will be able to make better financial decisions. Just imagine how easy it can be. At any time, getting a complete picture of your financial situation will be a few clicks (or taps) away.<\/p>\n\n\n\n<p>After connecting Interactive Brokers to Wealthica, you will be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Sync your balance, holdings, and transactions each day,<\/strong><strong><br><\/strong><\/li><li><strong>Consolidate your IB data with investment data of other brokerage accounts you may have, and<\/strong><strong><br><\/strong><\/li><li><strong>Export your holdings and transactions to a spreadsheet (Google Sheets or Microsoft Excel).<\/strong><\/li><\/ul>\n\n\n\n<p>But before you\u2019re able to do all that, you will need to first connect your IB account to&nbsp;<\/p>\n\n\n\n<p>Wealthica. Let\u2019s see how&#8230;<\/p>\n\n\n\n<h2 id=\"rtoc-2\"  class=\"wp-block-heading\">How To Use Wealthica to Securely Access your Interactive Brokers Investment Data<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"320\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-1024x320.png\" alt=\"interactive brokers api guide\" class=\"wp-image-26332\" srcset=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-1024x320.png 1024w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-300x94.png 300w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-768x240.png 768w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-1536x480.png 1536w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica-1200x375.png 1200w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/Interactive-Brokers-Feature-Wealthica.png 1588w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As you probably already know, an API (Application Programming Interface) is a tool that allows two apps to communicate with each other<\/p>\n\n\n\n<p><strong>In the case of Interactive Brokers, however, you can generate a report called Flex Query (or Flex Report). This will be basically used as an API to access your data through Wealthica.<\/strong> The advantage here is that you will be able to <em>choose <\/em>what data will be available for you to access through Wealthica.<\/p>\n\n\n\n<p>More specifically, to connect Interactive Brokers to Wealthica, you will need to provide two things:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>The Flex Query Token<\/strong><strong><br><\/strong><\/li><li><strong>The Flex Query ID<\/strong><\/li><\/ul>\n\n\n\n<p>The token can be easily generated by logging in to your Interactive Brokers account and enabling the Flex Web Service. You could <a href=\"https:\/\/help.wealthica.com\/help\/how-to-connect-ib-interactive-brokers-and-configure-the-flex-report\">follow our guide<\/a> to see how to do this, step by step.<\/p>\n\n\n\n<p>As for the ID, you will be able to get it after you create a Flex Report through your Interactive Brokers account as well. <a href=\"https:\/\/help.wealthica.com\/help\/how-to-connect-ib-interactive-brokers-and-configure-the-flex-report\">This guide will help you do that too.<\/a><\/p>\n\n\n\n<p>After you get both the Flex Query Token and ID, all you need to do is go to <a href=\"https:\/\/wealthica.com\/\">Wealthica<\/a> and use them to add Interactive Brokers to your account. Here\u2019s how:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>First, <\/strong><a href=\"https:\/\/app.wealthica.com\/sign-up\"><strong>sign up for free<\/strong><\/a><strong> if you haven\u2019t done so already (or <\/strong><a href=\"https:\/\/app.wealthica.com\/login?lang=en\"><strong>log in<\/strong><\/a><strong> if you already have an account).<br><\/strong><\/li><li><strong>Once you\u2019re in the dashboard, click on the Add button (+ Add) located in the top right corner<br><\/strong><\/li><li><strong>Then, click on the Banks &amp; Brokerage section, type \u201cInteractive Brokers\u201d, and hit Enter<br><\/strong><\/li><li><strong>Last, click on Next, paste the Token along with the ID, and then click Next again<\/strong><\/li><\/ul>\n\n\n\n<p>And that was it! Not so hard, right? If you still need help, <a href=\"https:\/\/help.wealthica.com\/help\/how-to-connect-ib-interactive-brokers-and-configure-the-flex-report\">here\u2019s our more detailed guide with screenshots throughout the process<\/a>.<\/p>\n\n\n\n<p>As we have promised, you can also export your IB data like transactions and holdings to a spreadsheet.<\/p>\n\n\n\n<p>Let us show you how, exactly&#8230;<\/p>\n\n\n\n<h2 id=\"rtoc-3\"  class=\"wp-block-heading\">How To Export your IB Data to A Spreadsheet Using Wealthica<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"320\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-1024x320.png\" alt=\"flex report\" class=\"wp-image-26340\" srcset=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-1024x320.png 1024w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-300x94.png 300w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-768x240.png 768w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-1536x480.png 1536w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4-1200x375.png 1200w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/4.png 1588w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once you have signed up to Wealthica, click on Power-Ups from the dashboard and then on All Power-Ups.<\/p>\n\n\n\n<p><strong>You can either choose the Google Sheets Export add-on from the Wealthica section or the Microsoft Excel Export add-on from the Third-Party section.<\/strong><\/p>\n\n\n\n<p>If you go with Google Sheets, then you will need to authorize Wealthica to access your Google account first.<\/p>\n\n\n\n<p>And that\u2019s it! Once you\u2019re ready to create a spreadsheet you will have the option to export your positions, your transactions, or even both.<\/p>\n\n\n\n<h2 id=\"rtoc-4\"  class=\"wp-block-heading\">What\u2019s Next?<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"320\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-1024x320.png\" alt=\"interactive brokers api\" class=\"wp-image-26343\" srcset=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-1024x320.png 1024w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-300x94.png 300w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-768x240.png 768w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-1536x480.png 1536w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1-1200x375.png 1200w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/07\/1.png 1588w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As you can see, there\u2019s no need for an Interactive Brokers API documentation. If you\u2019re looking for an easy way to have all of your accounts in one place (including your brokerage account), then Wealthica is the obvious way to go.<\/p>\n\n\n\n<p>By carefully following the instructions outlined above, you will have connected your Interactive Brokers account to Wealthica in a matter of minutes.<\/p>\n\n\n\n<p><strong>Most importantly, you\u2019ll be able to securely access your portfolio and balance without signing in to Interactive Brokers every time. And for free!<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/app.wealthica.com\/sign-up\"><strong>Sign up to Wealthica and simplify your financial life today&#8230;<\/strong><\/a><\/p>\n\n\n\n<h2 id=\"rtoc-5\"  class=\"wp-block-heading\">Frequent Questions about Interactive Brokers API and Wealthica<\/h2>\n\n\n\n<h3 id=\"rtoc-6\"  style=\"text-align:left; font-weight:bold;\">How Can I export all of my Interactive Brokers holdings and transactions to a spreadsheet?<\/h3>\n\n\n\n<p>You can either use Wealthica&#8217;s Google Sheets Export Power-Up or the Microsoft Excel Export add-on. To do this, sign up to (or sign in) Wealthica, use our guide above to connect your Interactive Brokers account to Wealthica, and from your dashboard, click on Power-Ups to access both of those add-ons.<\/p>\n\n\n\n<h3 id=\"rtoc-7\"  style=\"text-align:left; font-weight:bold;\">Does Wealthica Use Interactive Brokers API to access your data?<\/h3>\n\n\n\n<p>Wealthica will use the flex report tokens that can be generated through your IB account to enable a read-only access to your IB data. The advantage that this connection provides is that you will be able to choose what kind of data Wealthica can read by configuring the broker&#8217;s flex query.<\/p>\n\n\n\n<h3 id=\"rtoc-8\"  style=\"text-align:left; font-weight:bold;\">Can I see investment data from other brokerage accounts along with Interactive Brokers information?<\/h3>\n\n\n\n<p>Yes! Once you sign up and connect Interactive Brokers to Wealthica, you can simply click on &#8220;Add&#8221; from your dashboard and then type in the institution&#8217;s name to select it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your search for an Interactive Brokers API documentation stops here. This is how you can have your balance, holdings, and transactions history in one place&#8230;<\/p>\n","protected":false},"author":13,"featured_media":26337,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[13],"tags":[2384,684],"class_list":["post-26329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-help-and-how-to","tag-interactive-brokers-api","tag-wealthica"],"acf":[],"_links":{"self":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/comments?post=26329"}],"version-history":[{"count":14,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26329\/revisions"}],"predecessor-version":[{"id":26520,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26329\/revisions\/26520"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/media\/26337"}],"wp:attachment":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/media?parent=26329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/categories?post=26329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/tags?post=26329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}