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:

26 temporarily free and 41 on-sale apps and games to start the week

-
Image
... It's the week before Christmas, so I hope you all have gotten your shopping done — I did mine yesterday. Whether you've finished yours or are still stressing about it, take some time to browse through the app sales list for today. While there isn't much that's particularly noteworthy, you might find something to enjoy. Free Apps Genetic Helper $0.99 -> Free; Sale ends in 2 days Passwords Manager : Store & Manage Passwords. $3.49 -> Free; Sale ends in 3 days Note Recognition - Convert Music into Sheet Music $3.49 -> Free; Sale ends in 6 days My Sheet Music - Sheet music viewer, music scanner $2.99 -> Free; Sale ends in 7 days Games Ancient Tomb Adventure - Labyrinth Puzzle & Riddle $0.99 -> Free; Sale ends in 2 hours Cashknight ( Duo Event Version ) $9.99 -> Free; Sale ends in 2 hours Tap tap cartoonist - Cartoon999 (VIP) $0.99 -> Free; Sale ends in 1 day Co...
Continue Reading....

Samsung Display remains the leader in global display market

-
Image
The latest data from IHS Markit shows that Samsung Display has retained its dominant position as the top global smartphone display vendor in the first quarter of this year. It was able to do that as more smartphone manufacturers opted for OLED panels for their premium devices. Samsung picked up the bulk of those orders. Samsung's display affiliate is estimated to have shipped $3.4 billion worth of smartphone displays in the first quarter ending March 2019. It accounted for 40.2 percent of the smartphone display market in this period. Samsung Display also accounted for 80 percent of OLED panel supplies. Samsung Display retains its leadership It's pertinent to mention here that Samsung's Q1 market share is 6.6 percentage points lower than it was in the same period last year. However, the company has been able to keep its market share over 40 percent for eight consecutive months. None of its competitors are even close in terms of market share. Japan Display came in sec...
Continue Reading....

Wide Color Photos Are Coming to Android: Things You Need to Know to be Prepared

-
Image
Posted by Peiyong Lin, Software Engineer Android is now at the point where sRGB color gamut with 8 bits per color channel is not enough to take advantage of the display and camera technology. At Android we have been working to make wide color photography happen end-to-end, e.g. more bits and bigger gamuts. This means, eventually users will be able to capture the richness of the scenes, share a wide color pictures with friends and view wide color pictures on their phones. And now with Android Q, it's starting to get really close to reality: wide color photography is coming to Android. So, it's very important to applications to be wide color gamut ready. This article will show how you can test your application to see whether it's wide color gamut ready and wide color gamut capable, and the steps you need to take to be ready for wide color gamut photography. But before we dive in, why wide color photography? Display panels and camera sensors on mobile are getting better an...
Continue Reading....

T-Mobile starts rolling out Android 10 update to Galaxy Tab S6

-
Image
Samsung started the rollout of Android 10 to its current-generation flagship tablet, the Galaxy Tab S6 , three months ago. One month later, Verizon released the Android 10 update to the Galaxy Tab S6 on its network. Now, T-Mobile has released the Android 10 software update to the tablet on its network in the US . The new software update with firmware version  T867USQU2BTE1 brings Android 10 to the LTE variant of the Galaxy Tab S6 (SM-T867U). It also features One UI 2.1 and the May 2020 Android security patch . The file size of the update is over 2.1GB, so we would advise you to use a Wi-Fi connection to download the new software. Although T-Mobile's changelog doesn't mention new features, the Android 10 update brings smoother animations and transitions, Google's gesture-based UI navigation, improved Dark Mode, tweaked color scheme and icons, and more. Then there's an improved camera app and a refreshed design inside the Device Care section. Thanks to One UI 2....
Continue Reading....

Gear S3 frontier update patches major S Voice bug

-
Samsung released a much-requested update for the Gear S3 frontier on Wednesday. The upgrade has been designed to patch a major bug that resulted in S Voice crashing whenever it was toggled — and from what we can tell, it’s working. The glitch itself has been running riot since May, which is around the same time the device received a routine maintenance update , leading us to believe a faulty line of code was the reason S Voice was unable to run without breaking down. Related: Gear S3 Frontier update is small, brings Jansky wearable Not all customers were affected by the glitch in the same way, though. Some noticed that the performance of S Voice suffered when asking it to retrieve information from the internet, like a weather forecast, but it never crashed. It’s all a little strange, but it’s nice to see Samsung release an update to fix the issue. We’re just hoping we don’t have to wait too much longer for it to arrive on all compatible units, seeing as it isn’t showing up in th...
Continue Reading....