LIVE OHLC data

santoshnikam4
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?
Sign In or Register to comment.