Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How to Send Bulk Orders from Excel Sheet to Multiple Brokers using Algomojo Platform

2 min read

Exciting news for all our trading community! Currently, AlgoMojo supports the Order Slicing Feature and we’re thrilled to announce that we’ll soon be releasing an open-source Excel Module for placing orders with the split facility to any AlgoMojo-supported broker.

Algomojo – Excel Module to Send Bulk Orders

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’s Common API to transmit orders, making the process seamless and efficient.

Features of the Excel Bridge

  • Simple Interface: The interface is designed to be user-friendly, making it easy for traders to send orders without any technical knowledge.
  • Multiple Trading Accounts: The software allows traders to send orders to multiple trading accounts, giving them greater flexibility and control.
  • Multiple Brokers: Traders can send orders to multiple brokers, allowing them to take advantage of the best market conditions and execute their trades efficiently.
  • AlgoMojo Arrow API: The code uses AlgoMojo’s Arrow API, making the transmission of orders quick and reliable.

Enabling the Macro

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.

1)After downloading the File right click over the Excel Macro File ->Goto Properties as shown below

2)Now check the Unblock Box and Press Apply button as shown below

3)Open the Excel Sheet and Click Enable Content as shown below and start using the excel sheet by filling in appropriate values and pressing the place order button to place the order

Ensure that the Proper API Key and API Secret key are set as per the Algomojo Trading Account.

Disabling Protected view in Excel

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 File > Options > Trust Center > Trust Center Settings > Protected View, and then uncheck Enabled Protected View for files originating from the Internet.

Reference Values

ParamValueDescription
broker codeAB
AN
FS
FY
FP
GC
PT
SM
TC
ZB
ZE
Alice Blue
Angel One
First Stock
Fyers
5 Paisa
Goodwill Commodities
PayTM Money
Samco
Tradejini Cube
Zebu
Zerodha
ActionBUY
SELL
Buy
Sell
Price TypeMARKET
LIMIT
SL
SL-M
Market Order(MKT)
Limit Order(L)
Stop Loss Limit Order(SL)
Stop Loss Market Order(SL-M)
ProductCNC
NRML
MIS
Cash & Carry for equity (CNC)
Normal for futures and options (NRML)
Margin Intraday Square off (MIS)
Split OrderNO
YES
Split Order Disabled
Split Order Enabled
ExchangeNSE
NFO
CDS
MCX
BSE
BFO
BCD
NSE Equity
NSE Future and Options
NSE Currency Derivatives
MCX Commodity
BSE Equity
BSE Futures and Options
BSE Currency Derivatives

Benefits:

  • Increased Efficiency: With Excel Based Automation, traders can send orders to multiple accounts and brokers simultaneously, reducing the time and effort required to execute trades.
  • Better Control: By sending orders to multiple accounts and brokers, traders have greater control over their trades and can take advantage of the best market conditions.
  • Enhanced User Experience: The simple interface and efficient transmission of orders make the trading process seamless, resulting in an enhanced user experience.

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’s Common API, traders can be confident that their orders will be transmitted quickly and reliably.

If in case any custom queries on excel sheet-based trading do send a support ticket by mailing to [email protected] our team will get back to you.

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

Algomojo Platform Now Open to Finvasia (Shoonya) Users

Algomojo, a leading Algotrading platform for DIY traders, is excited to announce that it is now open to Finvasia (Shoonya) users. This partnership aims...
Rajandran R
5 min read

Algomojo Platform Now Open to 5Paisa Users

Algomojo, a leading Algotrading platform for DIY traders, is excited to announce that it is now open to 5Paisa users. This partnership aims to...
Rajandran R
5 min read

Algomojo Platform Now Open to Goodwill Commodities Users

Algomojo, a leading Algotrading platform for DIY traders, is excited to announce that it is now open to Goodwill Commodities users. This partnership aims...
Rajandran R
5 min read

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More