Get Kite Holdings data in Google Sheets

blazing
Hi, I want to get all my Zerodha holdings data updated in real-time in a Google Sheet that consists all my investments including crypto, US stocks, etc. So my use-case is READ ONLY. I do not want to place any orders or anything else, only update my holdings data, exactly how I see it in my Kite app/website. Is it possible to do this for free or do I have to pay 2000 credits every 30 days?
  • sujith
    One can only fetch data if there is an active Kite Connect subscription.
  • sujith
    You can read more about Kite Connect on FAQs.
  • nrajesh
    nrajesh edited March 1
    @blazing looks like we are sailing the same boat! I wish there was some way to use kite connect API to get our own trade data, at least once every a day, for free!

    It may prompt beginners to invest more time to understand API usage better and, who knows, actually subscribe for credits. This may also be a good freemium model for @kiteapi team to explore.
  • sujith
    @nrajesh,
    You can go to Kite web and download the orderbook using the top right icon.
  • nrajesh
    Thanks Sujith for the suggestion.

    My request is more from programmatic point of use.
  • Gianna99
    thank you guys
Sign In or Register to comment.