How to fetch stock price on google sheets using upstox api?

The GOOGLEFINANCE function is exclusive to Google Sheets, enabling users to retrieve financial data like stock prices, exchange rates, and other financial information from Google Finance at https://www.google.com/finance/.

Unfortunately, it is not possible to modify the source of the GOOGLEFINANCE function to Upstox API. If you wish to integrate data from Upstox API into your spreadsheet, you’ll need to rely on Excel’s native features, such as Web queries, VBA, or Power Query (Get & Transform Data). These tools allow you to fetch the required data and seamlessly incorporate it into your Excel spreadsheet.

3 Likes