Introduction
In this article, we will look at how to place bulk orders (multiple orders) on Zerodha KITE, Upstox or AliceBlue. You can place any type of orders (regular order, bracket order, cover order or after market order). You enter order details in an excel file that we provide & then simple click “Place Bulk Order”.
AutoTrader is a single tool that can work with multiple trading platforms, and does NOT require APIs from broker.
Bulk Orders means placing multiple orders with a single click. They are also know as Basket Orders.
Warning
This demo was built with AutoTrader, which is now restricted to NOW, NEST & ODIN platforms only.
For trading with Upstox, Zerodha, AliceBlue or Finvasia; please use the next generation AutoTrader-Web. This product also has similar Excel utilities.
Demo Video
A demo of this bulk order utility is available on YouTube.
Prerequisite
You need to install AutoTrader-Web software. For more details, kindly read documentation for Excel utilities.
Step 1 – Start AutoTrader
- Double click on “Start_AT” shortcut.
- AutoTrader screen will open up, click on “Start AutoTrader“
- AutoTrader must be in RUNNING state
Step 2 – Log into KITE (Not required for Upstox & AliceBlue)
- Login to your kite account on (kite.zerodha.com) using Firefox browser only
- If you are using AutoTrader with Upstox or AliceBlue, then there is no need to login
Step 3 – Enter bulk orders details
- The excel is present at location (C:\autotrader\scripts\excel\BulkOrders-WebPlatforms.xlsm)
- To make it easy, you can copy this excel file onto your desktop.
- Open the file, click “Enable Macros” if you get a warning from excel.
- This excel file has 2 sheets (order & validation)
- By default, you will see some sample orders. You can delete these orders.
- Please enter your order details in order sheet.
- Please see validation sheet to understand valid values for columns.
- Symbol should be KITE symbol.
- Quantity should be entered in lot size for derivative contracts.
- Click “Place Bulk Order“
How it works?
- Once you click Place Bulk Order button, then excel macro sends all orders to AutoTrader.
- AutoTrader will validate orders & place then onto KITE, UPSTOX or AliceBlue (depending on which trading platform is set in AutoTrader settings).
- AutoTrader will display success/failure messages on its home screen.
Conclusion
This bulk orders utility is very useful for people who want to trade in multiple stocks. If you do your analysis at the end of every day, then you can use this excel to place bulk AMO (after market order). You can even write formula to automatically populate orders that need to be placed.
As you can see, you can place many orders with just a single click.
Extremely useful.
March 1, 2018 at 10:02 amI use Excel for doing my analysis & this utility helps me to easily place orders for all 20 stocks that I monitor.
Nicely explained. I am using it to trade automatically on zerodha kite, and it’s been good so far.
Initial setup is a little tedious, but the user guide is very useful. Good luck!
March 11, 2018 at 1:59 pmVery good automation product with Zerodha kite.
March 14, 2018 at 1:37 pmLike the kite excel order utility as well, as I use formula to calculate my order price & quantity. It saves me from data entry mistakes.
hi, i am interested in the autotrader and what is the maximum number of orders that can be placed at one instance,is it 50 or can be increased? also would like know if its possible to use the same excel to place orders repeatedly,for ex, i placed 10 orders with the excel file and can i use the same file to place another 10 orders?
June 23, 2018 at 6:40 pmNo limit on maximum orders as such. Yes you can use the same excel to fire orders repeatedly. You can even make as many copies of excel as you want, so that you can keep all of your orders ready. You can have an excel per contract to avoid data entry.
June 29, 2018 at 4:32 amthanks for your reply,let me try out the software once and will get back to you with suggestions
June 30, 2018 at 2:26 pmsir muje Zeordha me account open karna hai ,
July 3, 2018 at 2:48 pmPlease visit Zerodha’s website.
July 4, 2018 at 5:56 amFew things I would like to know.
1> WHEN WE ARE PLACING THE ORDER WHERE THE DATA IS GETTING STORED BEFORE GOING TO BROKER TERMINAL AND EXCHANGE?
2> CAN A RETAIL TRADER PUT BULK ORDERS WITHOUT THE NISM CERTIFICATION AND OTHER PROCESSES THROUGH AUTO TRADER?
July 21, 2018 at 9:56 pm1. They are stored in AutoTrader database
August 1, 2018 at 6:56 am2. Yes, you can
Through is Auto traders software can I buy 300 lots of Nifty options ? as there is a capping from NSE that one can not buy more than 100 lots of Nifty option in one order.
July 31, 2018 at 11:45 amIf I can buy 300 lots in 3 order via bucket ordering through this Autotrader in one go, noting like it !!
Your revert awaited.
Yes you can, by putting multiple orders in one click through excel utility.
August 1, 2018 at 6:55 amDo u have a similar utility for placing bracket order from excel to upstox??? If yes send me the details.
July 31, 2018 at 7:03 pmWe will have it by end of August 2018
August 1, 2018 at 6:55 amhi,
August 2, 2018 at 11:17 ami’m using autotrader since last 10 days. it is amazing. Actually I linked nest trader to this excel & all datas r updating in realtime. i could trade immediately when my conditions met. But due to some technical issue in Nest could not connect nest with ur excel. Is there any alternate way to get live data in the excel provided by you.Tks in advance.
We are not aware of any other way, but you should be able to connect to our excel as it is just a normal excel file like any other excel file that you create.
August 7, 2018 at 10:52 amSir, I have opened an account in Zerodha and I’m a new user. Bulk Order Sample File provided by Zerodha does not contain “Place Bulk Order” Option in Excel. Please guide me how to create a button although I tried a lot many times using Macros but could not create that Button.
August 2, 2018 at 4:46 pmPlease install AutoTrader, the excel files come with the installation. Please refer to AutoTrader user guide for more information.
August 7, 2018 at 10:51 amHello I want to subscribe for a month nw…but I don’t hv d license no. As u said make d payment and mail u by d license no…my account was against drdevjit@gmail.com
August 7, 2018 at 4:47 pmYour issue has been resolved.
August 14, 2018 at 5:40 amSuppose at End of the day i found 4 bullish stocks and 4 bearish stocks…. Want to place them at 9.20am
A) when price cross 5 min candle high with same candle low as SL (FOR BULLISH)
B) When price crosses 5 min candle low withe same candle high as SL (FOR BEARISH STOCK)
Are above these conditions can be run?
September 13, 2018 at 8:43 pmYou will need to code it in AmiBroker, we provide API functions that can be used in AmiBroker or excel
September 26, 2018 at 11:45 amI am using your autotrader but I am having following query.
I have zerodha and upstox both account. I want to place BO and CO order in both the clients but for DIFFERENT SCRIPTS . Which excel to be used for that?
October 4, 2018 at 6:25 pmZerodha Order want to place BO or CO.
Upstox order want to place OCO or CO.
Always use BO, CO. If trading platform is Upstox, AutoTrader internally converts it to OCO. See autotrader functions (Function Variables table) for valid values.
October 5, 2018 at 5:15 amBulk order for Kite and Upstox dot have provision for putting account number? how it will identify that which stock to put which account.
October 5, 2018 at 12:35 pmExample:
I want to place SBI and Eicher in zerodha and Biocon and TCS in Upstox. How this different script will placed in different account?
Because which registering only I have give zerodha account details. Not the upstox account details? Then how it will identify the different broker account and place the script accordingly?
is above thing possible? Can I put BO and CO order from single sheet to different broker platform? Or we need to go for separate subscription?
October 8, 2018 at 6:26 amCan we buy 4000 quantity ( 100 lots) in one order by using this
October 16, 2018 at 12:38 pmIt depends on broker restrictions, but you can use our excel tools to divide one big order into multiple smaller orders.
October 17, 2018 at 9:13 amI want to try the free version before subscribing. Is there any restriction
October 29, 2018 at 10:36 amThere is no restriction, the trial version is a full version. You can download it from our website.
October 30, 2018 at 3:42 amCan I get 15 mins OHLC data from auto trader to excel for all f&O stocks and futures? Is it possible?
November 10, 2018 at 11:12 amWhat is the cost of it? Can I get the data feed from autotrader?
Datafeed to excel is not supported, we support datafeed to amibroker with a max limit of 50 symbols.
November 11, 2018 at 2:36 amIs it possible to place basket order at a particular time, say 14:30 through autotrader without any other conditions?
November 11, 2018 at 4:48 amNot as of now, we may add this feature in future. What you can do now is add time checks in amibroker or excel & let amibroker or excel fire orders to autotrader at a specified time.
November 12, 2018 at 4:33 amHi
December 23, 2018 at 9:52 amAuto trader is good product.
Is it possible automate place order button in excel at 9:30AM ?
Yes, using excel VBA macros coding.
December 24, 2018 at 11:00 amCan we place order one by one. If I don’t want to place order in single go.
January 8, 2019 at 9:20 pmPut AutoTrader in Manual (Semi-Auto) mode, and then send orders in bulk from excel. All orders will be shown on AutoTrader dashboard, but will not be sent to trading terminal. Every order a “Place” button next to it, which you can click to send them one by one.
January 9, 2019 at 7:31 amthanks for sharing this information.have shared this link with others keep posting such information..
January 26, 2019 at 11:43 amIs this software available for Mac computer?
June 28, 2019 at 4:49 amIt can, but it needs a customized setup which we will need to do. It will cost a lot, so we recommend windows.
July 2, 2019 at 6:13 amIs there any chance i install this on Mac? Any Mac support pls?
October 29, 2019 at 6:09 amFuture versions will support Mac
November 8, 2019 at 7:11 amHello Team,
I would like to know if I want to execute a single order in multiple (10) accounts of my different clients , do I need to open all accounts or can carry with excel?
January 24, 2020 at 7:09 pmhttps://stocksdeveloper.in/2018/12/08/autotrader-faq/#how-to-trade-multiple-accounts
January 26, 2020 at 9:08 amcan we put option order on this platform ??
June 2, 2020 at 7:01 pmYes
June 5, 2020 at 8:13 amCan we have EMA Value (Crossover) of 15 min chart in excel and place the order accordingly
June 6, 2020 at 3:59 pmYes, you can have any strategy. You need to code it accordingly in Excel VBA.
June 7, 2020 at 3:51 amCan i trade in multiple Demat account at one time ?
June 15, 2020 at 6:40 pmYes, please see this video.
https://youtu.be/DYRE6X9W6xk
June 15, 2020 at 9:55 pmHi I want to place single order for multiple clients can I do that.. zerodha kite am using . please guide me
July 9, 2020 at 10:12 amhi,
July 13, 2020 at 2:16 pmif i placed bulk order for multiple client how can i place square off order?
You need to place a reverse order. Soon we will provide square-off option on AutoTrader Web UI. Also this article is for our old product. Kindly use AutoTrader Web, which is the next generation product.
July 15, 2020 at 3:01 pmCan I place orders for a particular price ?
July 24, 2020 at 3:32 pmYes, you can. This product is outdated, please visit this new product.
July 27, 2020 at 12:07 pmSir I m not getting point how to start up from step by step to connect software with trading account so plz guide me from first step to last step
August 15, 2020 at 11:16 pmThis is an old product, please visit following link to a new product which also has demo video.
https://stocksdeveloper.in/documentation/client-setup/excel-library/
August 15, 2020 at 11:42 pm