April 2008
Intermediate to advanced
384 pages
15h 52m
English
Content preview from Google Apps Hacks
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
56 GOOGLE APPS HACKS
The GoogleFinance function is essentially GoogleLookup’s older sibling, but it provides nance data
only. As with GoogleLookup, you need to provide two values, but they’re called symbol and attribute
this time:
=GoogleFinance(symbol, attribute)
For instance, to nd out the current price of Yahoo stock, you would write:
=GoogleFinance("YHOO", "price")
This function returned “23.25”, as shown in Figure 3-5.
The stock price value comes with a delay of up to 20 minutes, according to Google. Some of the
other attributes you can use are:
The opening price of the stock for the day
The highest price the stock traded for the day
The lowest price the stock traded for the day
The number of shares traded of this stock for the day
The current market cap of the stock
The last time this stock traded
The 52-week high for the stock
The 52-week low for the stock
The quantity of shares outstanding for the stock
The currency in which the stock is traded
For a full list of available attributes, you can search the Google Docs help le for “GoogleFinance.”
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.