Google Finance is not fetching stock data. (2024)

FAQs

Why is the GOOGLEFINANCE formula not working? ›

Check to make sure your formula is using the correct syntax as provided in the GOOGLEFINANCE function documentation. Check to make sure that you are NOT making more than 299 requests at the same time. You can do this by getting a count of the number of cells that are using a GOOGLEFINANCE formula.

Standard Attributes

Understanding these attributes is essential for effectively using the GOOGLEFINANCE function to monitor and analyze financial markets: price: the real-time price quote with up to 20 minutes delay.

For those who enjoyed the older version, Google at one time had left it up at finance.google.com. However, if you were hoping to take advantage of the old features, unfortunately, this is no longer an option. As of March 19, 2018, Google officially discontinued the old version.

=YHFINANCE is a spreadsheet formula that allows you to pull the Finance data directly into a Google Sheets spreadsheet. =YHFINANCE formula works in a similar way to =GOOGLEFINANCE for fetching current or historical securities information.

Widgets powered by spreadsheets using the GOOGLEFINANCE function refresh approx. every 15 minutes.

Refresh options.

To the right, under "Refresh options," click the items you want to refresh. To refresh all of the data, at the bottom right, click Refresh all.

Option Chain Google Sheets

To use the 'OPTIONCHAIN' formula: Install the Market Data Google Workspace Add-on. In your Google Sheet, use the formula in the following format: '=OPTIONCHAIN("AAPL","all","1/17/2025")', replacing "AAPL" with your desired ticker, and "1/17/2025" with the specific expiration date.

Fetches current or historical securities information from Google Finance.

Providing real-time quotes takes effort and technology; thus, this service has a cost. If firms don't want to absorb this cost, they'll only offer delayed quotes. Reuters, for example, provides lots of financial information, but its stock quotes are delayed at least 15 minutes.

*Real-time price data represents trades which execute on the NASDAQ and NYSE exchanges. Volume information, as well as price data for trades that don't execute on those exchanges, are consolidated and delayed by 15 minutes.

How do I track stocks in GOOGLEFINANCE? ›

Go to google.com/finance. On the right, under “Your portfolios,” select a portfolio. Under your portfolio name, your portfolio value is displayed. A chart below displays your portfolio balance over time.

Google still offers financial data for use Google Sheets spreadsheets through the use of the GOOGLEFINANCE formula, but the API is no longer available to users.

Essentially, it means Google Sheets can't interpret your formula. It can't fulfill the formula request so it returns an error message. There are a variety of ways this can happen — everything from typos to mathematical impossibilities — and we'll explore them all in detail below.