App script code to access google finance stock data.

[Lalit Kumar]

I am using = GOOGLEFINANCE() function to access stocks data in Google sheets..

For some analysis and data extraction, i need to get google finance stock price using Google Apps Scripts but i am not able to find any similar function or options in Google Apps Scripts to do so, need urgent help on this.

[Tanaike]

In your situation, is this information useful? https://tanaikech.github.io/2022/05/18/report-obtaining-values-from-googlefinance-using-google-apps-script/

[Nerio Villalobos]

To retrieve stock price using Google Apps Script, you can use the UrlFetchApp service to make a request to the Google Finance API and parse the JSON response to extract the price.

Here's an example code snippet to get the stock price of Apple:

function getStockPrice() {
  var symbol = "AAPL";
  var url = "https://finance.google.com/finance/quote/" + symbol + ":NASDAQ?output=json";
  var response = UrlFetchApp.fetch(url);
  var content = response.getContentText();
  var json = JSON.parse(content.substring(6));
  var price = json[0].l;
  return price;
}

In this example, the symbol variable is set to "AAPL" for Apple, but you can change it to the stock symbol of your choice. The url variable is constructed with the symbol and the exchange (in this case, NASDAQ), and the UrlFetchApp.fetch() method is used to make a GET request to the URL.

The response content is then parsed as JSON using JSON.parse() method, and the price is extracted from the parsed JSON object using the l property.

You can then call the getStockPrice() function in your Google Apps Script to retrieve the stock price.

El dom, 2 abr 2023 a la(s) 14:36, Lalit Kumar (idl...@gmail.com) escribió:

I am using = GOOGLEFINANCE() function to access stocks data in Google sheets..

For some analysis and data extraction, i need to get google finance stock price using Google Apps Scripts but i am not able to find any similar function or options in Google Apps Scripts to do so, need urgent help on this.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/2aa25e6b-b768-4b17-b50f-2ecea73ee503n%40googlegroups.com.

--

__________________________

Nerio Enrique Villalobos Morillo

+54 9 11 68851063 

Buenos Aires, Argentina