How to fetch realtime stock / share prices in Excel via Power Query from Zerodha API скачать в хорошем качестве

How to fetch realtime stock / share prices in Excel via Power Query from Zerodha API

Tutorial demonstrating how to pull live market prices from NSE / BSE exchange into Excel by utilizing Zerodha Kites Connect API platform feeds. Technique sends HTTP requests to Zerodha API server which returns LTP (Last Traded Prices) for specific list of shares / securities using Power Query script. Sign-up for Zerodha Kites Developer platform is required for API access which is a paid service. User needs to create app on developer platform to generate API key (user id) and API secret (password). Ensure you have demat account. Two steps of authentication are used: 1) Browser based (via authentication page) to generate request token 2) Local PC based (via PowerShell script) to generate access token GitHub project link (for PowerShell script): https://github.com/dhananjay1405/exce... Zerodha API developer page: https://developers.kite.trade Authentication Page URL (link): https://erpcloudanalysis.in/utility/z... Redirect URL for Zerodha App https://erpcloudanalysis.in/utility/z... 0:00 Intro 0:33 Setup (one-time) 5:11 Authorization / Authentication (daily) 10:45 Fetching LTP in Excel via Power Query 16:59 Closing Remarks