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.
 

Market Data

First post
Author
Previous Topic Next Topic
Mortaliton
Industrialist and Manufacturers Directorate
#1 - 2011-10-27 13:53:06 UTC
Hello

I remember a while back i saw a link on the main website page when the eve team released some eve market data. At the time i couldn't look into it but cannot seem to find the link. Maybe you know what it contain but I'm looking for a way to get selling prices of items in regions and exporting it to a spreadsheet or export it just to a word document. I do not know if there is a program for it or if my google searches seem to just have been mis-worded enough to return nothing of real value. but if anyone could lead me to a website, program or anything that does what mentioned above. (exports the selling price average of Items in certain regions or something similar your help is much appreciated.

Thanks in advance

Mort.
Callduron
Dreddit
Test Alliance Please Ignore
#2 - 2011-10-27 13:56:32 UTC
Try http://eve-central.com/

I write http://stabbedup.blogspot.co.uk/

I post on reddit as /u/callduron.
Mortaliton
Industrialist and Manufacturers Directorate
#3 - 2011-10-27 14:02:14 UTC
I found a way to find prices. When i say export into a file . I forgot to mention on want every item in eve for as region. not 1 at a time. did i miss it? I want to import it into a spreadsheet with default code so every time i paste these in it update everything price wise.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2011-10-27 14:04:11 UTC
Eve-central, eve marketeer and eve marketdata all have ways of getting market data using an api. If you're looking for a way to handle the data yourself, from your own cache, I'd suggest:

install python 2.7, 32 bit. (I tried the 64 bit one. it didn't work with the next step)
install reverence, the eve cache scraper python library, https://github.com/ntt/reverence

use a script like http://pastie.org/821014 to dump the data.

it does mean you have to access each item in turn, while in the region, but I believe there's an option on eve-marketeer for doing that. (or use the order management from eve mentat)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mortaliton
Industrialist and Manufacturers Directorate
#5 - 2011-10-27 14:06:30 UTC
Doing that now. Haven't used python in a while. Report in a bit.
Mortaliton
Industrialist and Manufacturers Directorate
#6 - 2011-10-27 14:14:06 UTC  |  Edited by: Mortaliton
>>> eve = blue.EVE(C\Program Files (x86)\CCP\eve)
SyntaxError: unexpected character after line continuation character

Going through the read me it is exactly as it states. I do not understand whats wrong.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2011-10-27 14:26:39 UTC
Reverence lets you use python to grab the data which you have in your eve cache. What happens to it is entirely up to you.

The pastie link, contains a script that will go through your cache, and dump out a csv file, per item, per region, containing the historical sales data, for that item, in that region.

Anything more complex, you'll have to fiddle with it yourself (I'm scripting it up to give me a dump to a website of my own, for historical purposes). There are other examples available. One thing to note, is that they changed from issued, to issueDate. as for the link being down, they're working fine for me?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mortaliton
Industrialist and Manufacturers Directorate
#8 - 2011-10-27 14:27:59 UTC  |  Edited by: Mortaliton
It says blue is undefined when i put the line in
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2011-10-27 14:47:39 UTC  |  Edited by: Steve Ronuken
use /, rather than \ in the path. should make the difference.

so:

C:/Program Files (x86)/CCP/eve

you'll need to do the same in your output director


needs to be a quoted string too.

(I'd stick up what I use, but I'm at work, without eve Sad)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mortaliton
Industrialist and Manufacturers Directorate
#10 - 2011-10-27 15:01:03 UTC  |  Edited by: Mortaliton
im running into the error blue is not define. Maybe im importing blue wrong but im not sure how to import it. i try and it says no module named blue :/


go it

EVE Marketeer is down for (very important) maintenance. If you feel bored, you can play a game of snake.

Just so you know, there IS progress, you are just not able to see it. The backend is being carefully rewritten. All new code is still breaking all the time however. I hope to fix this this weekend .
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2011-10-27 15:06:42 UTC
You installed the reverence module from https://github.com/ntt/reverence ?

I used the MSI installer without any trouble. The pastie script worked for me with no real adjustment (just filling in the real directories)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mortaliton
Industrialist and Manufacturers Directorate
#12 - 2011-10-27 15:14:32 UTC  |  Edited by: Mortaliton
I just got done with work. Overnight-er and haven't slept so im probably making easy mistakes. thanks for your patience

im just working on exporting everything into one mass market log now. i found out how to do it one at a time but that website is still down strangluy enough. i pasted teh error above. I cant figure out the order thing with the other program.

Is there a way when i export it as data if the history will be limited to the cheapest sell order an dthe highest buy order so i only have one peice of data? as in the current date.

I want to kind of paste in all info once a day and have the rest of tghe formulas do the rest. butonce i gte it all exported. and hopefully when that site gets up i can export everythign at once.
CCP Phantom
C C P
C C P Alliance
#13 - 2011-10-27 16:07:08 UTC
Moved from Market Discussions as it is getting rather technical by now.

CCP Phantom - Senior Community Developer
Callean Drevus
Perkone
Caldari State
#14 - 2011-10-27 16:20:07 UTC
How is it strange EVE Marketeer is still down? It says I aim to have things fixed by this weekend doesn't it? :P

Other than that, thank you for considering to use it. I hope it will bring you much and accurate data in the future.

Developer/Creator of EVE Marketeer
Callean Drevus
Perkone
Caldari State
#15 - 2011-10-27 16:20:18 UTC  |  Edited by: Callean Drevus
Double

Developer/Creator of EVE Marketeer
Zeta Zhul
Preemptive Paranoia
#16 - 2011-10-28 02:16:02 UTC
I put up a post on the old forum that details how to do that. Link
Mortaliton
Industrialist and Manufacturers Directorate
#17 - 2011-10-31 22:04:36 UTC  |  Edited by: Mortaliton
My Overnight Schedule got in the way a bit. But I finished my Spreadsheet Im working on and just getting ready for the data import. Ill check out the link last mentioned and update in a bit. I basically have a massive spreadsheet with every eve bpo (via evemon) it has all bpos that are formulated to my mineral skills that all calculate upon the main minerals and objects from PI. Also has a few other nifty tricks but i have the items i want to the quick bar in my eve market and i just need to export those few items so i can copy and repeatedly paste over old data always giving me curate production costs. Now i can get all files in to separate spreadsheets but they list about 100 recent selling orders. Can i limit this to 1? and how can i get these all into one file?

Now i will go read your linkage now so forgive me if these were answered.

Mort.

P.S.

Thanks CCP Phantom for correcting my post postage place. Hopefully get more eyes to this.


EDIT

useing that code i get error 508 in open office. Im kinda baffled as this may be out of my league but google here i come!

Okay, I relized exel and open off talk is differnet. That aside I now get a #NAME? error.
i cant seem to resolve this one as easily

Excel = ,
calc = change all "," -> ";"
Mortaliton
Industrialist and Manufacturers Directorate
#18 - 2011-11-01 13:01:45 UTC  |  Edited by: Mortaliton
bump

http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1490114

I may have solved this problem with the last post on this link. Update in a few hours for i have a lot of typing ahead of me.

http://eve-files.com/chribba/typeid.txt

10000001 Derelik
10000002 The Forge
10000003 Vale of the Silent
10000004 UUA-F4
10000005 Detorid
10000006 Wicked Creek
10000007 Cache
10000008 Scalding Pass
10000009 Insmother
10000010 Tribute
10000011 Great Wildlands
10000012 Curse
10000013 Malpais
10000014 Catch
10000015 Venal
10000016 Lonetrek
10000017 J7HZ-F
10000018 The Spire
10000019 A821-A
10000020 Tash-Murkon
10000021 Outer Passage
10000022 Stain
10000023 Pure Blind
10000025 Immensea
10000027 Etherium Reach
10000028 Molden Heath
10000029 Geminate
10000030 Heimatar
10000031 Impass
10000032 Sinq Laison
10000033 The Citadel
10000034 The Kalevala Expanse
10000035 Deklein
10000036 Devoid
10000037 Everyshore
10000038 The Bleak Lands
10000039 Esoteria
10000040 Oasa
10000041 Syndicate
10000042 Metropolis
10000043 Domain
10000044 Solitude
10000045 Tenal
10000046 Fade
10000047 Providence
10000048 Placid
10000049 Khanid
10000050 Querious
10000051 Cloud Ring
10000052 Kador
10000053 Cobalt Edge
10000054 Aridia
10000055 Branch
10000056 Feythabolis
10000057 Outer Ring
10000058 Fountain
10000059 Paragon Soul
10000060 Delve
10000061 Tenerifis
10000062 Omist
10000063 Period Basis
10000064 Essence
10000065 Kor-Azor
10000066 Perrigen Falls
10000067 Genesis
10000068 Verge Vendor
10000069 Black Rise

This will work. Just need to edit some formulas ,
Thank you everybody for your help. Great to have you all in our community.

Mort.

the only problem i face now. I switched to excel but when i open my file in excel all my formulas disapear wit h static numbers. hmm

http://www.ehow.com/how_5112167_convert-openoffice-excel.html

only google docs option worked for me.

System ID Linkage
http://eve-search.com/thread/1097069