Excel Automated Trading for NSE/MCX
Note: This article is outdated because Nest Plus API is discontinued by most brokers
It is possible to send completely automated orders from Excel for NSE (all segments) as well as MCX. You can write Buy/Sell signal generation logic in Excel and send automated orders to the broker. Both leading vendors in India- Symphony and Omnesys provide tools for algorithmic trading via Excel. Any broker who has partnered with Symphony or Omnesys can provide you the appropriate tools for such system.
Excel Automated Trading Using Nest Plus API
The Nest Plus API is an expensive tool for automation. It costs hardly Rs. 300 per month for single client account and Rs. 1000 p.m. for sub-brokers. The API integrates with Excel through VBA Macros as shown below. The API allows placing orders, modifying orders, cancelling orders and fetching order status.
Once your excel sheet connects with Nest Plus, you can link custom strategies or create Buy/Sell buttons as shown below.
Please note that Nest also allows a feature ExcelRTD which can provide live data to your excel sheet for running strategies.
Excel Automated Trading Using Presto FuseXL
The FuseXL provided by Symphony Presto is an advanced API which allows various order functions as well as RTD functions for fetching data. This system is recommended for professional traders. The annual cost of Symphony Presto may go above Rs. 40,000 inclusive VPS costs and taxes.
The following functions are available: Send_Order(),Replace_Order(),Cancel_Order(),Square_off().Multiple Orders can be cancelled by calling sub cancel_matching_orders_Function() and multiple orders can be replaced by calling sub replace_matching_orders_Function().Execution Report is received in cells by calling function getfrmQueue().
Check all Knowledge Base Articles in this category:
Surya
One can to do fully automatic trading from excel sheet? Can you give to link to whom to contact?
Surya
Hello any one here?
Do you have automatic trading software from excel? Please give me the link.
AlgoPro
@Surya, excel automation is provided by both Symphony Presto and Omnesys. You can contact the respective vendors. You will also find following articles useful:
https://algoji.com/symphony-fintech/
https://algoji.com/omnesys-technologies/
Surya
1-Hi Algopro, in my excel sheet now number is coming as “1” . Here in one column I want Buy in place of that”1″ and in other, sell . My formula is lie this-
=IF(B2=C2,1,””)
=IF(B2=D2,1,””)
Please help me.
AlgoPro
Sorry, there is currently a dearth of programmers, we cannot complete your request.
Surya
I did on my own. It was very simple. I want to develop sure shot 100% successful intraday profit technique for 0.5% profit minimum in 1 trade. I am working on it. If had any friend who knows programming I would have been most happy.
Mugunthan
Mr. Surya can you please elaborate your requirement, if possible, i will try to help you.
chinna
i developed my own fully automated excel
sandeep
surya,
please send me your details where i contact you
Surya
Chinna, Can you please elaborate…
Chinna
Yes excel can be fully automated,in my excel I predefined conditions like ORB,FIBBO,VOLUME AND OI with addition to pro gaps and regular gaps with SL and TGTs.
Orders can be NRML ,MIS ,BO or CO as per the firing conditions.
But still it’s a prototype only.
Shivam
Need help from excel experts :-Am able to identify set of stocks which will surely run next day and am planning to automate excel trades using nest..Requirement is I should be able to give trade input in excel in advance and my trades should get executed through Nest once trade levels meet……pls help me if any of excel expert can. Thanks in advance …My watsapp contact 8438962583
chinna
Yes Shivam its quite possible
Vinod
Hello Chinna your contact details please.???
Chinna
My watsapp contact 8962157116
RN
Contact for excel help if needed