Technically, this is possible using Excel VBAs. Example -- http://stackoverflow.com/questions/158633/how-can-i-send-an-http-post-request-to-a-server-from-excel-using-vba
1) No. Exchanges do not release EOD minute data.
2) If you're referring to WebSocket tick data, they're "so far" fields and are relayed by the exchanges and not computed at our end.
Hi Prem,
We've disabled transmitting mock ticks over live connections owing to large number of user complaints. We'll be bringing this back shortly in our upcoming sandbox environment and making it available to developers.
@madhusudhan.maddula That is not correct. Once you get the request_token, you have to exchange it for an access_token using your secret key and creating a checksum using SHA-256. Please read the documentation where this is explained in detail or loo…
@menaveenn Of course you need a subscription. Please refer to this: https://kite.trade/forum/discussion/727/note-for-users-experiencing-invalid-api-credentials-for-accessing-historical-api#latest
@botany02 I recommend you use an existing library (there must be a 3rd party version) or you will have to implement the entire WebSocket protocol spec (https://tools.ietf.org/html/rfc6455)
I don't think this will be of any help, but here are the he…
@kumar_krishnan Historical data has always been a separate addon to Kite Connect. You were not meant to pull data from it without subscribing to the Historical addon (but as I said, we'd left it open for a while for technical reasons).
I'm afraid i…
@botany02 Are you using a library that supports the WebSocket protocol? Simply sending the headers is not enough to establish a WebSocket connection.
Does this help? https://msdn.microsoft.com/en-us/library/system.net.websockets.websocket(v=vs.110)…
@apind81 @virtualKG -- you guys do not have the Historical data API subscription
@kumar_krishnan - you haven't created a Connect app. You only have the publisher app. Unless you create a Connect app, you will not get access to any APIs.
I'd like t…
Please throw away whatever access_token you have been using to access historical data until now. You need to do a fresh login, get a brand new access_token, and pass this new access_token to the historical APIs and it should work.
@charuvindatre We've looked into this and it turns out that the exchange is indeed sending gibberish valures in tick packets for EQ premarket scrips. NEST also shows the same invalid values and we're assuming all trading platforms will.
We're addin…
@rsekar It's not an error. It's just the welcome message the root endpoint of the API gives -- https://api.kite.trade
It just means that for some reason, your request is being redirected to the root endpoint.
Apologies, it was an error on our part. Here's the language from the exchange documentation. We've updated our API docs accordingly.
TotalBuyQuantity This field contains the total quantity of buy orders in a security.
TotalSellQuantity This field co…
@dummydost This is definitely not normal. What browser / OS do you use? It could be that your implementation is stressing resources (CPU, mem) and slowing down the browser.
@dummydost This only applies if you are distributing the apps to public. If it's your private setup, there are no issues.
Embedding API key in distributed apps is fine, but you should never hardcode the secret key. It'll be easy to peek inside your…
@arunk Kite Connect is purely an execution library (place/manage orders, retrieve positions and holdings, stream live data etc.). Any sort of strategies or analysis, you have to develop on your own in whatever language you prefer (Python will make i…
PiBridge uses a TCP protocol to enable communication with external clients, which means you can use any programming language to connect to it, not just Python.
No, pyKiteConnect is only for interfacing with Kite Connect.
@apind81 I'm afraid general programming questions are out of the scope of this discussion. We can only consider questions directly pertaining to our APIs.
@AutoTrade
@sameer The regulations differentiate between automated algorithmic trades and programmatic trades using APIs. Please e-mail [email protected] for further clarification.
You download the Kite Connect library and run it wherever you want, on your desktop or your own VPS.
"Q" is our back office portal. It is not related to our APIs in any way.
@AutoTrade I'm afraid that is outside the scope of this thread or the support we can provide.
You may start a new thread on the forum and see if someone's able to help out.
1) If you have enough credits (after the first payment) left in your account for the second renewal, they will be deducted and your app renewed for the second month.
2) If you have linked your Zerodha account (on the billing page), funds will be ded…
1) You can do that for the time being. We're working on including timestamps in the stream.
2) This is how exchanges broadcast the data. OHLC is for the day. You should use the LTP field to compute your own OHLC.
We're working on a free sandbox environment but it's still some time away.
If you do not deposit any extra credits in your account, your apps will not be auto renewed.
@Dharanikotaarunkumar Yes. If you are going to run automated algorithmic trades, you need approvals. Please e-mail [email protected] to find out more.
@AutoTrade Signup here https://developers.kite.trade
@nilesh.kute2008 You will have to do these computations yourself. Kite Connect is an execution platform. You have to write the analyses yourself (numpy, R etc.).
@Prem The login flow requires a redirect url. However, as stated in the documentation, it doesn't have to be a valid website, if you are using it privately. It can be anything. eg: http://127.0.0.1 or https://kite.trade or even https://google.com
J…
@fury1984 What instrument are you subscribing to?
@botany02 I thought this issue was fixed a couple days ago? We'll create the category once the client is out to avoid confusion.
The positions payload has two parent keys, "net" and "day". So the loop should be like this:
foreach($array->net as $obj) { ...
Also, there is no "net_buy_amount_m2m" field. It'd just be $obj->buy_m2m.
@bnraju85 Of course it is possible. Any application that can make HTTP requests can work with the Kite Connect APIs.
We're releasing a Java library to make things simpler shortly. You may be able to port this into an Android SDK.
Please use one of our official libraries with streaming support (Python or NodeJS) or refer to the documentation to make your own implementation https://kite.trade/docs/connect/v1/#streaming-websocket
@rahulchitale We're releasing raw margins data as a part of the /margins APIs as a part of Kite Connect in the next 1-2 days.
PS: You can just strip out :EQ
Hm, that's strange. The feed on kite.zerodha.com and the feed you get are exactly the same. Can you share the VB code where the unpacking is happening?
Also, 65536 is what you get when a 16 bit int overflows. Are you sure you're casting those value…
You should take a look at our official Python / Javascript (Node) libraries. You should be able to run those libraries as stand alone servers (on any platform) and have them push the quotes to a file or a database.
If you really need it in PHP, it…
@pivottrading.net This is not possible right now. However, we're releasing a new API next week that'll let you tag your orders with arbitrary strings (like a custom ID). That should help you filter out orders placed by the API.