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
0
votes
2 answers

Can you create dynamic formulas in Google Sheets?

So I'm just starting out creating a portfolio tracker within Google Sheets. I'm using the Google Finance methods to get the stocks name and all the relevant data that I need. The only issue is that I can't figure out how to populate the specific…
Michael
  • 1
0
votes
0 answers

Google Finance Error on 1st Jan Calculation

Why is this formula returning N/A ? =INDEX(GOOGLEFINANCE("bsx","price",date(2018,1,1))) Yet it works fine for =INDEX(GOOGLEFINANCE("bsx","price",date(2018,1,2)))
user1438082
  • 2,740
  • 10
  • 48
  • 82
0
votes
1 answer

How can I use Google Sheets to keep a most recent announcement date for tickers I have?

I've got an extensive google sheet file, one of the sheets which are called "Ticker List" has a range of tickers on it. I would like there to be a column in that range which presents the date of the most recent announcement only (column "O"). The…
bart.s
  • 67
  • 6
0
votes
1 answer

Why my XPath and HTML scraping stopped working in Google Sheets?

My XPath queries used to work fine, however, about a month ago (or when Nasdaq moved to a new website. I have to use the old.nasdaq.com since), the just started working irregularly. As you may see on the attached screen, some work, others don't, and…
Al Crow
  • 115
  • 2
  • 7
0
votes
2 answers

How do I get the price of something based on the date in a separate column?

I want to get the price of BTC on a certain date. Column A being this: =GoogleFinance("CURRENCY:USDBTC","close","date") Column B having the list of dates: B1 - 11/02/2018 00:00:00 B2 - 12/02/2018 00:00:00 etc. How do I get this to work? …
Matt Bell
  • 11
0
votes
1 answer

How to use a section of an array without ever printing/showing that array?

I am using a function in Google Sheets that outputs a 2 column array. I want to use data from only the second column of that array to calculate a figure. But I would like to do this all in a single cell and do not want to have to output the array,…
Daniel
  • 1
0
votes
0 answers

Get the exact value from Google Sheets that uses a formula from Google Finance

I'm trying to display in a web page the actual prices of different currencies using ASP .NET and C#. The problem is that if I open my browser with the sheet that my algorithm uses to read values from and the web page that should display it,…
Daniel Bertoldi
  • 359
  • 4
  • 14
0
votes
2 answers

How to get historic VIX data in Google spreadsheet

I could get price of a stock on a data using =INDEX(=GOOGLEFINANCE("AAPL","price","4/26/2019"),2,2) But same formula doesn't work for VIX =GOOGLEFINANCE("VIX") does return current value of VIX. How can I get VIX on a specific date?
kanna
  • 1,412
  • 1
  • 15
  • 33
0
votes
3 answers

Change the delay from 20 to 1 minutes

Quotes are not sourced from all markets and may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice. This advice appears when I use GOOGLEFINANCE() function in…
fgauth
  • 143
  • 1
  • 8
0
votes
0 answers

Add current stock price without updating

I have used this formula to access current stock prices =min(GoogleFinance(A1, "PRICE")) My plan is to use a form to insert a stock ticker and record the stock price at the time of entry onto the Google-sheet. The formula I am currently using…
Luciano F Castelfranchi
  • 38
  • 1
  • 1
  • 12
0
votes
2 answers

Pandas-Datareder does not load Google Finance data

I am trying to download Google Finance data through pandas_datareader. When I execute: import pandas_datareader.data as web from datetime import datetime start = datetime(2018, 1, 2) end = datetime(2018, 10, 12) ms = web.DataReader('MS', 'google',…
Vitomir
  • 295
  • 2
  • 14
0
votes
1 answer

How to write to google finance API?

I know how to read from the google finance api, it is pretty simple. But when I try to write I get the following error: Error: Request had insufficient authentication scopes This is my code: const fs = require('fs'); const readline =…
Jose Montalvo
  • 13
  • 3
0
votes
1 answer

Q: Loop in Google Apps Script Error: Cannot read property "length" of undefined

I got the Error: Cannot read property length of undefined and dont quite understand the problem. From the other posts of stackoverflow I figured out that the function cannot determinate the length of the parsed Object. What I am doing is the…
user8603220
0
votes
1 answer

How do I change the value of a cell based on the day

I need to change the formula in a google sheets cell depending on whether it is a Monday or not. If it is Monday, =min(GoogleFinance(A2, "LOW", Today()-3)) works fine as Today()-3 is a FRIDAY(last trading day). However if it is any other day, i…
pneumatics
  • 2,836
  • 1
  • 27
  • 27
0
votes
1 answer

Reading the values of cells that summarize Google Finance data results via Apps Script

Apps Script seems to be unable to deal with a cell that uses the average formula, when the average is over Google Finance data: Consider that column A is full of data from Google Finance. Then you type into cell B1 =average(A1:A100). Lets assume the…
Cameron
  • 11
  • 6
1 2 3
…
27 28