Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Google Docs Updater (HELP)

Posted on 2011-09-06
1
Medium Priority
?
727 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

How To Install Bash on Windows 10

Windows’ budding partnership with Canonical has certainly led to some great improvements. One of them being the ability to use Bash on your Windows machine without third party applications! This might be one of the greatest things a cloud engineer in a Windows environment can do!

Question has a verified solution.

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

Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

704 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