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

Developer API
,
1

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

image
image311×672 23.8 KB

2

Hi @Pradhan

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

3

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
4

Have you find out live data in to google sheets ?

5

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 from API (in this case Upstox API) and seamlessly incorporate it into your Excel spreadsheet.