I want to know if there is some way of automatic order placement available on Pi / Kite platform? What I mean is : if I put the Scrip code / name in excel and mention that within a certain range (say 100 - 105) , as and when price is reached for a stock, then place 10 orders of 20 qty each at a price of 100 (starting) and increment each next order by 25 paise. Also be able to adjust this start price based on Market rate fluctuation in single click, that re-distributes the pricing across all other open orders. I want to do this activity in an excel and it should be interfaced to Pi / Kite platform.
Yes it’s possible.
If you are well versed with excel functions & VBA.
Then you can completely build a trading system and automatic execution of orders with excel.
Thanks a lot… will it support the example I had given above. Request to please confirm. And with Rs. 500 pm, will I have access only to PiBridge or KiteXL as well?
Hi,
It is just API.
You need to code your condition in excel/VBA.
Call the placeorder function of API to place order when the condition is true in excel.rs500 is for PiBridge.
KiteXL is a open source library for kite connect API.
Kite connect API will cost u rs2000/pm
After following due procedure(installation of kiteXL), i have downloaded the sample excel fire. On the ‘Notes’ worksheet in that excel file, it says the following:
ok. i tried with the free option and it was able to generate an api key and secret key. now i am receiving another error message which says: Exception Thrown by VBAProject Error: ActiveX component can’t create object
Would you be able to advise me on resolving this error message?