EVE Technology Lab

OK, I'm trying to download some market data into my Google docs program. However, I can't get it to do exactly what I want and I'm tearing my hair out over it! Perhaps some of you good people can help me.

I've been using the following command:

=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",$B3:$B73), "/eve/price")

This allows me to download the average prices. Unfortunately, I find the average market prices to be rather unhelpful. What I would like, is the sell min and/or buy max prices. What do I need to change here to get this info?

Thanks for any help you can offer.

As Louis linked (for eve central that is)


You should add the parameter &buysell= "value"

I dont use googledocs, cause i find it futile, but something along these lines should help you out

I cannot verify the result of these, but the format should be around this.

this is used to traverse the XML

Open result
-Open rowset
--Open row
---get attribute "price" of row

/result/rowset/row['price']

(ps. dont know if Google doctypes work this way, but thats the SimpleXML method of retrieving data from XML node.)


Sell orders

=ImportXML("http://api.eve-marketdata.com/api/item_prices2.xml?char_name=Unknown&type_ids=&JOIN(",",$B3:$B73)
& "&region_ids=10000002&buysell=s", "/result/rowset/row['price']"

Buy orders

=ImportXML("http://api.eve-marketdata.com/api/item_prices2.xml?char_name=Unknown&type_ids=&JOIN(",",$B3:$B73)
& "&region_ids=10000002&buysell=b", "/result/rowset/row['price']"