Solved

Google Docs Updater (HELP)

Posted on 2011-09-06
1
719 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

773 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