Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Santa Anna
Caldari Deep Core Mining Inc.
|
Posted - 2008.11.13 19:54:00 -
[1]
Is there a practical way to grab the market history data (example) in a format that could be imported into a spreadsheet? Copy/paste seems to be disabled on this, unfortunately, and I'd really like to play around with some of that data. |
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 21:23:00 -
[2]
Use the 'export to file' button and it'll export it in CSV format that your spreadsheet should understand. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Santa Anna
Caldari Deep Core Mining Inc.
|
Posted - 2008.11.13 21:27:00 -
[3]
Originally by: Dragonaire Use the 'export to file' button and it'll export it in CSV format that your spreadsheet should understand.
This exports the current open buy/sell orders in the region. The table in my initial post found under the "Price History" tab doesn't export when you export the current open buy/sell orders to file. |
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 21:37:00 -
[4]
CCP doesn't let you directly export the history but you can usually get one for most regions from EveCentral where people have exported their info from the market and they combine them there. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Santa Anna
Caldari Deep Core Mining Inc.
|
Posted - 2008.11.13 21:54:00 -
[5]
Originally by: Dragonaire CCP doesn't let you directly export the history but you can usually get one for most regions from EveCentral where people have exported their info from the market and they combine them there.
EveCentral, as far as I'm aware, aggregates exports of current market orders. It doesn't tell you how much of a given commodity sold for what when, which is what I'm really after.
That data is available in the client, and I'm thinking there's got to be a way to get it out efficiently. I just don't know how to get it. _____ CPU Love |
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 22:10:00 -
[6]
There are people looking through the .stuff files where some of the infomation is cached but it takes a lot of work to extract it and CCP changes some files almost every patch I understand so anything using them can break often. To really do what you want you'll have to collect the data yourself or get the daily stuff from EveCentral then put it in a database and do it yourself. CCP doesn't want to make is easy for people to automate market stuff anymore then make it easy for marco-miners to mine. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 22:15:00 -
[7]
Edited by: Dragonaire on 13/11/2008 22:15:23 Might have a look at this thread and others about the files I was talking about.
Using cache files -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Santa Anna
Caldari Deep Core Mining Inc.
|
Posted - 2008.11.13 22:18:00 -
[8]
Originally by: Dragonaire There are people looking through the .stuff files where some of the infomation is cached but it takes a lot of work to extract it and CCP changes some files almost every patch I understand so anything using them can break often. To really do what you want you'll have to collect the data yourself or get the daily stuff from EveCentral then put it in a database and do it yourself. CCP doesn't want to make is easy for people to automate market stuff anymore then make it easy for marco-miners to mine.
This wouldn't be any sort of market macro. I'm just trying to get the market history data into a more accessible format for proper study.
The EveCentral data isn't useful for my purpose.
Could the log server output be adapted to produce the data I want? I have no experience working with it. |
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 22:30:00 -
[9]
If you only want your history you can get it through the API but anything that shows everybodies can be used to make auto tools and they make that hard. Have you looked at the EveCentral APIs they worked for me to make something that with a little modding could have done what you wanted.
Not sure what you mean by log server but the logs the game keeps isn't as complete as what you get from the eve APIs so don't see doing it that way. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Santa Anna
Caldari Deep Core Mining Inc.
|
Posted - 2008.11.13 22:39:00 -
[10]
Originally by: Dragonaire If you only want your history you can get it through the API but anything that shows everybodies can be used to make auto tools and they make that hard. Have you looked at the EveCentral APIs they worked for me to make something that with a little modding could have done what you wanted.
Not sure what you mean by log server but the logs the game keeps isn't as complete as what you get from the eve APIs so don't see doing it that way.
By log server I mean whatever it was that Bacon used. I thought Bacon required you to be running CCP's logging software along side EVE but I could be mistaken. IIRC, the logger pulled all kinds of data from the client and bacon just parsed the logger output, signaling when the output met certain conditions. If I fire up the logger and open the price history windows for the commodities I want to study, would I be able to dig through the log file and find the data?
As for market autotools, there appear to be some that operate using the open order data you already can export to file and that data stream is much more amenable to a market macro than something that updates once a day. Given the data they currently allow for export I don't see how the data I want would be nearly as ripe for exploit. |
|
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 22:58:00 -
[11]
That the cache file they are talking about in other thread and I talked about here used by Bacon. They changed cache file so Bacon didn't work anymore and that always the risk with using them that they change them without notice or to prevent people using them for stuff they don't want them used for. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
El'Evator
|
Posted - 2009.01.18 13:38:00 -
[12]
Sorry for threadomancy, but is there any progress in getting 'price history' table from the client? |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |