UfoTRADER
Relentless Technologies Quod Erat Demonstrandum
|
Posted - 2011.03.16 21:01:00 -
[1]
Edited by: UfoTRADER on 16/03/2011 21:05:16
Originally by: Cerrydwin Edited by: Cerrydwin on 25/02/2011 02:31:24 Interesting... I briefly had that running for the last month or two that eve metrics was up, but I'm having trouble with eve central. I can get to the xml response directly, but using an ImportXML query never seems to load in google spreadsheets.
for reference: =ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634«ionlimit=10000002", "/evec_api/marketstat/type/sell/avg") which should input the average Jita sell order price for atmospheric gases.
I also tried "type/sell/avg" and "/marketstat/type/sell/avg"as my xpath query, with no luck. Is anyone using this successfully?
update: the following query will produce the Jita average sell prices for all raw moon materials in alphabetical order, in one column and 20 rows.
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642«ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")
Instead of «ionlimit=10000002, it has a registered icon.
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642&R E G I O N limit=10000002", "/evec_api/marketstat/type/sell/avg")
This one is wrong, which I also ran into on multiple browsers and multiple operating systems
&typeid=16642«ionlimit=10000002",
hoursStatistics from the last X specified hours. typeidCan be specified more than once minQminimum quantity in an order to consider it for the statistics regionlimitRestrict statistics to a region. usesystemRestrict statistics to a system.
Example, =importXml("http://api.eve-central.com/api/marketstat?&hours=6&typeid=11549&usesystem=30000142&minQ=5000","//buy/max")
|