LIVE OHLC data

santoshnikam4 · April 2020

Can someone assist me to get OHLC and volume data in excel from Zerodha Kite.

I am getting an error "status":"error","message":"Invalid `api_key` or `access_token`.","data":null,"error_type":"InputException""

I am trying to use below URL to get JSON data

https://kite.zerodha.com/oms/instruments/historical/14352642/15minute?user_id=RS2227&oi=1&from=2020-04-16&to=2020-04-23&ciqrandom=1587603712671

How can I pass api key to url in excel vba?

sujith · April 2020

You need to pay and subscribe to Kite Connect to use historical data API and not scrape the data from the trading platform.
Thank you

harshpnd3 · August 2020

well if you just want to push live data to excel try this.
https://t.me/robocopfree