These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

eve-central mass export xml?
Author
Previous Topic Next Topic
Arch Raptor
Imperium Cartel.
Out of the Blue.
#1 - 2012-05-06 10:42:30 UTC
Looking for a way to quary a mass market xml based on local markets - namely top 4: amarr, jita, rens, dodixie

Trying to build this as an xml that I can import into excel 2007.

Is there a way to do this with just 1 quary? I can do it manually by typing out 17k lines of quary code per market but it will create 100's if not more quarys to the server which will tie up bandwidth.

trying to build a sheet that examines changes in market conditions by hour and shows profit and % change index. Namely by compairing data from each upload cycle with the last (update hour 1 vs hour 2 and show % change per item in sell vs buy pricing)

I already have formula to make this happen but I am having issues with the update process.

If anyone has the coding for the quary like this already, please reply so I can input.

Currently using code:

http://api.eve-central.com/api/marketstat?usesystem=30002187&typeid=18&typeid=19&typeid=20&typeid=21&typeid=22&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40

Khorkrak
KarmaFleet
Goonswarm Federation
#2 - 2012-05-07 20:21:19 UTC
A quary is a place where you carve out rocks - an open air mine. A query is a question. You generally query databases, you don't quary them. Do you need up to the minute data or can it be a day behind? You can access daily dumps here: http://eve-central.com/dumps

Developer of http://www.decloaked.com and http://sourceforge.net/projects/pykb/
Arch Raptor
Imperium Cartel.
Out of the Blue.
#3 - 2012-05-09 03:12:04 UTC
spell check is not always perfect...

was looking to get an hourly update as well as a daily update and have the program compare pricing and give me a daily percentage of if the market it trending up or down on certain items.