Science & Industry

Instead of //Sell/min,
replace it with:
/evec_api/marketstat/type/sell/min or
/evec_api/marketstat/type/buy/max
inside those quotations.

So plug in http://api.eve-central.com/api/marketstat?&usesystem=30002659&typeid= into B3, and your typeID in B4.

To explain why it wasn't working:

google lowercases xml and attributes for importxml. (one of the reasons I'm not a fan)

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may be of interest for an alternate way to load it.

That's one of the reasons I'm not a fan of importxml

The way you use that code is:

open a sheet.
tools -> script editor
close the popup window (this will happen once)
past the code in
save it (giving it a name)
then:
=loadprices(A1:A47,regionid)

where a1:a47 is a set of columns where you have typeids. and regionid is the id of the region you want to lead (if it's the forge, you can skip it)

Ideally, you'd put this into a new page on your sheet, as it returns quite a lot of data.

you'd then use vlookup to pull the price data you actually want into the cells you want it in.

Touch more complicated than copy and pasting the importxml, but feature wise it's better :) And doesn't have that 50 limit. you just pull all the prices you want into another sheet, and reference it as needed.

I've recently created my own spreadsheet after not quite liking the IPH tool..although with all the variables, I'm giving IPH a second chance. Anyway!

Here's what I ended up doing (with significant thanks to Steve Ronuken!):

1. Set up a sheet (mine is simply called "IDs") that simply has the TypeID in the first column and the name of the item in the second. For example:
ID Name
34 Tritanium
35 Pyerite
36 Mexallon
37 Isogen
38 "Noxcium
39 Zydrine
40 Megacyte

2. On a second sheet (mine is called "Prices Load") follow the steps Steve has posted about copy and pasting code into the script editor.

3. On "Prices Load", use the function =loadprices(A1:Ax, IDs)

Here the x denotes how long of a list you want the loadprices function to look at. If you have 10 items on your "IDs" sheet then put 11, if you have 26 then put 27 (+1 because of column headers).

4. Steve's code will then go off and get the data for you and return the data in the following column order:

TypeID Buy Volume Buy average Buy max Buy min Buy Std deviation Buy median Buy Percentile Sell Volume Sell Average Sell Max Sell Min Sell std Deviation Sell Median sell Percentile

The code doesn't return these column headers so you need to add these in.

5. On my "Prices Load" sheet, I've then added a column to the end which does a vlookup, back to my "IDs" sheet to get the item name again. Not that you necessarily need it, as I recommend using vlookups using numbers (TypeID) rather than a string of characters, but it's handy to remind yourself what item the prices relate to.

6. These are then 2 good starting blocks to build other sheets off of. For example, I have a began a sheet for T1 ships. I then use the a vlookup against the TypeID for the ship in "Prices Load" to tell me how much the ship is selling for, and then also other vlookups against the TypeID for the minerals (again in "Prices Load") letting me know how much it would cost to buy the minerals (both from sell orders and buy-orders).

I HIGHLY recommend you use Steve's code as it has a, and I'm learning this as I go along, cachebuster which bypasses the issue of eventually, by using =IMPORTXML, running into "#N/A"'s.

Hope this helps somewhat!

~Bear

Pahahahahaha :D Come on, you know i'm sexy!

*Quotes himself*

Figured it out! =) Thanks anyway o7

This. google screws up the xml attributes if you use caps of any kind in the string. Just keep everything lower-case and it should work.