Using two special formulas, users can create cells that will update constantly with data or information gleaned from Web searches or Google's finance service. This works for things such as stock symbols, sports statistics, or any other piece of information you want to source and keep up to date automatically
For example, you can insert the current price of Google stock in a spreadsheet by entering =GoogleFinance("GOOG"; "price"), or check out the number of internet users in Paraguay with =GoogleLookup("Paraguay"; "internet users"). Very cool.5 things you probably didn't know you could do in Google Docs & Spreadsheets [Webware]
</img>
More...