EVE Technology Lab

Hey guys, databse noob here.

I've got a database with all the items of the game and their typeId. And so I ventured into how to update the prices by grabbing them from EVE-Central.

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=1224&usesystem=30000142","/evec_api/marketstat/type/sell/median")

This gives me the median sell price of pyroxeres in Jita system. Works fine....most of the time. To make things easier for myself, I've made this query with 99 items at a time (apparently google spreadsheet can't handle more than 100 at a time), by using the & command. Something like this :

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=1224&1225&1226&.......&usesystem=30000142","/evec_api/marketstat/type/sell/median").

Then I get 99 rows with each individual price, provided such an item is for sale in Jita. I am not sending queries on items that do not exist in the game! When I have the prices, I copy them into my MySql database.

Sometimes I get a zero result back even though market orders can be found on EVE-central site. One day I get, say, a result like Jaspet, 700. And then the next time I update google docs ( I do this once or twice a week) I get a zero result. As if the item either costs 0 or that no sell orders are present in Jita. But when I look up the item on EVE-central, it's there.

Does anyone know what I might be doing wrong?

And if not, does anyone have a suggestion how else I might obtain (relatively) up-to-date prices and export them out of game?

I am aware of the database dump that eve-central posts, but I realy don't know where to begin to extract the data to something useful. Perhaps, if you venture into a response, you might direct me to a useful post that explains it in detail?

Hoping for a positive response.

Damn, that was quick. Thanks.

The hours parameter? I didn't even realize there was one. So allready I'm the wiser :).

Do you know how to change/add that parameter into my XML query?


Edit: Redundant question had I looked at your website properly before asking. Sorry, disregard.

Thankyou for your help.