☰
›

Excel VBA- HTTP request

santoshnikam4
santoshnikam4 in Mobile and Desktop apps
Hello,

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
    sujith
    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
  • santoshnikam4
    santoshnikam4
    Hi Sujit,

    Can you please give more details how it will work after subscribing to kite connect. would it be possible to get current candlestick data into excel. if you have related document can you please share. that will great help.

    Thanks.
  • sujith
    sujith
    You can check with @HowUTrade, they have written the excel library.

    For Kite Connect subscription details, you can check out this thread.
Sign In or Register to comment.