{"id":199080,"date":"2022-07-20T17:30:00","date_gmt":"2022-07-20T17:30:00","guid":{"rendered":"https:\/\/ibkrcampus.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/"},"modified":"2024-01-02T17:53:45","modified_gmt":"2024-01-02T17:53:45","slug":"tws-baskettrader-part-2-upload-a-basket-2","status":"publish","type":"trading-lessons","link":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/","title":{"rendered":"TWS BasketTrader Part 2 \u2013 Upload a Basket"},"content":{"rendered":"

In this lesson, investors will create a basket on a spreadsheet, upload it to the BasketTrader, and execute the orders. The video will also go through how to export a basket onto a spreadsheet, modify the orders, load back into the BasketTrader and execute the orders.<\/p>\n

An investor can create a basket file in excel from scratch using the correct headers found in the TWS user guide in the Basket Field section under BasketTrader or create a template by manually creating a basket file in TWS and exporting it. In the basket file template, the investor can use examples of the instruments they plan on trading to have the correct headers populate.<\/p>\n

First, we\u2019ll go over how to export a basket file from BasketTrader and use it as a template. We\u2019ve pre-populated the BasketTrader with a stock, option, future, and forex position. Click the file in the upper left-hand corner and click \u201cSave Basket.\u201d Choose the directory and name the file. We can call this one Basket Template. A confirmation box will appear telling you the file has been saved.<\/p>\n

\"\"Now, go into Excel and open the file we just saved. It\u2019s important to note that search criteria can change from Excel to all files since the original template was saved as a .CSV. Once the file is opened, are the appropriate headers will be at the top of each column with some rows being populated for certain instruments and empty for others when they don\u2019t apply, for example the Strike column is blank for everything but options. It is important to note that the order of the columns do not matter when creating a spreadsheet. If the correct headers are entered, then BasketTrader will accept the spreadsheet and create a basket from it.<\/p>\n

\"\"The investor can now use the instruments entered in the spreadsheet as a template for any orders they would like to create.<\/p>\n

First, save the template under a different name, lets choose BasketTrades1. It is important to note that the file should be saved as a .CSV, not an Excel file.<\/p>\n

Now enter a stock trade. Looking at the template and using the existing stock trade as a guide for which columns need to be filled in. Action, Quantity, Symbol, Security Type (SecType), Exchange, Currency, Time in Force, Order Type, Limit Price, Basket Tag, Account, Order Reference (OrderRef), and whether or not we want it to trade outside regular trading hours (OutsideRth).<\/p>\n

Next enter an option trade and fill in the columns for: Action, Quantity, Symbol, Security Type (SecType), Exchange, Currency, Time in Force, Order Type, Limit Price, Basket Tag, Account, Order Reference (OrderRef), Last Trading Day Or Contract Month, Strike, and Right.<\/p>\n

Finally add a Futures trade and fill in the columns for: Action, Quantity, Symbol, Security Type (SecType), Exchange, Currency, Time in Force, Order Type, Select market order so we don\u2019t have to populate Limit Price, Basket Tag, Account, Order Reference (OrderRef), Last Trading Day Or Contract Month, DivPrt, and Multiplier.<\/p>\n

When satisfied with the orders entered delete the lines from the template and save the spreadsheet.<\/p>\n

Next go back into BasketTrader and upload the file. Click on the plus sign to open a new BasketTrader window. In the top left-hand corner click on Browse and look for the spreadsheet file.<\/p>\n

\"\"Select the file and click Open in the lower right-hand corner of the pop-up box. The Round Order Sizes configuration box appears, make the appropriate selection.  The investor can choose to click on the white square next to \u201cremember your settings\u201d if they prefer and the box will no longer appear. When ready, click OK to load the basket. An information box will appear asking you to select whether this is or is not a Program Index Arbitrage Trade, pick the appropriate answer and click ok. The basket is now loaded and ready to be sent.<\/p>\n

Once the orders have populated the Order tab they can be adjusted. When the investor is ready to send the orders click Transmit and they will be sent to the appropriate exchanges.<\/p>\n

BasketTrader allows investors to adjust the multiplier as well to be applied to the file uploaded.  Open up another tab, change the multiplier from 1 to 2, click load and click on the BasketTrades1 file and the pop-up boxes and it is now showing double the total quantity for each order.<\/p>\n

\"\"BasketTrader is a versatile tool that enables the investor to submit multiple trades at once either by creating the basket in TWS or outside of TWS and uploading it.<\/p>\n

BasketTrader User Guide<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file. BasketTrader is accessible through Classic and Mosaic and is used to manage groups of orders.<\/p>\n","protected":false},"author":899,"featured_media":203586,"parent":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"contributors-categories":[149],"traders-academy":[102,103,105],"class_list":{"0":"post-199080","1":"trading-lessons","2":"type-trading-lessons","3":"status-publish","4":"has-post-thumbnail","6":"contributors-categories-interactive-brokers","7":"traders-academy-advanced-trading","8":"traders-academy-level","9":"traders-academy-trading-lesson"},"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"\nArchives | Traders' Academy | IBKR Campus<\/title>\n<meta name=\"description\" content=\"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.\" \/>\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.eu\/campus\/wp-json\/wp\/v2\/trading-lessons\/199080\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TWS BasketTrader Part 2 \u2013 Upload a Basket\" \/>\n<meta property=\"og:description\" content=\"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus EU\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-02T17:53:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"TWS BasketTrader Part 2 \u2013 Upload a Basket\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\\\/\\\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/\",\n\t \"url\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/\",\n\t \"name\": \"TWS BasketTrader Part 2 \u2013 Upload a Basket\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.eu\\\/campus\\\/#website\"\n\t },\n\t \"primaryImageOfPage\": {\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/#primaryimage\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/mqdefault-2.jpg\",\n\t \"datePublished\": \"2022-07-20T17:30:00+00:00\",\n\t \"dateModified\": \"2024-01-02T17:53:45+00:00\",\n\t \"description\": \"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/#primaryimage\",\n\t \"url\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/mqdefault-2.jpg\",\n\t \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/mqdefault-2.jpg\",\n\t \"width\": 320,\n\t \"height\": 180,\n\t \"caption\": \"TWS screen\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/tws-baskettrader-part-2-upload-a-basket-2\\\/#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"Home\",\n\t \"item\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"Academy Lessons\",\n\t \"item\": \"https:\\\/\\\/www.interactivebrokers.eu\\\/campus\\\/trading-lessons\\\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 3,\n\t \"name\": \"TWS BasketTrader Part 2 \u2013 Upload a Basket\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\\\/\\\/ibkrcampus.eu\\\/campus\\\/#website\",\n\t \"url\": \"https:\\\/\\\/ibkrcampus.eu\\\/campus\\\/\",\n\t \"name\": \"IBKR Campus EU\",\n\t \"description\": \"\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.eu\\\/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}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Archives | Traders' Academy | IBKR Campus","description":"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.","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.eu\/campus\/wp-json\/wp\/v2\/trading-lessons\/199080\/","og_locale":"en_US","og_type":"article","og_title":"TWS BasketTrader Part 2 \u2013 Upload a Basket","og_description":"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.","og_url":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/","og_site_name":"IBKR Campus EU","article_modified_time":"2024-01-02T17:53:45+00:00","twitter_card":"summary_large_image","twitter_title":"TWS BasketTrader Part 2 \u2013 Upload a Basket","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/","url":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/","name":"TWS BasketTrader Part 2 \u2013 Upload a Basket","isPartOf":{"@id":"https:\/\/ibkrcampus.eu\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.eu\/campus\/wp-content\/uploads\/sites\/3\/2022\/07\/mqdefault-2.jpg","datePublished":"2022-07-20T17:30:00+00:00","dateModified":"2024-01-02T17:53:45+00:00","description":"This is lesson 2 of 2 on the TWS BasketTrader. This lesson focuses on creating and uploading a basket file.","breadcrumb":{"@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/#primaryimage","url":"https:\/\/www.interactivebrokers.eu\/campus\/wp-content\/uploads\/sites\/3\/2022\/07\/mqdefault-2.jpg","contentUrl":"https:\/\/www.interactivebrokers.eu\/campus\/wp-content\/uploads\/sites\/3\/2022\/07\/mqdefault-2.jpg","width":320,"height":180,"caption":"TWS screen"},{"@type":"BreadcrumbList","@id":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/tws-baskettrader-part-2-upload-a-basket-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.interactivebrokers.eu\/campus\/"},{"@type":"ListItem","position":2,"name":"Academy Lessons","item":"https:\/\/www.interactivebrokers.eu\/campus\/trading-lessons\/"},{"@type":"ListItem","position":3,"name":"TWS BasketTrader Part 2 \u2013 Upload a Basket"}]},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.eu\/campus\/#website","url":"https:\/\/ibkrcampus.eu\/campus\/","name":"IBKR Campus EU","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.eu\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/trading-lessons\/199080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/trading-lessons"}],"about":[{"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/types\/trading-lessons"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/users\/899"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/comments?post=199080"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/trading-lessons\/199080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/media\/203586"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/media?parent=199080"}],"wp:term":[{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/contributors-categories?post=199080"},{"taxonomy":"traders-academy","embeddable":true,"href":"https:\/\/ibkrcampus.eu\/campus\/wp-json\/wp\/v2\/traders-academy?post=199080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}