Google Apps update alerts

---

Historical GOOGLEFINANCE data no longer accessible outside of Google Sheets Posted: 27 Sep 2016 04:43 PM PDT 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

Use regular expressions to search in Google Docs Posted: 27 Sep 2016 07:18 AM PDT Starting today, you can use "regular expressions" to more quickly and easily find what you're looking for in Google Docs on the web, much like you can in Google Sheets. With regular expressions, you can search for patterns of text, lists of words, and more, instead of single words or phrases. For instance, imagine you need to find all the US zip codes referenced in a lengthy document. To do so, you can simply search for [0-9]{5}(-[0-9]{4})?. This will identify any zip code in your document consisting of five numbers with an optional hyphen and four-digit add-on. To use regular expressions in the Find and Replace function, type the expression into the Find box and check the "Match using regular expressions" box. For more details, including info on those expressions that are supported in Docs, check out the Help Center. 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: Search and use find and replace 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

You are subscribed to email updates from Google Apps update alerts. To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States