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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Market Export

Author
Annunaki soldier
Perkone
Caldari State
#1 - 2013-02-15 09:45:17 UTC
Is there any way instead of getting 1 by 1 to export the market data (prices - buy orders) in order to use em at a spreadsheet ?

For example i want a to make a full comparison of every item of the market if possible for 2 regions. And if that regions are null to high sec (so you cant extract from eve central for example) ? Whats the possible way if any to succeed at this instead using 2 alts and checking one by one

Thanks for feedback if any

Ride hard, live with passionĀ 

Stigman Zuwadza
Deep Core Mining Inc.
Caldari State
#2 - 2013-02-15 10:10:25 UTC
If I was in your situation...

As no price data is being seeded to Eve-Central I would have an alt out in null and begin the process of clicking each item you're interested in. Then use something like Eve-Mon which will scrape your cache and upload that info to an endpoint such as Eve-Central. I would then use the Eve-Central API to retrieve the data.

You might be thinking ..err but if I'm going to do all that I might as well do the export thinggy if I've got an alt out there already, in the long run doing it this way will save you a tremendous amount of time even if to begin with you need to put in those first clicks to get Eve-Central seeded with prices. Hopefully the null price updating part will deminish slighly as you seed Eve-Central with the prices.

Theres no quick fix to the lack of pricing info though if thats what you're hoping for.

Fly safe. o7

It's broken and it's been broken for a long time and it'll be broken for some time to come.

Annunaki soldier
Perkone
Caldari State
#3 - 2013-02-15 11:29:31 UTC
not really i am actually in love with the luck of pricing at eve central and i would love to keep it that way for obvious reasons. I am concerned in a way to export the data for my personal use and only. Its pretty easy to get jita prices but i need the way to import nullsec prices (npc space for example) then do the comparison to the spreadsheet. I will check what evemon can do, Didnt know it can take values from market

Ride hard, live with passionĀ 

Thur Barbek
Republic University
Minmatar Republic
#4 - 2013-02-15 13:01:39 UTC  |  Edited by: Thur Barbek
When you look up a item in the market, the data goes into your cache file. You can use this cache file to retrieve the data and automatically enter it into a spreadsheet. (This is how eve-central gets data, from volunteers who enable cache-uploading.)

To automatically cycle through the market, you can write a script for the IGB(in game browser) that will cycle through a list of items. You will have to compile this list youself, obtaining the item ID's for each item from the database or various other means. You cannot simply say search item ID's 1-65000, due to the fact that not all item ID's are associated with a real item and also due to the fact that CCP only allows 1 browser-client operation per second. So pick your 300-600 items and let it run for 5-10 min.

You will need to learn a bit how to interface the IGB and eve market to automate cycling through the item list, but it shouldn't be too hard. Same with reading and organizing the cache file.


An easy way to avoid a lot of work would be to use eve-central's uploader (or eve-mon as it pools to the same database) and use a script to import prices from eve-central. This would save you from learning how to read the cache. Downside is that everyone will be able to see the prices as well, and you will have to wait until eve-central does an upload cycle for new data.

http://pastebin.com/YfAe1vmH is most of a script to use the IGB to search items. NOTE: i did not write this, parts may be missing, i do not claim to own this. It is just an example of how stuff works.

CCPEVE.showMarketDetails(ids[current_id]); is the line you should be looking at
Annunaki soldier
Perkone
Caldari State
#5 - 2013-02-15 13:25:20 UTC
thanks a lot my friend. I dont have any problem sit down and learn how to do things. Thats also the part that keeps you . You certenly pointed the way though

Ride hard, live with passionĀ