If i am planning to use VBA for Kite connect, 1. what should i choose on the create app page. Publisher or kite+publisher and what is the difference. 2. For excel based connection what should i put under Redirect URL, Post back URL 3. Do i need to set timer to get live/refresh streaming data.
1) Publisher is for embedding trade buttons on webpages. You will need a Kite Connect app to place orders programmatically.
2) You can either run an http server somewhere to capture the request_token or provide a dummy domain (like https://kite.trade) and when the redirect happens, copy the request_token manually.
3) Streaming data is delivered over WebSockets. You will have to build a WebSocket client to receive the data and push it to Excel.
2) You can either run an http server somewhere to capture the request_token or provide a dummy domain (like https://kite.trade) and when the redirect happens, copy the request_token manually.
3) Streaming data is delivered over WebSockets. You will have to build a WebSocket client to receive the data and push it to Excel.