Stack Overflow
Stack Overflow

Questions tagged [google-finance]

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. Use with tags(eg: [google-sheets-formula]), where the service is involved.

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. However the service is still running. Limited programmatic access is also available through

Official Website

417 questions
1
vote
1 answer

Transpose 2 Columns into 1 Row, Google Sheets

The Google Sheets formula below is located in column A1 of my Google Sheet. This formula creates data in column A & B. I need to transpose this data into 1 row…
westman2222
  • 663
  • 1
  • 12
  • 30
1
vote
2 answers

Filter the Google Finance formula to only display the "high" of all time

It's in reference to the Google Finance function in Google Sheets: https://support.google.com/docs/answer/3093281?hl=en I would like to obtain the "all time LOW" (ATL) and "all time HIGH" (ATH) for a specific ticker (i.e. ABBV or GOOG) but only in 1…
DebugMeIfYouCan
  • 25
  • 1
  • 4
1
vote
1 answer

Google Finance get year to date spreadsheets

I'm using Google Sheets to get stock data from Google Finance, how can I get Year to day percentage change?
Fede
  • 1,656
  • 4
  • 24
  • 42
1
vote
1 answer

Convert this formula into arrayformula

short and simple, how can this formula be rewritten into array formula variant? Thanks =iferror(if(and(GOOGLEFINANCE(B2, "High")>=D2+Now()-Now(), GOOGLEFINANCE(B2,"Low")<=D2),"Filled",if(F2<0.005, "In Threshold",if(and(E2="Long",…
Kevin Hunter
  • 39
  • 5
1
vote
1 answer

Sheets API v4 is returning #N/A for specific formulas

Sheets API v4 is returning #N/A when using vlookup formula. This specific error is happening with vlookup formula, but I have seen this very same issue on spreadsheets contains a big number of formulas. Seems like the API does not wait for the…
Rafael De Alemar Vidal
  • 163
  • 1
  • 12
1
vote
1 answer

How to get Value from a cell with formula?

I have a formula in a cell (18,2) which is =(B17-B14)*B15+B17. So what you see if a numeric value. But when I tried to use the following script to fetch the value to a new cell, it put #num in the new cell. I tried other cells with formulas, when it…
Kele Ding
  • 9
  • 4
1
vote
1 answer

import index XAO price into google sheet

I'm trying to load the asx all ords (INDEXASX: XAO) price into a Google sheet cell. Most stocks return a result like BHP below, but cannot get an index like XAO to work. =googlefinance("asx:bhp", "price") This works for…
CMM
  • 13
  • 2
1
vote
1 answer

Refresh live Google Finance data prior to reading value

I am trying to copy content from one column to another. Source column has formula based content like =GOOGLEFINANCE(SYMBOL,"PRICE") which gets updated every minute. I have created trigger which runs for every 5min. But while copying it doesn't copy…
Sunil B N
  • 4,159
  • 1
  • 31
  • 52
1
vote
1 answer

Add text to the output of values of an array

I just started to learn Apps Script and I need to add some text to each value of an array. This code just puts the values in another column: function getData() { var sheet1 = SpreadsheetApp.getActiveSpreadsheet() .getSheetByName("Stocks"); …
Anna
  • 13
  • 2
1
vote
2 answers

Google finance Currency converter not working

My Code for currecy converter using google finance is not working $amount="10"; $from="USD"; $to="INR"; $data = file_get_contents("https://finance.google.com/bctzjpnsun/converter?a=$amount&from=$from&to=$to"); preg_match("/
David Ninan
  • 47
  • 8
1
vote
3 answers

Google Finance error: invalid literal

I was trying to work on a person project (stock market predictions) for school, when Google started acting up again... I realize that Google Finance has been complete garbage this past year, but it still seemed to be working somewhat up until this…
Raksha
  • 1,572
  • 2
  • 28
  • 53
1
vote
1 answer

Debugging ImportHTML

I'm trying to create a dividend tracker in Google Sheets using the ImportHTML function. This URL: https://www.google.com/finance?q=VZ works fine in the browser, but gets an error in ImportHTML claiming that it cannot fetch the URL (that just…
Ray Salemi
  • 5,247
  • 4
  • 30
  • 63
1
vote
1 answer

GOOGLEFINANCE function - specific instrument returning #N/A

I am trying to use the google finance function within Google Sheets to return the share price for Vital Healthcare Property Trust which is listed on the New Zealand stock exchange. Here is the instrument in question:…
Jake McInteer
  • 11
  • 1
1
vote
0 answers

Google Spreadsheet: Calculate Total Dividend generated from a particular date

I am trying to calculate dividend earned from a stock since it was bought (i.e. from a particular date). Is there a way to calculate sum of every dividend paid out by company since particular date? For simplicity, lets assume that shares were…
alwaysAStudent
  • 2,110
  • 4
  • 24
  • 47
1
vote
2 answers

Google Finance currency converter issue in rails

I am working on Google currency converter but it's not working. It just redirects to: http://finance.google.com:80/bctzjpnsun/converter?a=1&from=EUR&to=USD or it's gives error 404 Not Found This my code: gem file: gem 'money' gem 'google_currency',…
Hardika Desai
  • 83
  • 1
  • 14
1 2 3
…
27 28