{"id":67,"date":"2023-02-03T10:39:46","date_gmt":"2023-02-03T10:39:46","guid":{"rendered":"https:\/\/algomojo.com\/blog\/?p=67"},"modified":"2023-09-13T04:30:39","modified_gmt":"2023-09-13T04:30:39","slug":"how-to-send-bulk-orders-from-excel-sheet-to-multiple-brokers-using-algomojo-platform","status":"publish","type":"post","link":"https:\/\/algomojo.com\/blog\/how-to-send-bulk-orders-from-excel-sheet-to-multiple-brokers-using-algomojo-platform\/","title":{"rendered":"How to Send Bulk Orders from Excel Sheet to Multiple Brokers using Algomojo Platform"},"content":{"rendered":"\n<p>Exciting news for all our trading community! Currently, AlgoMojo supports the Order Slicing Feature and we\u2019re thrilled to announce that we\u2019ll soon be releasing an open-source Excel Module for placing orders with the split facility to any AlgoMojo-supported broker.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-5.png?ssl=1\"><img src=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-5-1024x216.png?resize=1024%2C216&amp;ssl=1\" alt=\"\" class=\"wp-image-57250\"\/><\/a><\/figure>\n\n\n\n<p>Excel Based Automation is a software tool that allows traders to send simultaneous orders to multiple trading accounts and brokers using a simple interface in Microsoft Excel. The code uses AlgoMojo\u2019s Common API to transmit orders, making the process seamless and efficient.<\/p>\n\n\n\n<p><strong>Features of the Excel Bridge<\/strong><\/p>\n\n\n\n<ul><li><strong>Simple Interface:&nbsp;<\/strong>The interface is designed to be user-friendly, making it easy for traders to send orders without any technical knowledge.<\/li><li><strong>Multiple Trading Accounts:<\/strong>&nbsp;The software allows traders to send orders to multiple trading accounts, giving them greater flexibility and control.<\/li><li><strong>Multiple Brokers:&nbsp;<\/strong>Traders can send orders to multiple brokers, allowing them to take advantage of the best market conditions and execute their trades efficiently.<\/li><li><strong>AlgoMojo Arrow API:<\/strong>&nbsp;The code uses <a href=\"https:\/\/algomojo.com\/docs\/api-documentation\/\">AlgoMojo\u2019s Arrow API<\/a>, making the transmission of orders quick and reliable.<\/li><\/ul>\n\n\n\n<p><a href=\"https:\/\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/AM_PlaceOrder-Excel%20Module.xlsm\">Download the Excel Based Automation Tool<\/a><\/p>\n\n\n\n<p><strong>Enabling the Macro<\/strong><\/p>\n\n\n\n<p>By default, if you are downloading any Excel Macro tool Microsoft Excel comes with warning information. To Enable macro the following steps need to be done.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-7-1024x254.png?resize=1024%2C254&amp;ssl=1\" alt=\"\" class=\"wp-image-57252\"\/><\/figure>\n\n\n\n<p>1)After downloading the File right click over the<strong>&nbsp;Excel Macro File<\/strong>&nbsp;-&gt;Goto&nbsp;<strong>Properties&nbsp;<\/strong>as shown below<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-6.png?ssl=1\"><img src=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-6-1024x389.png?resize=1024%2C389&amp;ssl=1\" alt=\"\" class=\"wp-image-57251\"\/><\/a><\/figure>\n\n\n\n<p>2)Now check the&nbsp;<strong>Unblock&nbsp;<\/strong>Box and Press&nbsp;<strong>Apply<\/strong>&nbsp;button as shown below<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-8.png?ssl=1\"><img src=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-8-1024x415.png?resize=1024%2C415&amp;ssl=1\" alt=\"\" class=\"wp-image-57253\"\/><\/a><\/figure>\n\n\n\n<p>3)Open the Excel Sheet and Click<strong>&nbsp;Enable Content<\/strong>&nbsp;as shown below and start using the excel sheet by filling in appropriate values and pressing the place order button to place the order<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-9.png?ssl=1\"><img src=\"https:\/\/i0.wp.com\/www.marketcalls.in\/wp-content\/uploads\/2023\/02\/image-9-1024x253.png?resize=1024%2C253&amp;ssl=1\" alt=\"\" class=\"wp-image-57254\"\/><\/a><\/figure>\n\n\n\n<p>Ensure that the Proper API Key and API Secret key is set as per the Algomojo Trading Account.<\/p>\n\n\n\n<p><strong>Disabling Protected view in Excel<\/strong><\/p>\n\n\n\n<p>If the Excel Sheet is still not working then consider trying to disable the protected view in Excel. You can choose to disable the Protected View feature within Excel so that you no longer receive the warning upon opening any Excel file that has been downloaded. In Excel go to&nbsp;<strong>File &gt; Options &gt; Trust Center &gt; Trust Center Settings &gt; Protected View<\/strong>, and then&nbsp;<strong>uncheck Enabled Protected View<\/strong>&nbsp;for files originating from the Internet.<\/p>\n\n\n\n<p><strong>Reference Values<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Param<\/th><th>Value<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>broker code<\/td><td>AB<br>AN<br>FS<br>FY<br>FP<br>GC<br>PT<br>SM<br>TC<br>ZB<br>ZE<\/td><td>Alice Blue<br>Angel One<br>First Stock<br>Fyers<br>5 Paisa<br>Goodwill Commodities<br>PayTM Money<br>Samco<br>Tradejini Cube<br>Zebu<br>Zerodha<\/td><\/tr><tr><td>Action<\/td><td>BUY<br>SELL<\/td><td>Buy<br>Sell<\/td><\/tr><tr><td>Price Type<\/td><td>MARKET<br>LIMIT<br>SL<br>SL-M<\/td><td>Market Order(MKT)<br>Limit Order(L)<br>Stop Loss Limit Order(SL)<br>Stop Loss Market Order(SL-M)<\/td><\/tr><tr><td>Product<\/td><td>CNC<br>NRML<br>MIS<\/td><td>Cash &amp; Carry for equity (CNC)<br>Normal for futures and options (NRML)<br>Margin Intraday Square off (MIS)<\/td><\/tr><tr><td>Split Order<\/td><td>NO<br>YES<\/td><td>Split Order Disabled<br>Split Order Enabled<\/td><\/tr><tr><td>Exchange<\/td><td>NSE<br>NFO<br>CDS<br>MCX<br>BSE<br>BFO<br>BCD<\/td><td>NSE Equity<br>NSE Future and Options<br>NSE Currency Derivatives<br>MCX Commodity<br>BSE Equity<br>BSE Futures and Options<br>BSE Currency Derivatives<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Benefits:<\/strong><\/p>\n\n\n\n<ul><li><strong>Increased Efficiency:<\/strong>&nbsp;With Excel Based Automation, traders can send orders to multiple accounts and brokers simultaneously, reducing the time and effort required to execute trades.<\/li><li><strong>Better Control:<\/strong>&nbsp;By sending orders to multiple accounts and brokers, traders have greater control over their trades and can take advantage of the best market conditions.<\/li><li><strong>Enhanced User Experience:<\/strong>&nbsp;The simple interface and efficient transmission of orders make the trading process seamless, resulting in an enhanced user experience.<\/li><\/ul>\n\n\n\n<p>Excel Based Automation is a powerful tool for traders looking to increase their efficiency and control while executing trades. The simple interface and efficient transmission of orders make it an ideal choice for traders of all levels. With AlgoMojo\u2019s Common API, traders can be confident that their orders will be transmitted quickly and reliably.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exciting news for all our trading community! Currently, AlgoMojo supports the Order Slicing Feature and we\u2019re thrilled to announce that we\u2019ll soon be releasing an open-source Excel Module for placing orders with the split facility to any AlgoMojo-supported broker.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[38,29],"tags":[17,40,42,39,41],"_links":{"self":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":7,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":593,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions\/593"}],"wp:attachment":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}