Science & Industry

Hey I don't know how to do in excel, but this is how you do it in google documents.

You need three columns.
1) Item ID
2) Sell Prices
3) CONCAT column

The Item ID column is a column full of item ids. This is found by searching the item in eve-central and in theURL will be the typeid.

The Sell Prices column is a column that contains the sell value currently from eve-central. The FIRST item row should look like this(the rest of the column will auto-fill):
=importXML(CONCAT($A$1,DATA!$M114),"//type/sell/min")
$A$1 Is: http://eve-central.com/api/marketstat?usesystem=30000142
DATA!$M114 is the last row in the column CONCAT column.

The CONCAT column is to make all the items be called at the same time.
The first item in the column is:
=CONCATENATE("&typeid=",B3)
B3 is the item id of the first item.
The rest of the items in the column is:
=CONCATENATE(M3,"&typeid=",B4,)
M3 is the row directly above the current one.
B4 is the current row's item id.

Hope this helps!

Using Microsoft Excel 2010

Create a new worksheet (bottom leftish area) and name it data. This will be your worksheet that contains all your values, and you'll reference in other sheets.

Now click on a random cell (C, 4) for example.

In the ribbon at the top there should be a section called Data (if its not there you should add it).

click Data and you should see the option "From Web" click this.

You should now see a sort of browser window. Add a URL from eve-central.com such as:

http://api.eve-central.com/api/marketstat?usesystem=30000142&hours=48&typeid=2268&typeid=2305&typeid=2267&typeid=2288&typeid=2287&typeid=2307&typeid=2272&typeid=2309&typeid=2073&typeid=2310&typeid=2270&typeid=2306&typeid=2286&typeid=2311&typeid=2308

This URL grabs all the PI P0 materials in Jita, in the last 48 hours.

click Go to confirm it works. If when you try to copy/paste a URL into the address box and it gives you an error chances are it is too long (max 255 characters).

Click Import, click ok to the message about the schema, and then a few mrore clicks.

You should now have a table generated based on the XML data generated.

You will also need to click Refresh to update the data. You can set it to automatically refresh, but best to keep it manual as it's rude to have it requesting new data when you are not using it.

All that means is you just need to setup several XML requests which is why I always use a data sheet. It allows me to store all the URLs/XML data in 1 sheet, which I can then reference unlimited number of times and deal with whatever formatting I prefer. It's quite common to have to have more then 1 XML request for a spreadsheet, for example to request all the PI materials from P0 to P4 it requires 6 XML requests, and this is just for Jita prices. For additional trade hubs you need just as many (so 6 more for Domain, 6 more for xyz, etc).