open All Channels
seplocked EVE Technology Lab
blankseplocked Quick Question About Importing Data Into Excel
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Aaron Younger
Posted - 2011.07.21 12:02:00 - [1]
 

I'm sorry if this has been asked before but i tried searching and I'm not really sure what i should be searching for so I didn't get any results.

I want to pull market data from eve-central. Easy enough I have been doing it for a while and that that's not that hard. However the way I've been doing it has been messy and extremely tedious. I'm trying to find a way to stream line the process. Is there a way that I can obtain market data for every item in game at once from all of the Empire regions? Then I can just use a VLOOKUP for the typeid and be able to find the row with that items market data and pull from it. I've seen(but can't seem to find again) how someone was able to pull the data by using the cells instead of manually typing in each individual typeid. Was I just seeing things and that's why I can' seem to find it again? Maybe something like http://api.eve-central.com/api/marketstat?(A2)&(A3)...etc where the items in row A are all of the typeids?

Also is there a way to only import certain columns of the imported data such as Median Buy and Median Sell and that's it? I've been trying to mess around and try to figure it out but i always seem to mess it up and then no data can be imported and i have to redo the xml import.

Thanks for any help anyone can give.

Aaron Younger
Posted - 2011.07.22 15:25:00 - [2]
 

None of the great excel gods out there can help any?


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only