Market Discussions

This is how you do it in google spreadsheet:

Google Docs Spreadsheet example

And while the 50 importxml() limitation does limit you ... you're not actually supposed to do it that way. The function to use is Continue().

Basically for every column you do a query and then subsequent parsing of that requested xml data is done through the Continue() function.

=ImportXML("http://api.eve-marketdata.com/api/importxml_prices2.xml?buysell=s&char_name=Zhombi&station_ids=60003760&type_ids="&JOIN(",",$A4:$A101), "/emd/price")

Basically the URL used concatenates the request for a specific set of typeids that occupy column A. The station_ids is for "Oursulaert III - Federation Navy Testing Facilities" which id = 60011740 while the primary reference being used is Jita-4-4 which id = 60003760. If you want different id for different stations then ask here or download the static data dump and find it.

buysell denotes whether or not this is for buy orders or sell orders.

char_name should _NOT_ be "Zhombi" which is one of my character names but your own. Seriously don't goof on this because if you're causing a problem on the server because of a malformed request then you want to know about it to fix it.

"/emd/price" is the xpath to the queried data.

So the result of this is an updatable spreadsheet that queries eve-marketdata.com for recent buy/sell market order prices to determine the price delta between Jita-4-4 and "Oursulaert III - Federation Navy Testing Facilities". Replace as needed.

BTW the the different colors I use denote whether or not something is a good deal. I use a combination of an IF() function and Conditional Formatting (right mouse click to access).

edit: this isn't meant to be exhaustive or to provide a complete working example. It's just to show the technique. You would have to add some more functions, filtering and checking to make it worthwhile. Not a lot more, but it isn't turnkey.

As always YMMV. .... And buy my overpriced crap! Now!!! :)

Awesome information posted, perhaps this should be pinned. Seriously this question pops up so often.

Or...
1. turn on Developer tab > options > show ...
2. On developer tab insert > active x Button , check design mode ....
Double click button insert the text below.
Arkusz2 change to your sheet name.
Forth column has the type id's of things you want to check
The seventh will have the prices. This script will check 9 prices at once.
Changing the Set xmlNodeList = xmlDoc.SelectNodes("//evec_api/marketstat/type/sell/min") you can set what price you want to pull out ..
In MIcrosoft Visual Basic > tools > references check the "Microsoft XML 5.0"

For j = 2 To 500 < change this number to as many rows you have