Hi, Does Zerodha have any way to return stock data like last price, 52 week prices, dividend yield and value etc for usage from excel or Google sheets?
The report xlsx file from Kite doesn’t include a detailed stock data so I was using Yahoo finance and some Google sheets formulae to build a sheet with data I wanted to track for my portfolio. But lately yahoo finance data is finicky and errors out a lot so I wanted to see if there are alternate sources for this data - Given that Kite is able to show some of this stock data I was wondering if users can access the same via a URL.
you can take help from chat GPT in getting the formulas for google sheets
Example - =GOOGLEFINANCE(B11, “high52”) & " / " & GOOGLEFINANCE(B11, “low52”)
PLz note that these formulas can only fetch NSE symbols not the BSE symbols