New release is under testing.
Due to the long trading holidays, we unable to complete our test.
We officially announce the release after complete testing, may be on Wednesday.
If you wish, you can try this
The requests are completely discarded by API server, you won't get any Order Id i.e. your request is not forwarded from API server to OMS.You need to push next 5 orders.
The key point is make sure you are not firing more than 5 orders i…
Rate limits are not limitations, they are mechanism to prevent misuse of API.
They have nothing to do with Kite3.0 or any future updates.
Rate limits are entirely decided by Zerodha admin based on their server capacity, number API users, …
KiteDotNet is still using the old Kite Version, we are working on new version.
You can use WebBrowser control to capture the Url and parse it to get request token.
All you need is hook a method to 'WebBrowser.Navigated' event to capture …
You can try the sample excel workbook built with KiteXL.
The sample excel has market watch sheet where you can add stocks to get live price.
If your intention is live price only then ok, if you plan to build trading system, then VBA know…
Modifying a order for every 'X' ticks is not a good practice.
This is like misusing the resources, leave the kite capacity part.
If you have hundreds of orders and modifying each order like that, surely you are killing your system as we…
You can't make OHLC from cell value itself, because for OHLC calculation, you need previous value, but excel cell will always have latest value and we don't have any reference to previous value except if you manually enter the previous …
and you want just current hour or all the hours OHLC in separate row?
Is your system takes OHLC of currently forming candle or only after candle formation is completed?
Say 0915 candle will have data of 0915 to 1015, when you will utilize this cand…
KiteXL uses the default kite version and the current default version is v1.
KiteXL may cease to work when Kite Team makes kite3.0 as default version. We are working on the new release compatible with 3.0.
Thanks for the prompt reply.
That's OK for the order placed through API where you get order_id immediately and we can assign initial status based on the order type LIMIT or SL (OPEN or TRIGGER PENDING).
Suppose I placed BO/CO order and i…
Could pls clarify whether, will be getting order_updates for 2nd leg in BO/CO through web-sockets i.e. initial status and further updates?
If place a LIMIT order in Kite Web and the status is OPEN, will get that order in websocke…
Try running the Excel as Admin.
Not sure whether the Kite3.0 will break KiteXL or not, right now we are not involved in KiteXL.
As per the Kite Team, the default version is still 1.0 and have given time to port, so ideally it should wor…
Yes, the new release will incorporate all the changes of Kite3.0, and also get rid of post-back as order updates are available in web-sockets.
Hopefully, we will release in Feb 1st week.
You can't run KiteXL in google sheets as
1. Functions are wrapped in DLL
2. VBA is not directly supported
You can ta…
This error indicates, you have not registered KiteXL or registered wrong version.
Try exactly following the included notes in the zip file.
If face issue, PM your Team Viewer Id & Pwd, I'll be available between 0100 PM to 0200 PM (IST).…
You can download the KiteXL from here https://howutrade.in/docs/kitexl/html/Downloads.htm
You can get the API secret from Kite Developer console.
Note:- The KiteXL is outdated, has known issues and new release is underway.
As per @sujith comment, the default version is v1 and KiteXL is using the default version only.
The answer to "why the v1 worked earlier and started throwing error suddenly" remain mystery and I'm leaving that to back-end team.
We can't swi…
I guess, KiteXL is using latest version, because it just using the https://api.kite.trade as end point without version header.
Could you confirm what is the default version, the doc show as v1?
As it was working fine for long time, suspect some back-end changes causing this error.
KiteXL sends default values for non-mandatory fields, so it sends quantity as 0 for the second leg orders as quantity is not required for modifying seco…
Once the library is out, this will be most comprehensive of all,
Fastest execution of requests,
added features that benefits users in many way.
One thing is test your strategy without investing, this will definitely save novice us…
Even after a user logouts from API, kite server will still send streaming quotes.
Effectively, you will be getting quotes irrespective of whether you logged-out or not.
Only on placing new order or any GET/POST request, you will com…
Kite API doesn't support FnO List.
You need to scrap the data from the NSE website.
You may also use the below links,
Html Version : https://howutrade.in/indexdata?data=nse_fut_list
Text Version : https://howutrade.in/indexdata/nse_f…
Logic is same for all exchange.
I suspect the issue might be in KiteXL.
May be Time out happened while downloading NFO symbols.It happens when downloading large data.
All issues will be sorted out in the new rel…
New release will support 3 websocket connections and post-back for order updates.
We hopefully release the new version in two weeks, the project is already delayed by months due to unforeseen issues at our end.
KiteXL will try to download the symbols for all exchanges enabled for the user which is retrieved from https://api.kite.trade/session/token.
Temporary solution is create a text file with name SymbolList_MCXSX and SymbolList_MCXSXFO and…
Try the following;
1. Add the following sites to Trusted Sites in Internet Options --> Security --> Trusted Sites --> Sites and also Un-Check Require Server Verification
Use the below code.
Add reference to 'Microsoft Scripting Runtime' in VBA
Declare the below variable at the top of the module
Public Dict_CapturedValue As Scripting.Dictionary
Copy paste the below UDF to the module.
getOHLC method is not available in KiteXL, even if available it will not fulfill your requirement.
Because, it always returns the Day Open only.
With Historical data, your purpose may be solved, but it will collapse your system when…
The follwing could be the reason,
1. Symbols not download (Pls wait till the symbols are downloaded)
2. Exchange is not enabled for the client (If NFO is not enabled for your account, you will get this error)
3. Corrupted Symbol List fil…
#1 This may be due to Temp Files/Cookies/Cache, most of the time this issue caused by system, so you have to dig out. You may try the below;
1. Delete Temp Files/Cookies/Cache
2. Try running KiteXL in other Laptop/PC, see whether the iss…
#1 This may be due to Temp Files/Cookies/Cache , most of the time this issue caused by system, so you have to dig out. You may try the below;
1. Delete Temp Files/Cookies/Cache
2. Try running KiteXL in other Laptop/PC, see whether the i…
This error happens when the symbol list is not downloaded or partially downloaded due to network issues. KiteXL will download the symbols list only once in a day on first login from kite server and saves the symbol list in text files an…
You need to store the generated the access token and retrieve it on the post-back page.
A simple example would be;
Just write the access token to text file, say my_token.txt on successful login and
retrieve the access token in the po…
It's not controlled by KiteXL instead by kite.zerodha.com
Kite Server stores cookies in user computer which has details of your successful login, sessions etc.
Whenever you open kite.zerodha.com from any web browser, first it checks for the …
UnsubscribeQuotes will work even if your account is logged out.
But the issue is , there is no event that will trigger when your account is logged-out.
You will only come to know when error is thrown while calling order functions.
That's the default behavior of Kite Connect API, you will continuously get data in websocket even you logged-out.
There is no API to check login status.You will to come to know only when error is thrown while placing order or get order book/…
As you already know, excel is single threaded.
So when you get more quotes during volatility, excel may temporarily hang.
No way we can avoid it, but we can reduce it by removing unnecessary formula, getting RTD only for absolutely …
Below is just theoretical calculation.
For streaming through web-sockets
In Full Mode, 164 bytes/sec/scrip(Assume Liquid scrip)
Appx for 6.5 hrs of trading
6.5*60*60 = 23400 sec
23400 *164 = 3837600 bytes/scrip = 3.84 MB/scrip
Appx for who…
Current version of KiteXL is very very limited due to the below factor.
At present, we do not get auto order update from kite server via web-socket(This will soon available as per official note), once we receive order update via web-sockets,…
If you edit vba or some macros throws error, all the variables are re-initialized, that's the default behavior of VBA. To avoid this ensure that all Methods/Functions/Macros are having error handler.
New KiteXL will be out in mid of October.
Point 1,2 & 5 may be caused due to KiteXL.
After you placed a order, KiteXL will check for the order status at an interval of 10sec till the status changes to complete,cancelled or rejected.When you place more order, more loops …
You can download it from here
* Post Order placement, KiteXL will check for the order status at certain interval till the order status becomes complete, cancelled or rejected.You can call the GetOrderStatus function to check the latest order …
I'm not sure what's causing this, it's working fine for me.
Try Stop and Start Web-socket.
You can check the error logs @ "My Documents\KitXL_Error.txt"
Here is how KiteXL and RTD works;
* You subscribe for quotes.
* Kite Server se…