EVE Technology Lab

As far as I'm aware EVE-Central doesn't have a history API.

EVE Marketeer seems to - see http://www.evemarketeer.com/api/history_explanation. You'd need to change both parts of the importXML argument; the first should be the URL of the XML document from EVE Marketeer and the second should be the path within that XML document that contains the data you are interested in. I can't get the API to actually return anything at the moment, it seems to be timing out. EVE-MarketData seems to have a similar API call.

And, because you're the second person today to be asking about that sort of thing, I'll probably be adding a historical-data API to my own site (EVE Markets) in the near future...

EDIT: You updated your post while I was writing mine, more response to come ;)

OK, let's see...

Firstly let's work out the data you want to grab from the EVE MarketData API.

From what you say it sounds like you're only dealing with a single item at a time? In which case you'll need its type ID (for example, Tritanium is 34).

Plug that value into the URL in their API documentation and you get something like

http://api.eve-marketdata.com/api/item_history2.xml?char_name=demo&type_ids=34&days=15

(Note that I'm using 15 days here and not 90, because it's a lot faster )

So, that's the first thing you need to give the ImportXML(...) statement.

If you go to that URL in your web browser you can see the actual structure of the data, and you'll need to pass an XPath in to ImportXML that describes how to get to the data you want.

For example: "//row/@avgPrice" should get the average price for each row within the document returned by the API.

Unfortunately I've just tried plugging that in to Google Docs and it completely fails to work, so I've probably taken you as far as I can here

guys! look what I did from

http://www.evemarketeer.com/api/history/34/10000002/xml

=importXML("http://www.evemarketeer.com/api/history/"& $A3 &"/10000002/xml";"/result/row/price_low")

(attention, "& $A3 &" refers to a cell i can input a number (should be the typeID!)


now how do i filter for dates and how do it work that same magic with this:

http://api.eve-marketdata.com/api/item_history2.xml?char_name=demo&type_ids=34&days=15



.... with this one i can make it show the date..

=ImportXML("http://api.eve-marketdata.com/api/item_history2.xml?char_name=demo&type_ids=34&days=15&region_ids=10000002";"/emd")


but what do i need to fill in after the /emd part?