Menu
Anyone know workarounds to make GoogleFinance actually work? It works for a while so it is not a problem with my formulas but then periodically the cells that were showing stock quotes suddenly show "#N/A" and if you hover over them it shows that GoogleFinance experienced an internal error. It's really buggy. Changing the refresh interval doesn't help, in either direction. Anyone know workarounds to avoid the errors and have the spreadsheet simply show (and keep showing) the stock quote data without the errors?
667
Widgets powered by spreadsheets using the GOOGLEFINANCE function refresh approx. every 15 minutes. If this isn't fast enough for your needs – and your G Suite account allows it – you can write a script that can further reduce the refresh times.
If you are looking to get the real-time dividend yield of any stock listed across 50+ covered exchanges, you can do so very simply by entering the function =WISE(“ticker”, “dividend yield”, “ttm”). As you can see, the function returns the latest dividend yield based on the last dividend payment and current stock price.
*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.
you can either use alternative to GOOGLEFINANCE (depends on what exactly are you up to)
or if you want to stick with it you can wrap it into IFERROR:
=IFERROR(GOOGLEFINANCE(your_formula_here), GOOGLEFINANCE(same_formula_here))
or even:
=IFERROR(IFERROR(
GOOGLEFINANCE(your_formula_here),
GOOGLEFINANCE(same_formula_here),
GOOGLEFINANCE(same_formula_here))
You could add a script to your spreadsheet (Tools/Script Editor) and use the CacheService (https://developers.google.com/apps-script/reference/cache) to cache Google Finance results. Cache data when it is available, use the cache when there is an error.
See https://developers.google.com/apps-script/quickstart/custom-functions for how to write custom functions for Google Sheets.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
