These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Google docs help (importxml)
Author
Previous Topic Next Topic
Shady Omally
Shady Omally Corp
#1 - 2015-04-08 16:18:01 UTC
Im trying to import some market data from xml's in my spreadsheet and im able ( from time to time ) to import market data.

But my problem is how to refresh the data in the cells. Ive found a post stating to use &refresh="&GoogleClock()

I've been trying to get it to work but cant, can anyone shoot me a helping hand or even point me to another way to refreshen it?

thanks in advance

here's a cell code example :
=importxml("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=11549&typeid=11537&typeid=11539&typeid=11543&typeid=11549&typeid=11554&typeid=11557&typeid=11399&typeid=3828&typeid=628&typeid=11478","/evec_api/marketstat/type/sell/min")
Bear Templar
TEMPLAR.
The Initiative.
#2 - 2015-04-08 21:16:31 UTC
I highly recommend you use Steve Ronuken's code available at his Github:

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs

If a fish weighs 1 Kilogram plus half its own weight, how much does it weigh? (It's not 1.5kg btw)
Shady Omally
Shady Omally Corp
#3 - 2015-04-09 07:09:50 UTC
thanks Lol