Doing Web Queries In Google Doc Spreadsheets

Google Cloud Spreadsheets

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:

http://finance.yahoo.com/q?s=GOOG

Then, you could simply use the following in your Google docs spreadsheet:

=index(importhtml(“http://finance.yahoo.com/q?s=CLF.TO”,”table”,2),1,2)

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:

http://support.google.com/drive/bin/answer.py?hl=en&answer=155182

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:

=Minute(Now())

And then adjust the formula to:

=index(importhtml(http://finance.yahoo.com/q?s=GOOG&B2,”table”,2),1,2)

As you can see, the possibilities are significant

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

3 Feedbacks on "Doing Web Queries In Google Doc Spreadsheets"

Payday loans

Every weekend i used to pay a visit this site, for the reason that i
want enjoyment, as this this web site conations actually fastidious
funny information too.



ask

Undeniably imagine that which you stated. Your favourite
justification appeared to be on the web the easiest factor to be mindful of.
I say to you, I certainly get annoyed at the same time
as other folks think about concerns that they just do not realize about.
You managed to hit the nail upon the top as neatly as outlined out the entire thing with no need side-effects , other people could take a signal.

Will likely be back to get more. Thanks



Ron

can you please help me get a table to google docs, but the table has a search query in it.

https://nabers.gov.au/public/webpages/ContentStandard.aspx?module=30&template=3&id=310&side=Ratingsfrom20July.htm