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.
 

Public CREST market data - what am I doing wrong?

First post
Author
Previous Topic Next Topic
Garo Hertee
Eclipse Industrials
Quantum Forge
#1 - 2014-05-10 21:23:56 UTC
I've just started to look at the CREST market data for the first time and am slightly puzzled. As an example, I thought I'd look at the price of trit in Khanid region. I'm using the URL...

http://public-crest.eveonline.com/market/10000049/types/34/history/

and the last bit of the data returned looks like this...

{"volume_str": "204452641", "orderCount": 120, "lowPrice": 5.0, "highPrice": 5.01, "avgPrice": 5.0, "volume": 204452641, "orderCount_str": "120", "date": "2014-05-09T00:00:00"}

However, when I open up Eve and look at the market history table, the figures given for the same day are quite different...

Orders: 146
Quantity: 386,742,955
Low: 4.65
High: 4.82
Avg: 4.71

Am I missing something really obvious here or is there a problem with CREST?
Garo Hertee
Eclipse Industrials
Quantum Forge
#2 - 2014-05-10 21:40:32 UTC
As it turns out, I'm an idiot who can't read a table. I was looking at last year's entry in the client!

I'm crawling back under my rock now.
Garric Shadowbane
Stimulus
Rote Kapelle
#3 - 2014-05-11 00:25:33 UTC
Don't want to go off and start a seperate thread, Hope you don't mind that I hijack yours m8!


What's the best way to interpret market Json data?

Is it difficult to import Json data into excel?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-05-11 18:12:52 UTC
Garric Shadowbane wrote:
Don't want to go off and start a seperate thread, Hope you don't mind that I hijack yours m8!


What's the best way to interpret market Json data?

Is it difficult to import Json data into excel?



http://excelramblings.blogspot.co.uk/2011/10/excel-json-excel-in-one-line-of-code-on.html may be of interest.

It's not the easiest of data to load into excel, unfortunately.

( https://www.fuzzwork.co.uk/market/marketdisplay.php is another viewer.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Garric Shadowbane
Stimulus
Rote Kapelle
#5 - 2014-05-12 00:00:26 UTC
Steve Ronuken wrote:
Garric Shadowbane wrote:
Don't want to go off and start a seperate thread, Hope you don't mind that I hijack yours m8!


What's the best way to interpret market Json data?

Is it difficult to import Json data into excel?



http://excelramblings.blogspot.co.uk/2011/10/excel-json-excel-in-one-line-of-code-on.html may be of interest.

It's not the easiest of data to load into excel, unfortunately.

( https://www.fuzzwork.co.uk/market/marketdisplay.php is another viewer.)



Thanks steve, I will go ahead and play around with that.

For the time being... Is crest data only on regions or can you pull station specific as well?

It's very hard for me to find documentation on crest other than the sticky and evelopedia.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-05-12 01:19:04 UTC
Garric Shadowbane wrote:
Steve Ronuken wrote:
Garric Shadowbane wrote:
Don't want to go off and start a seperate thread, Hope you don't mind that I hijack yours m8!


What's the best way to interpret market Json data?

Is it difficult to import Json data into excel?



http://excelramblings.blogspot.co.uk/2011/10/excel-json-excel-in-one-line-of-code-on.html may be of interest.

It's not the easiest of data to load into excel, unfortunately.

( https://www.fuzzwork.co.uk/market/marketdisplay.php is another viewer.)



Thanks steve, I will go ahead and play around with that.

For the time being... Is crest data only on regions or can you pull station specific as well?

It's very hard for me to find documentation on crest other than the sticky and evelopedia.



Just like in Eve, it's region data only.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Florian Bao
Black Box Technologies
#7 - 2014-05-13 09:01:06 UTC
can I import that call into google docs somehow?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2014-05-13 11:22:35 UTC
http://blog.fastfedora.com/projects/import-json

may be of interest

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter