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

Currently i am using google finance function on google sheet to track the whole NSE equity LTP.

Hi @Pradhan

Thanks for your query. Let me check this with the team and I will get back to you shortly.

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

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.