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:

Sony Announces Smaller Digital Paper E-Ink Writing Tablet

【オリコ】今月のお引落日は8月31日です

ヨドバシドットコム:「お客様情報」変更依頼受付のご連絡

The Walking Dead No Man's Land v2.0.0.105 APK [MOD]