One of the features that I use quite a bit in Excel as most of you know is the ability to do web queries. This can be done either manually or through macros. I was happy to find out that to some extent, it can now also be done in Google Docs spreadsheets. Obviously, since macros cannot be used in Google docs, the only way is to do queries directly.
So suppose you’d like to get access to the price of a security on Yahoo Finance, let’s imagine Google (GOOG), the price can be found at:
Then, you could simply use the following in your Google docs spreadsheet:
Most of that formula is generic and easy to understand. The tricky part is knowing which table to refer to. I’d say that in all honesty the best solution is often to just try. You can get a bit more info from Google’s help here:
Then, you can simply add a few different elements to make sure that the data refreshes at a regular interval, for example, if you’d like the data to refresh every hour you could:
Add this to cell B2:
And then adjust the formula to:
As you can see, the possibilities are significant