These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

How to import eve-online market data to exel.
Author
Previous Topic Next Topic
Azrael Dinn
Imperial Mechanics
#1 - 2011-12-16 12:12:32 UTC
So

I have seent that I can be done automaticly but how it is done thats the question.

Could someone help me out?
For example how to import like isogens avarage price into a exel sheet?

I know how to grind the sheets and stuff but I have no idea how to do this kinda stuff so all hints are welcome. I wanna learn something new.

After centuries of debating and justifying... Break Cloaks tm
Castor II
University of Caille
Gallente Federation
#2 - 2011-12-16 13:06:02 UTC
=importXml("http://api.eve-central.com/api/marketstat?&typeid=37&regionlimit=10000002","//sell/avg")

typeid -> ID of the item you want to fetch, for Isogen it's '37'

regionlimit -> The region you want to fetch the price from, '10000002' is the Forge

//sell/avg -> Fetches the average selling price
Check out what other stats you can fetch here:
http://api.eve-central.com/api/marketstat?&typeid=37&regionlimit=10000002




More detailed info here:
http://eve-central.com/home/develop.html
Azrael Dinn
Imperial Mechanics
#3 - 2011-12-16 16:41:27 UTC
Ok... question 2

Where can I get the list where all the items are Question

After centuries of debating and justifying... Break Cloaks tm
Caractacus Dio
Inception Innovations
#4 - 2011-12-16 16:58:44 UTC
If you search for the item on eve-central, ID is in the URL
Azrael Dinn
Imperial Mechanics
#5 - 2011-12-16 17:03:10 UTC
Splendid....


Then... what if I don't want to use eve-central to querry the data?

Not that I don't like what they give but from a learning point of view. Is it possible to get the data straight from ccp?

After centuries of debating and justifying... Break Cloaks tm
Scrapyard Bob
EVE University
Ivy League
#6 - 2011-12-16 17:41:41 UTC
Azrael Dinn wrote:

Not that I don't like what they give but from a learning point of view. Is it possible to get the data straight from ccp?


Short answer "no".

However, when you look up an item on the market, you can click the "Export to file" button and then parse the generated file. Rinse-repeat for every market item that you are interested in.

Or use a tool that scans and parses your EVE cache files (which get created the first time that you lookup a market item).
Philderbeast
Native Freshfood
Minmatar Republic
#7 - 2011-12-17 10:14:52 UTC
the importxml function works fine on google spreadsheets but not in excel.

any other suggestions (excel 2007 here)
Azrael Dinn
Imperial Mechanics
#8 - 2011-12-17 12:35:46 UTC
Philderbeast wrote:
the importxml function works fine on google spreadsheets but not in excel.

any other suggestions (excel 2007 here)


Yeah I tried that also and got it to work and works also with the quick import but both datas are retrieved from eve-central or so I asume at this point.

My own idea was to find out how to get data streight from eve-online and leave the middlehand out. Tough the data given by eve-central is magnificent I still wana learn to new things thats why I'm asking around :P

After centuries of debating and justifying... Break Cloaks tm
Scrapyard Bob
EVE University
Ivy League
#9 - 2011-12-17 21:40:00 UTC
Philderbeast wrote:
the importxml function works fine on google spreadsheets but not in excel.

any other suggestions (excel 2007 here)


You have to write a bit of code to approximate the ImportXML() function that Google Docs give you, including setting up data sources. (There are guides out there on the web, but I don't have links.)

It's a PITA, which is why I just use Google Docs for my manuf/profit sheets.
Professor Alphane
Les Corsaires Diable
#10 - 2011-12-18 17:33:17 UTC
Azrael Dinn wrote:
Philderbeast wrote:
the importxml function works fine on google spreadsheets but not in excel.

any other suggestions (excel 2007 here)


Yeah I tried that also and got it to work and works also with the quick import but both datas are retrieved from eve-central or so I asume at this point.

My own idea was to find out how to get data streight from eve-online and leave the middlehand out. Tough the data given by eve-central is magnificent I still wana learn to new things thats why I'm asking around :P


I think Bob already answered you with his second to last post. But if he wasn't clear.

You would need to write a program to extract data from market export files and/or read your cache.. and compile in a database.

[center]YOU MUST THINK FIRST....[/center] [center]"I sit with the broken angels clutching at straws and nursing our scars.." - Marillion [/center] [center]The wise man watches the rise and fall of fools from afar[/center]