Historical GOOGLEFINANCE data no longer accessible outside of Google Sheets


We want to make you aware of a small change to the

GOOGLEFINANCE

function, which makes it easy to pull current or historical securities information directly into your spreadsheets in Google Sheets. Starting today, it will not be possible to download historical data or access it outside of Sheets using Apps Script or an API. If you have a spreadsheet with historical data generated from the GOOGLEFINANCE function and you try to download it or access it via Apps Script or an API, the corresponding cells will show “#N/A.” You will still be able to view that historical data from within the Sheets application, and you will still be able to download current data and access current data via Apps Script or an API. Please keep this in mind when using the GOOGLEFINANCE function going forward.

Launch Details Release track:

Launching to both Rapid release and Scheduled release

Rollout pace:

Full rollout (1–3 days for feature visibility)

Impact:

All end users

Action:

Change management suggested/FYI

More Information Help Center: GOOGLEFINANCE Note: all launches are applicable to all Google Apps editions unless otherwise noted Launch release calendar Launch detail categories Get these product update alerts by email Subscribe to the RSS feed of these updates

Popular Posts:

Samsung’s QLED TVs receive positive feedback from US-based industry trackers

Sony Announces Smaller Digital Paper E-Ink Writing Tablet

Samsung to build a P3 ‘total semiconductor factory’ in Pyeongtaek by 2021

Samsung says upcoming Galaxy M handsets will be better and cheaper

ETCマイレージサービス仮登録完了