KITExl

HAs

can any body help or explain how to operate in kite XL how to fire orders , there are some strategies inbuilt need understand the same.

wants help in developing new strategies..

Please Help

HowUTrade

@HAs

If you are proficient in Excel VBA or curious to learn things, then you can proceed.

Simplest example:
In cell A1, You have a formula that will display "BUY" on certain conditions and you want to place a BUY order in AXISBANK with 150 Qty when cell A1 display "BUY".

In cell A2
=If(A1="BUY",PlaceRegularOrder("NSE","AXISBANK","BUY","MARKET",150,"MIS"),"NOSIGNAL")

The above formula will call the PlaceRegularOrder function when cell A1 display "BUY" and places a Regular Order to Zerodha OMS through Kite Connect API.
Here the PlaceRegularOrder is a UDF which wraps the PlaceOrder function of the KiteNet.dll

In our sample excel workbook, we have wrapped all the functions of KiteNet.dll in UDF, so that you can call those functions from within excel cell.

References:
https://howutrade.in/docs/kitenet/html/Introduction.htm
https://howutrade.in/2017/08/31/restrict-multiple-order-firing-excel-upstox-api/
https://kite.trade/forum/discussion/4110/excel-error-activex-component-cant-create-object-after-kitenet-dll-update
https://kite.trade/forum/discussion/4221/login-error-network-error-please-try-again-in-kitexl
https://kite.trade/forum/discussion/3749/kitexl-login-blank
https://kite.trade/forum/discussion/3782/kitenet-rates-fields-are-not-refreshing-in-marketwatch-while-in-marketdepth-its-working-perfectly

HAs

Thanks very useful Information... i am not able to get the quotes for banknifty and nifty please help