Avatar of Ross Turner
Ross TurnerFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Google Docs Updater (HELP)

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
Web DevelopmentProductivity AppsMicrosoft Excel

Avatar of undefined
Last Comment
Ross Turner
ASKER CERTIFIED SOLUTION
Avatar of Ross Turner
Ross Turner
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo