Using =FINANCE_FETCH('ETF_GLD') in Sheets now returns an exchange access error. Similarly, =IMPORTFIN('ETF_GLD') fails for ETFs. Any reliable way to pull Yahoo Finance data?
My experience led me to experiment with a custom Google Apps Script that accesses the Yahoo Finance JSON endpoint. Instead of relying on built-in functions, I developed a script that sends an HTTP request and parses the response, thus bypassing issues with the deprecated functions. Although it required some initial effort to set up error handling and maintain the API calls, this method has consistently provided real‐time and accurate ETF data. It is a pragmatic solution if you are facing persistent exchange access errors.
hey alice45, i tried a custom importjson trick from a github repo that hits an alternate data provider. setup a periodic refresh in sheets and its worked fine for etfs even with some quirks. hope this helps!
My experience with pulling financial data for ETFs in Google Sheets was less than satisfactory using the built-in functions. I once encountered a similar issue where the functions either returned errors or simply failed upon repeated use, so I turned to a workaround. By combining IMPORTXML with carefully crafted XPath queries to extract data from Yahoo Finance, I managed to create a more dependable solution. Although this method required some initial tweaking and occasional adjustments to the XPath expressions, it has provided consistent and reliable results when I needed it most.
hey alice45, try using importhtml to scrape data directly from yahoo finance pages. its a bit flaky sometimes, but since it bypasses some of the finance_fetch issues, its worth a shot though. gives me decent results in my sheets
In my experience, relying directly on finance functions like FINANCE_FETCH or IMPORTFIN for ETF data has proved to be inconsistent over time. A more reliable approach has been to use a custom importer script that fetches data from Yahoo Finance’s unofficial API. I customized a Google Apps Script to automatically pull information and then update the sheet. It required some setup and maintenance but provided more dependable results for ETFs. It is worth investing the effort if you need regular and accurate ETF pricing data in Google Sheets.