Send feedback on...
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.
How delayed is GOOGLEFINANCE data? ›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.
What is the alternative to GOOGLEFINANCE formula? ›=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.
How often does GOOGLEFINANCE refresh? ›Widgets powered by spreadsheets using the GOOGLEFINANCE function refresh approx. every 15 minutes.
How do I force refresh data in Google Sheets? ›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.
Why is stock data delayed? ›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.
Is GOOGLEFINANCE data real-time? ›*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.
Is the GOOGLEFINANCE API still available? ›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.
Why is my formula not calculating in Google Sheets? ›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.