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.
 

Need help for get price in google spreadsheet form eve-central

First post
Author
Previous Topic Next Topic
binary star long
Brutor Tribe
Minmatar Republic
#1 - 2014-12-27 06:24:34 UTC
I have AFK for half a year,now I'm back, but the google spreadsheet I get price form eve-central have trouble
the script I used before worked find,but now it doesn't workCry

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=34&usesystem=30000142&minQ=1000000","/evec_api/marketstat/type/sell/min")

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",$A3:$A73)&"&usesystem="&A2,"/evec_api/marketstat/type/buy/percentile")

it just show Attention#VALUE!
Do anyone know what is the trouble of it , and how to modify it,please help me ,thank you!Big smile
Arkumord Churhee
Nice Try.
#2 - 2014-12-27 07:31:08 UTC
You need to make a _new_ spreadsheet, somehow ImportXML ist now very flaky on the old version of Spreadsheets.
There is also help provided here: http://groups.google.com/group/eve-central
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2014-12-27 20:14:55 UTC
I prefer https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs, but that's mostly because importxml annoys me. (getting back multiple values is, umm, iffy)

It's designed for region level, but changing that is just a matter of adjusting the url.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter