?
Solved

Google Docs Updater (HELP)

Posted on 2011-09-06
1
Medium Priority
?
752 Views
Last Modified: 2012-05-12
Hi EE,
I’m after some help with Google Docs Spreadsheets; I know it doesn’t have a lot of the functionality of the likes of Excel. However what I’m after doing is taking some information from a website and updating the cells in a Google doc spreadsheet on a 60sec refresh. I’ve done some searching and found some info but  for whatever reason I can’t get it to work.
The formula that I’m using is:
=index(ImportHtml("http://apmex.com/","table",7),3,2)
Which works great for pulling the data but when I apply the same theory as below I can’t get it to work?
Details i found on the web:
I used a simple workaround of appending a parameter which updates every minute.

Function call is: =ImportHtml("http://www.fifa.com/worldcup/standings/index.html?"&H81;"table";4)

Formula in H81 is: =Minute(Now())

Any help with this would be greatly appreciated.

Thank you

Ross
0
Comment
Question by:Ross Turner
1 Comment
 
LVL 7

Accepted Solution

by:
Ross Turner earned 0 total points
ID: 36488256
No Fear i found this formula does the job..... and updates it on the min lovely

=index(ImportHtml("http://apmex.com/"&"?"&"workaround="&INT( GoogleClock() * 1E10 );"table";7),1,1)
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question