EVE Search - Public CREST market data - what am I doing wrong?

All Channels

EVE Technology Lab

Public CREST market data - what am I doing wrong?

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
Garo Hertee Eclipse Industrials Quantum Forge 14	Posted - 2014.05.10 21:23:00 - [1] - Quote 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 14	Posted - 2014.05.10 21:40:00 - [2] - Quote 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 SniggWaffe WAFFLES. 12	Posted - 2014.05.11 00:25:00 - [3] - Quote 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 3197	Posted - 2014.05.11 18:12:00 - [4] - Quote 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 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter
Garric Shadowbane SniggWaffe WAFFLES. 12	Posted - 2014.05.12 00:00:00 - [5] - Quote 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 3198	Posted - 2014.05.12 01:19:00 - [6] - Quote 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 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter
Florian Bao Black Box Technologies 36	Posted - 2014.05.13 09:01:00 - [7] - Quote can I import that call into google docs somehow?
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 3236	Posted - 2014.05.13 11:22:00 - [8] - Quote http://blog.fastfedora.com/projects/import-json may be of interest Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter

Pages: [1] :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.