Just testing a Order Placement From Excel is very easy.
But building a Trading System within Excel using VBA requires lot of interest and hard work.
If you are Excel Pro with VBA Experience, You can build and deploy your trading system in just an hour.
Here how you start with…
- Get Kite Connect API Subsscription from Zerodha (Rs2000/pm)
- Download and Install KiteXL from HowUTrade
- Download the Sample Excel Sheet from HowuTrade.
This sample Excel Sheet has basic usage of KiteXL.
& for [quote=“sudheer_kumar, post:10, topic:6159, full:true”]
How can we fire orders using this KITEXL.I have gone though your website but couldnt figure out.
[/quote]
Its just like using sum Function.
We wrapped all order Functions in UDF, You just need to call the Function in the Cell when you want to place order.
For Example:- You want to place Order when cell value of C3 = "BUY"
In another, You can write formula like below…
=If(C3="BUY",PlaceRegularOrder("NSE", "ICICIBANK", "BUY", "MARKET", 10,"MIS", 0, 0, "DAY"),"NO SIGNAL")
Please refer the Docs which has details of all functions supported and required parameters.