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.
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
| Param | Value | Description |
|---|---|---|
| broker code | AB 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 |
| Action | BUY SELL | Buy Sell |
| Price Type | MARKET LIMIT SL SL-M | Market Order(MKT) Limit Order(L) Stop Loss Limit Order(SL) Stop Loss Market Order(SL-M) |
| Product | CNC NRML MIS | Cash & Carry for equity (CNC) Normal for futures and options (NRML) Margin Intraday Square off (MIS) |
| Split Order | NO YES | Split Order Disabled Split Order Enabled |
| Exchange | NSE 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.
