{"id":51638,"date":"2020-07-09T09:24:26","date_gmt":"2020-07-09T13:24:26","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=51638"},"modified":"2023-01-20T14:56:41","modified_gmt":"2023-01-20T19:56:41","slug":"get-started-with-ibkr-api-rtd-server-for-excel","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/","title":{"rendered":"Get Started with IBKR API RTD Server for Excel"},"content":{"rendered":"\n
\"IBKR<\/figure>\n\n\n\n

 Learn how to use IBKR TWS Excel APIs, featuring the RealTimeData Server with our GitHub Reference Guide<\/a>. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows our clients to request real-time market data from IBKR\u2019s Trader Workstation (TWS) via our API, as well as Microsoft Excel. RTD technology is open source and thus very popular. It is a newer technology compared to Excel DDE and easier to use compared to VB-built ActiveX. Take a look at this comparison of Excel API features:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Image Source: IBKR API Support Team<\/em><\/p>\n\n\n\n

Follow the below installation instructions:<\/p>\n\n\n\n

  1. Install the IBKR API from here https:\/\/interactivebrokers.github.io\/<\/a>.
    The RTD Server is built in C# so the source file will be installed in the TWS API\/source\/CSharpClient\/TwsRtdServer <\/em>directory.
     <\/li>
  2. The latest TWS from here: https:\/\/www.interactivebrokers.com\/en\/index.php?f=16040<\/a><\/li><\/ol>\n\n\n\n
    1. Excel RTD Server API serves as a dynamic link library that helps algo traders get real-time market data from TWS via the API using Microsoft Excel. Explore this setup and requirements  https:\/\/interactivebrokers.github.io\/tws-api\/tws_rtd_server.html<\/a><\/li><\/ol>\n\n\n\n

      A sample RTD spreadsheet is provided within the API installation directory. Visit the GitHub page for details: https:\/\/interactivebrokers.github.io\/tws-api\/rtd_examples.html<\/a><\/p>\n\n\n\n

      Important to remember is that API installer for RTD Server is compatible with 64-bit Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"

      The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open source and thus very popular. Learn how to use it with our GitHub.<\/p>\n","protected":false},"author":90,"featured_media":49410,"comment_status":"closed","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[345,346,340,343,338,341,352,344],"tags":[851,594,854,5878,865,575,7967],"contributors-categories":[13576],"class_list":{"0":"post-51638","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-c-sharp-development","8":"category-c-plusplus-development","9":"category-api-development","10":"category-programing-languages","11":"category-ibkr-quant-news","12":"category-quant-development","13":"category-quant-north-america","14":"category-quant-regions","15":"tag-algo-trading","16":"tag-c-2","17":"tag-cplusplus","18":"tag-excel","19":"tag-github","20":"tag-ibkr-api","21":"tag-realtime-data-server","22":"contributors-categories-interactive-brokers"},"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"\nGet Started with IBKR API RTD Server for Excel | IBKR Quant<\/title>\n<meta name=\"description\" content=\"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/51638\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get Started with IBKR API RTD Server for Excel | IBKR Quant Blog\" \/>\n<meta property=\"og:description\" content=\"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open source and thus very popular.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-09T13:24:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-20T19:56:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"550\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"IBKR Quant\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"IBKR Quant\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\\\/\\\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"NewsArticle\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/#article\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/\"\n\t },\n\t \"author\": {\n\t \"name\": \"IBKR Quant\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/8279da2435a7846d83a358a25c49b8f4\"\n\t },\n\t \"headline\": \"Get Started with IBKR API RTD Server for Excel\",\n\t \"datePublished\": \"2020-07-09T13:24:26+00:00\",\n\t \"dateModified\": \"2023-01-20T19:56:41+00:00\",\n\t \"mainEntityOfPage\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/\"\n\t },\n\t \"wordCount\": 245,\n\t \"publisher\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/06\\\/api-touch-1.jpg\",\n\t \"keywords\": [\n\t \"Algo Trading\",\n\t \"C#\",\n\t \"C++\",\n\t \"Excel\",\n\t \"GitHub\",\n\t \"IBKR API\",\n\t \"RealTime Data Server\"\n\t ],\n\t \"articleSection\": [\n\t \"C# Development\",\n\t \"C++ Development\",\n\t \"IBKR API Development\",\n\t \"Programming Languages\",\n\t \"Quant\",\n\t \"Quant Development\",\n\t \"Quant North America\",\n\t \"Quant Regions\"\n\t ],\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/\",\n\t \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/\",\n\t \"name\": \"Get Started with IBKR API RTD Server for Excel | IBKR Quant Blog\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\"\n\t },\n\t \"primaryImageOfPage\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/#primaryimage\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/06\\\/api-touch-1.jpg\",\n\t \"datePublished\": \"2020-07-09T13:24:26+00:00\",\n\t \"dateModified\": \"2023-01-20T19:56:41+00:00\",\n\t \"description\": \"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open source and thus very popular.\",\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/ibkr-quant-news\\\/get-started-with-ibkr-api-rtd-server-for-excel\\\/#primaryimage\",\n\t \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/06\\\/api-touch-1.jpg\",\n\t \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/06\\\/api-touch-1.jpg\",\n\t \"width\": 900,\n\t \"height\": 550,\n\t \"caption\": \"IBKR API\"\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\",\n\t \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t \"name\": \"IBKR Campus US\",\n\t \"description\": \"Financial Education from Interactive Brokers\",\n\t \"publisher\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t },\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"Organization\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\",\n\t \"name\": \"Interactive Brokers\",\n\t \"alternateName\": \"IBKR\",\n\t \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t \"logo\": {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\n\t \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t \"width\": 669,\n\t \"height\": 669,\n\t \"caption\": \"Interactive Brokers\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\"\n\t },\n\t \"publishingPrinciples\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/about-ibkr-campus\\\/\",\n\t \"ethicsPolicy\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/cyber-security-notice\\\/\"\n\t },\n\t {\n\t \"@type\": \"Person\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/8279da2435a7846d83a358a25c49b8f4\",\n\t \"name\": \"IBKR Quant\",\n\t \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/ibkrquant\\\/\"\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Get Started with IBKR API RTD Server for Excel | IBKR Quant","description":"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/51638\/","og_locale":"en_US","og_type":"article","og_title":"Get Started with IBKR API RTD Server for Excel | IBKR Quant Blog","og_description":"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open source and thus very popular.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/","og_site_name":"IBKR Campus US","article_published_time":"2020-07-09T13:24:26+00:00","article_modified_time":"2023-01-20T19:56:41+00:00","og_image":[{"width":900,"height":550,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","type":"image\/jpeg"}],"author":"IBKR Quant","twitter_card":"summary_large_image","twitter_misc":{"Written by":"IBKR Quant","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/#article","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/"},"author":{"name":"IBKR Quant","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/8279da2435a7846d83a358a25c49b8f4"},"headline":"Get Started with IBKR API RTD Server for Excel","datePublished":"2020-07-09T13:24:26+00:00","dateModified":"2023-01-20T19:56:41+00:00","mainEntityOfPage":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/"},"wordCount":245,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","keywords":["Algo Trading","C#","C++","Excel","GitHub","IBKR API","RealTime Data Server"],"articleSection":["C# Development","C++ Development","IBKR API Development","Programming Languages","Quant","Quant Development","Quant North America","Quant Regions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/","url":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/","name":"Get Started with IBKR API RTD Server for Excel | IBKR Quant Blog","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/#primaryimage"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","datePublished":"2020-07-09T13:24:26+00:00","dateModified":"2023-01-20T19:56:41+00:00","description":"The IBKR API \u2013 RTD Server for Excel is a dynamic link library that allows clients to request real-time market data from TWS. RTD technology is open source and thus very popular.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/ibkr-quant-news\/get-started-with-ibkr-api-rtd-server-for-excel\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","width":900,"height":550,"caption":"IBKR API"},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.com\/campus\/#website","url":"https:\/\/ibkrcampus.com\/campus\/","name":"IBKR Campus US","description":"Financial Education from Interactive Brokers","publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.com\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ibkrcampus.com\/campus\/#organization","name":"Interactive Brokers","alternateName":"IBKR","url":"https:\/\/ibkrcampus.com\/campus\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","width":669,"height":669,"caption":"Interactive Brokers"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/"},"publishingPrinciples":"https:\/\/www.interactivebrokers.com\/campus\/about-ibkr-campus\/","ethicsPolicy":"https:\/\/www.interactivebrokers.com\/campus\/cyber-security-notice\/"},{"@type":"Person","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/8279da2435a7846d83a358a25c49b8f4","name":"IBKR Quant","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/ibkrquant\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/06\/api-touch-1.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/51638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/users\/90"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=51638"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/51638\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/49410"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=51638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=51638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=51638"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=51638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}