Google Docs and Spreadsheets just got better and smarter with the latest updates. The new features allow you to add your active list of docs and spreadsheets to a personalized Google page. You can revert to saved versions of spreadsheet and also publish them as publicly available web pages. Two special functions – Google Finance and Google Lookup have added value to existing spreadsheet features. The former allows you to get stock market quotes along with other data while the latter provides dynamic content from Google.
The Google Docs & Spreadsheets blog explains, "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.
Keep in mind that, while the GoogleLookup function knows quite a bit, it doesn't know everything. Not all of the formulas that you might try will work, but we encourage you to experiment with the function and see what does work."
"GoogleFinance focuses just on financial data from Google Finance. Using a similar syntax, you can look up the price of Google stock [=GoogleFinance("GOOG")] or the 52-week high of Apple [=GoogleFinance("AAPL", "HIGH52")]. And since stock prices tend to change more often than, say, the capital of California does, we update them in your spreadsheet automatically. So if you leave your portfolio spreadsheet open, you should see numbers get updated as you would on Google Finance itself."
The updates seem quite interesting and helpful. More information about the new features available here.