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 Data: Volume x Price?

First post
Author
Previous Topic Next Topic
Suur Ala
Ministry of War
Amarr Empire
#1 - 2015-05-16 06:47:28 UTC  |  Edited by: Suur Ala
Is there anywhere one can find items ranked by avg. Volume times avg. Price? (In other words, the amount of isk that flows through each item, in, say, Jita, per day on average) In-game data and many websites have this sort of info (for example, http://eve-marketdata.com has prices stats and Jita qty/day), but I can't find anywhere that ranks items by the quite useful Volume time Price number or offers that kind of data for download.

If that's not available, then being able to download data in an easily analyzable form would be great too. I've looked into CREST though and haven't been able to find any real tutorials or guides on how to get started from scratch. I spent many hours trying to get phealng working https://github.com/3rdpartyeve/phealng, but couldn't even get the prerequisites installed (Composer I think).

Is this kind of data readily available anywhere without devoting 100's of hours to learning all the things I need to know to get the data from CREST?

And, to preempt flames: I have already spent 2-3 hours trying to do it manually in-game/off of eve-marketdata.com, copying and pasting data manually into a spreadsheet. Given all the data and 3rd party websites out there, I can't help but think that there's gotta be a better way...
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-05-17 02:16:12 UTC
https://www.fuzzwork.co.uk/market/marketdisplay.php

Phealng is actually useless in this case. It's purely for working with the older XML api.

To get the market history api from crest, you have to request urls like the one below.
https://public-crest.eveonline.com/market/10000002/types/29668/history/

This is for Plex, in the Forge. The forge is region id 10000002, plex is typeid 29668

While you can do this with a spreadsheet, it's not really particularly suited for it. Possibly for later manipulation, but not so much for the initial pull. Excel handles json exceptionally badly, and googledocs has limits with how many url requests you can do per day.

Do you have a preferred language and/or platform to work on? (linux? php? python? windows?)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Suur Ala
Ministry of War
Amarr Empire
#3 - 2015-05-17 23:11:28 UTC  |  Edited by: Suur Ala
Hey Steve,

Thanks for that PLEX URL example, that helps a lot! I'm on Windows. I'm somewhat familiar with Python and C++, and I could learn the basics of PHP quickly if it'd help. Anything in particular you recommend for pulling and/or analyzing or just should I just dive right into coding my own pull/sort/analysis program(s)? Thanks again, that PLEX example benefited me more than many hours of Googling!
Suur Ala
Ministry of War
Amarr Empire
#4 - 2015-05-17 23:14:07 UTC
Also, if I get a good solution I will post the code and a guide in the appropriate place, and will make sure to give you credit!
ICBC
Short Term Capital Management
#5 - 2015-05-18 16:56:04 UTC
Something quick and dirty I whipped up. It's not optimal but it works:

http://pastebin.com/XTWrGdjG
Suur Ala
Ministry of War
Amarr Empire
#6 - 2015-05-21 13:15:07 UTC  |  Edited by: Suur Ala
ICBC wrote:
Something quick and dirty I whipped up. It's not optimal but it works:

http://pastebin.com/XTWrGdjG


Thanks! I'm getting

Quote:
urlopen error [SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:581)


for your code or any similar code I try to run. I've tried both Python 2.7.9 and 3.4. I've tried implementing all the solutions I've found in search results, but with no success. How are you managing to get (simplified for clarity's sake)

Quote:

import urllib2
url = 'https://public-crest.eveonline.com/market/10000002/types/29668/history/'
resp = urllib2.urlopen(url, timeout=10)


to run? Thanks for your help!

EDIT: Solution found: just switch to Python 2.7.8 as per Nuke Cherenkov's post here. I'll leave this post intact for the benefit of any future searchers.