@Kailash
I didn't get you on Market Quote API.
What is the targeted use?
We already getting market quotes via web-sockets
Below is my understand
Market API can be used where you occasionally require the latest price for your analysis and don't n…
@arjunmurali1993
Yes, KiteXL returns only completed Order Id's.
KiteXL is not updated for a very long time as we waiting for the most important update from Kite Team .. i.e Order Update and Trade Update via Webscokets.
We almost dropped the KiteX…
@k365
Try this..
1.Ensure you are running your application as Admin.
2.You added the below urls in the trusted sites in Internet Options.
https://*.zerodha.com
https://*.kite.trade
https://redirecturl.com
3.Try login in internet expl…
Hi @sujith ,
We are not facing any quotes delay issue at our end except at some times rarely.
We are not storing the data, so we will not able to check it.
But We will check it tomorrow, by logging data.
If anything found, we will update this thread.
@khushisoni894
Below is the average time taken from Order Place to Order Confirmation(Client-->OMS-->Exch-->OMS-->Client).
PiBridge - 40ms
Nest Plus - 40ms
Kite Connect - 200ms
P.S. The above is when the OMS is not having much load. D…
@dazzlewow
What error you are getting..? You should mention all the details of the parent and child order (OrderId,Symbol, Price, Qty, Stop-loss Price etc).You must post your actual code snippet where you are placing CO, retrieving ChildOrderID an…
@paragsatpute
Yaa.. its true..you never put your api_secret in such a way that is accessible or visible to everyone.
But KiteXL is intended to be use for personal.So until unless your pc is compromised,there will be no issue.
KiteXL Spreadsheet i…
@unoffocial
Yes, You can convert a LIMIT Order to MARKET Order
Below possible conversion
LIMIT --> MARKET
SL-M --> LIMIT
SL-M --> MARKET
SL --> LIMIT
SL --> MARKET
Below is not allowed.
LIMIT --> SL-M
LIMIT --> SL
@dagamshiva
Open a A/c in Zerodha if not already
Signup @ https://developers.kite.trade if not already.
Create a Kite Connect App (Rs2000/pm){Real-time Data, Order Placement, Account Access)
Kite Connect App is nothing but just a subscription, on…
@arjunmurali1993
The logic is correct..
But Point 2 may not work. If You used vba to write Order Id to cell Values & using that value
in getOrderStatus, then the Function will not be recalculated by Excel as no parameter is changing or dynami…
@Prathap
From Zerodha's Perspective, It's grey area....
You are neither permitted nor denied..
Its up to you...
You can refer the below link...
https://tradingqna.com/t/is-there-a-way-to-completely-automate-trading-on-zerodha
https://kite.trade/f…
@arjunmurali1993
Good, you finished your workaround.
But writing data to sheets, will be less efficient.
Instead, You can try using MS Scripting.Dictionary to store last 'n' period values and find average of that 'n' period.
@myadav
You need Kite Connect API (Rs2000/pm).
Publisher key will not work with KiteXL.
You will not be able to login with publisher key and only after successful login, you will be able to use all feature including downloading symbols.
You can imp…
@myadav
This error indicates that the DLL files are not registered or registered wrongly.
Close all the Excel if Running and make sure that Excel.exe is not showing in Task Manager Process.
Download the Raw DLL files from https://www.howutrade.i…
@Newtrade
Pls delete the symbols list from the bin folder.
Relogin again to download fresh list from kite server.
Sometimes, due to network congestion or similar, before completely downloading the list, kite server abruptly disconnects,Thu…
@joy
Yes, You are correct.
Here how it works,
when you place a SL-M or SL order, this orders will stay within the OMS and not sent to exch where as LIMIT & MARKET Order are sent immediately to exch and exch will allot the Exch Order Number.
…
@vickydeepi
We have updated the installer to support MS Office 64bit.
Re-download the installer @ https://www.howutrade.in/docs/KiteXL/html/KiteXL_Setup.exe
and run as admin.
Let us know, whether it worked or not.
@kitcosree
We have re-compiled our installer and tested at https://www.virustotal.com/
Now McAfee will not block the installer. Our installer has 2/60 detection ratio.
Currently kite API doesn't support multi leg orders.But that's not the limitation. You can construct your own multi leg order and place in KiteXL.
You can place multi leg orders from KiteXL but subject to maximum throttle limit of kite server.
…
Is NFO & MCX enabled for a/c???
If yes then, symbol list will be automatically downloaded post login.
You should wait till download finishes.
First download will typically take time between 1-10 mins depend on your net speedy.
Have u added your redirect url to
Trusted sites in Internet Options by doing as follows.
Control Panel-->Network and Internet-->Internet Options-->Security-->Trusted Sites-->Add this website ???
@Krishan007
You can place, Modify and cancel orders with KiteXL.
It supports most of the functions of a trading terminal..like order book etc..
Pls refer our documentation for more info .
https://www.howutrade.in/docs/kitexl/
@Ami
The size of the instruments list is appx 6.5MB..
Download time will depend on your internet speed..
In my system, it takes only < 30s to download..(10Mbps)
@jasdeepwalia
Just checked the SymbolList_NSE.txt file, 'NIFTY BANK' symbol is present there.
Working fine on my side...
May be some unknown issue...
As a workaround manually add the symbol details to text file..
Add the below line to SymbolList_…
@pawandev
I'm Fine..
At-present, no method is available to calculate Margin/Leverage.
I'm updating the library which will have functions for Margin/Leverage.
Thanks
Yes Trailing stoploss also absolute value..
Yes, You can place orders directly from the Excel itself
when you call the Function PlaceBO from the cell, your order will be directly placed and will return order number.No other required.
Note:- Strings …
@pawandev
This error occurs when there is network disconnection between the client and kite server.
The most two common reasons
1.your network problem
2. Kite server close the underlying connection.
If your network is good, then …
@kitcosree
I'm not sure,why McAfee reports our site as risk.
But we are not collecting any personal and financial information through our site.
our library's are safe to use.
You can scan @ virustotal.com(multiple AV scanner).
You can als…
@chotabheem
Public Function PlaceBO (
Exch As String,
TrdSym As String,
Trans As String,
Qty As Integer,
LmtPrice As Double,
SqOffValue As Double,
StoplossValue As Double,
Optional TrailValue As Double = 0
) As String
SqOffValue & S…
@pawandev
If i'm correct, you will be getting this error for NSE...
Bcoz, We too getting..
We found the issue, Kite Server is returning less number of symbols for exch 'NSE'
May be something wrong at Kite Side, Bcoz other exch symbols are correctly…
@YOGESH
Pulling Order Book or Trade Book in real time is never possible.
Your approach will not work..
With built in Excel Formula, I'm afraid you will never make it..
You have no option other than using VBA.
@chotabheem
I just used your code...works fine at my end..
the loop is automatically ended when download is finished..
Dim Kite As Kite = New Kite
Sub Main()
Kite.Api_Key = "xxxxxxx"
Kite.Api_Secret = "xxxxxxxxxxx"
K…
@chotabheem
Just checking this...at my end..
But it should not happen like this...
Once the download is complete, the Instruments_Download_Status property will become TRUE,
thus it will end the loop.
@chotabheem
If your net speed is slow then it will take little bit time to download (Appx 6.5mb).
So please wait till that...
Are you sure, the loop continues after all symbol list downloaded...?
May be the list is downloaded in past...So KiteDot…
@quicksilverm
Kite will try connect to your post-back url in port 443,before saving your app details.
This is to make sure that your post-back url is valid and use https.
So,Your webserver should listen on port no 443.
Are you sure you added neces…
@YOGESH
Here is the code to restrict order placement.
Below code will restrict multiple orders.. and works as follows..
Example:-
If you placed a BUY order in AXISBANK, it will not place a another BUY order until a SELL order is placed after BUY an…
@YOGESH
That's risky..Pulling Trade Book & Order Book in real-time will result in error.
If you want to know the order status you need to use post-backs
@YOGESH
For restricting order placements, we need to use VBA.
I'll modify the place order function to restrict multiple order placements even if the cell formula is recalculated.
will post the code later.
@vivek
The order was actually executed,but kite server thrown exception instead of returning success with order number.
And also, postback order update was not sent from kite server for the same order.
Could you pls look into this?
I …
@Kailash @sujith
I'm also facing network exception with message Couldn't connect to nest gateway while placing orders. This happens especially during the first few minutes of market hours and earlier I didn't face such issue.
Is this bcoz of…
@HDave
Thanks...
Most probably will update in 1-2 weeks..
Just redefining the entire library which will have raw functions only.
No mandatory calls, Exceptions and validation of parameters.
For Example:- If you have access token, you can just call …
@HDave
KiteConnect is designed in such a way that you need to login either in Web Browser Control or Normal Web Browser to get request token.
The Ultimate thing is that the user has to login at Kite Server.
I'm not familiar with Asp.Net or We…
@randhawa_125
Possible Cause......
1.You are logging with a Client Id which is different from what you have in your Kite App.
Go to Kite Developer A/c & Check what Client id you have linked with your app & try login with the same client Id.…
@nldeshpande
That's Great.. You got solutions...
Your Initial Error was due to the fact that..
Sheets("OrderBook").Cells(i, 1) returns Object
So,
Call Sheets("OrderBook").Cells(i, 1).Value --> which will return exact cell value.
So no need t…
@nldeshpande
Could You Pls post the Entire Code...?
Try calling the Function by passing the exact OrderId like x = ExitBO("1645555000","165822222")
If the above works than your code might be creating problem.
@YOGESH
You can do most of the things that are available in trading platform (like order book, trade book, position conversion etc) in KiteXL.
Regarding basket order, you can do that with VBA. If it is difficult in VBA, you can do that in some …
@seveera
Ideally, it should work fine.
Could You pls tell, how many stocks you added...?
Have you changed the throttle interval...in Excel...?
Anyway, We are updating KiteXL with latest Kite Connect Updates, and let you know once done.
@seveera
Some thing went wrong in registry..
Do as follows for clean install.
1. Close Excel if Running
2. Press Windows Key + R ( To open Run)
3. Type regedit and press Ok ( To Open Registry Editor)
4. Navigate to HKEY_CLASSES_ROOT\KiteXL.Kite
…