@madhukar
GetSymbol returns a very large string for NFO (appx 70000 symbols), so excel can't handle such a large string.
GetAvgVolume returns average volume (Day) for the last 3 months. This function depends on nseindia.com data and available Nif…
@madhukar
RTD is the most efficient method to get real-time data in excel cell.
Reading text file and parsing the data will result in decreased performance.
@krtrader
We are also experiencing this.
Initially, thought this may be due to some temp network issues.
But the delay is consistent, we hope Kite team might have added some delay in order requests.
Earlier we used to place a order i…
@madhukar
Yes, KiteNet will work only after successful validation of client id.
Order Updates:
(Part-1) You (KiteNet/KiteXL) will receive order updates directly from Kite server, then if email or SMS alert is enabled, (Part-2) KiteNet/KiteXL will…
Of-course, you will get Greetings for next Diwali also, as this general notices are retrieved during login. This feature enables us to communicate not only greetings, but also updates and other important things. Only few people regularly checks foru…
@madhukar
It is answered here
Every API calls happens between you (Excel) and Kite server, nothing is involved in between.
Regarding the monetize part, we are going to charge Rs 100/month to use KiteNet as Maintenance/Developer charges from Jan/F…
@madhukar
We totally forgot this, I'm writing a short version here.
Data involved with KiteNet:
*On successful login, client id will be checked in our data base for custom algo and enables/disables algo accordingly. (Automatic)
*If email alerts i…
@madhukar
You can subscribe up to the maximum permissible limit set by Kite API.
As per the screenshot, it looks like the limit is 3000 per socket.
So you can subscribe up to 3000 ticker per instance (process) in KiteNet
@madhukar
GetShortSignal is just opposite of GetBuySignal.
GetSellSignal and GetCoverSignal are same as above except that it takes additional parameters target & stoploss price, will return SELL & COVER respectively when LTP crosess target…
@madhukar
Multiple web-socket connections is not possible in KiteNet.
KiteNet supports only single web-socket connection per instance (process), so effectively you can subscribe up to 1000 symbols (API Limit) per instance (process).
You can run 2…
@madhukar
We have changed the name of this function in the test version.
Do as follows;
Go to the Bridge module of VBA and search for the UDF 'Sleep'
Option1: If you don't need this UDF, then delete the entire UDF
Option2: Just change the line Br…
@madhukar
GetOrderStatus is a function, so you (Excel) have to call this function whenever you need latest data. To auto-update like RTD, make this UDF volatile or add dynamic dummy parameter.
Hope you already know this, so there exists only two …
@madhukar
When you run your system in cloud server, your chances of failure are greatly reduced.
But still, no software/cloud/Program are guaranteed to run 100% without fail.
Last month there is a network failure in AWS for 3mins, which lead to …
@madhukar
KiteNet will work only in Microsoft Excel and Windows OS.
Pls go through this link
https://kite.trade/forum/discussion/comment/18629/#Comment_18629
@madhukar
Our 50+ clients are using cloud server only and don't know what other users are using.
Server is not required during development of system, once you developed a full trading system without any error, then you should run it in cloud serv…
@ZZ8030
Download the latest sample KiteXL.xlsm from the below link
http://howutrade.in/downloads/kitenet/?version=test
We have added a UDF to Cance/Exit/Close Regular/BO/CO positions and hooked this UDF to buttons in Dashboard sheet. You can use …
@madhukar
You can reduce your cost (AWS) by running the server during market hours only. i.e 0700AM to 0500PM (10hours daily and full shutdown on market holidays) This way it will cost $79 + GST for 4Core + 8Gb RAM.
Otherwise you can go for mon…
@raja1sttarde
Yes, when you modify a LIMIT order to MARKET, price is irrelevant, your order will always executed at the best price available.
For the sake of clarity, just pass Ltp or your original price while sending modify request.
But make su…
@madhukar
If you mean real-time price data, Kite Server streams one second snapshot data. So ideally price will be updating every second (for liquid stocks).
If order latency, we are able to place a single order in ~30ms during normal network tra…
@madhukar
It's technically difficult to implement.
Since the stop orders are placed by OMS, KiteNet don't have any reference to hook it.
You may have multiple BO in a symbol
Each BO may have Multiple child orders
Each child orders may complete at…
@raja1sttarde
Case 1: If the modify Qty is less than Filled Qty (for whatever reason), then the order will not be modified and last order status before modify request will hold good. Means
Order Status : OPEN
Order Qty : 100
Filled Qty : 61
Pendin…
@raja1sttarde
Taking your example case
Stock : XYZ
Qty : 100
Filled : 60
There are two options to cancel the order, pls note you are just cancelling the unfilled qty, you have already open position for filled qty.
1. Normal Cancel of Order
The …
@madhukar
You have to explicitly call ResetBOSignals before firing same signal.
Since the exit orders are handled by OMS, KiteNet can't monitor and reset automatically.
But we are testing reset of signals with ExitBOBridge
We are adding a additio…
@Sudheer
The Symbol is correct.
Is MCX is enabled for your exchange?
Try placing a manual order in Crudeoil from Dashbaord Sheet --> Place Order Button.
@madhukar
The StgyCode must be two characters and alpha-numeric string.
You can create as many as strategy you want up to the limit of your Laptop/Computer/Server.
@madhukar
The syntax is same GETRTD(Exch, TrdSym, Field)
For NSE Indices, the Exch is NSE_INDEX
For list of indices refer the below file
MyDocuments\KiteNet\[ddMMMyyyy]\NSE_Index.txt
Trade Symbol is in the third column of the above file.
@shara
For partially filled order, GetOrderStatus will return "UPDATE" as status.
GetOrderStatus returns data from web-socket only.
You can also compare
GetOrderQty and GetOrderFilledQty
GetOrderQty : Total quantity you placed
GetOrderFilledQt…
@shara
It will not change automatically.
GetOrderStatus ("order Id") is a function (Not RTD), so you (Excel) have to call this function whenever you need value.
To make auto update:
You can make this function volatile or add a dummy dynamic param…
@Ashishkachhdiya
It is a network issue connecting with api.kite.trade. This will go automatically.
If you get this error on every call, pls let us know.
@madhukar
The GetSymbol returns very large string, so excel may throw error.
There is no practical use for this function in Excel.
Just ignore this function.
DOM returns 0, may be due to off-market hours.
Try during live market hours, and make su…
@Sudheer
Little History:
When we add a symbol to Market Watch sheet, the formula in Column 'AH' calls the SubscribeQuotes function of KiteNet and the symbol is added to the 'TickerListKiteNet.txt' file which is located in the app directory (in ca…
@Sudheer
Can you post the screenshot of right side of market watch sheet.
There is a column in the right side where quotes are subscribed.
Need to check whether it throwing any error.
@madhukar
Yes, you can convert any existing UDF to dynamic by adding additional parameters.
But make sure that, the additional parameters is dynamic and updates automatically without any intervention. In other words, you should have at-least one c…
@madhukar
We added a extra parameter in the Excel UDF which wraps the GetMtmBridge funtion, to make it auto update in excel cell.(Dynamic dummy parameter, which will force excel to re-calculate the formula whenever Ltp changes)
@madhukar
GetAtp will not be recalculated automatically by Excel as the parameters are static.
You have to
make this GetAtp UDF as Volatile
or Add dynamic dummy parameter to UDF to force excel to re-calculate.
@madhukar
Right now, with Paper mode you will just get the Profit/Loss simulation.
So, GetOrder* functions will work only with real order id's.
Next week we will release,
1. Excel ORB
2. AmiBroker MA Crossover
@madhukar
Yes, VWAP == AVGPRICE
GetRTD(Exch,TrdSym,"AVGPRICE") and GetAtp(Exch,TrdSym) both returns same values.
GetRTD:
This is a excel UDF which wraps the complex Excel RTD function as mentioned here https://howutrade.in/docs/kitenet/html/Intro…
@madhukar
#1 KiteNet RTD client-server is using Udp to send/receive data.
Udp can receive only certain number of packets in a second and it depends on the user physical hardware/infra. We found that the ideal capacity of Udp is 5000 pps.
If you se…
ExitBO:
You can pass any child order id.
Or Simply pass whatever returned from GetChildOrders call to ExitBO/ExitBOBridge, no need to split child orders.
@madhukar
We will check this and revert to you.
But most likely it will be due to the reasons mentioned here.
https://kite.trade/forum/discussion/comment/18310/#Comment_18310
@madhukar
ModifyBOSL & ModifyBOSLBridge, both functions does the same thing.
Yes, you can just pass all child order id's, but make sure you have error handling in place.
@madhukar
We checked the logs.
ModifyBOSl function checks for the order type of the passed OrderId, if it is other than SL, then this function will throw error 'Order is not BO stoploss order'
There are two possibilities in your case;
1. You are …
@madhukar
Regarding the Excel error, pls refer this link
https://howutrade.in/2018/07/17/excel-error-activex-component-cant-create-object-kitenetupstoxnet-dll-update/
@madhukar
1. Make sure the downloaded file is not blocked.
2. Extract the contents of the downloaded zip file to some folder (Ex: Kite) in Desktop or MyDocuments
3. Make sure the extracted folder doesn't contain brackets '(' ')'
4. Run the reg…
@madhukar
This restriction is imposed at KiteNet level to prevent new users from misusing Excel/RTD.
Web-socket connection is automatically handled by KiteNet and at-present KiteNet supports only single web-socket connection.
So you can subscribe…
@madhukar
No need to rewrite.
Just use your existing workbook.
You need to install/Register the DLL only.
You can always use your existing workbook irrespective of any updates.
@madhukar
Can you try installing the test version?
This has been fixed in the test version.
You can download it from here
More info on this https://support.zerodha.com/category/trading-and-markets/margin-leverage-and-product-and-order-types/article…
@balasoft80
Day and net positions affects only Futures and Options.
If you have any overnight positions, then day and net will differ else both will be same.
Example:
Last Trading you bought 75 Qty of NIFTY future
and today you sold 75 Qty of NIF…
@shweta ,
We don't have Ninja developer.
If ninja trader supports COM, you can directly use KiteNet Bridge functions and fire orders.
We read somewhere, it supports COM.
@gkumbhar
Currently, Kite connect API does not stream/support this field.
This field is reserved for future use.
You can request Kite team to provide this data.
Fields reserved for future use:
LOWERCKT
UPPERCKT
SPOT
YEARLYHIGH
YEARLYLOW
OINETCHG
…
@madhukar
We have included a UDF to exit BO/CO/Regular Order (All at once) etc in the sample workbook.
You can just modify the UDF according to your needs.
You can download the sample workbook from
https://howutrade.in/downloads/kitenet/?version=…
@Ashishkachhdiya
You need to pass valid trade symbol and exch.
You can find the symbol list in the below directory.
[APP DIR]\KiteNet\[DDMMMYYYY]\MCX.txt
@madhukar
Yes, you need to call ResetBOSignal..
But make sure, you are calling only once after exiting the BO order.
Instead of reset, you can also just assign another StgyCode.
Example:
StgyCode : A1
Called PlaceBOBridge(...BUY...A1)
Called Exit…
@madhukar
To exit a BO/CO order,
Just pass whatever returned from GetChildOrders to ExitBO/ExitCO/ExitBOBridge/ExitCOBridge functions. You no need to parse the child orders.
To Modify a BO Target/Stoploss order:
1. Call GetChildOrders, which wi…
@madhukar
We respect your privacy.
We don't store any hidden code or track you what you are doing.
But it will take time to trust someone..
We will write a detailed article on this, which not only take your fear and also will increase confidence…
