jump to navigation

Cool New Feature in Google Spreadsheets October 2, 2007

Posted by fvter in Technology, Web.

This morning I was perusing and updating one of my Google Spreadsheets when I discovered two new functions that make Google Spreadsheets Internet smart!
The description on Google reads:

Two new functions bring the power of Google directly into your spreadsheet. The GoogleFinance function retrieves current price and volume for stocks, indices and ETF’s. For example, GoogleFinance(“GOOG”) returns the latest Google stock price.

The GoogleLookup function attempts to answer your question using the web, with information about people, places and things, like the population of Japan, the mass of Jupiter, or the place of birth of Abraham Lincoln. It doesn’t know everything, but it knows quite a bit. For example, GoogleLookup(“T Rex”,”length”) returns “40 feet”.

And this was actually quite helpful as I have a spreadsheet tracking some of my stock options and I was able to use the GoogleFinance function to have it automatically insert the current stock price!
The only thing missing now is an extension to the function to allow it to read Currency exchange rate then it will be perfect (or almost)



No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: