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.
 

Excel Spreadsheet - Large Amount of Calls
Author
Previous Topic Next Topic
Kivorno
Myanapa Corsica
#1 - 2012-09-28 08:21:26 UTC
Hi,

Was wondering what is the best way to pull a large amount of data into excel.

Seems a lot of work having to manually add the information via import from web and then request all the information through a lot of API calls or is there a more efficient way of doing it and pull all the information at once, then break it down?

Thanks in advance!

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint
Kivorno
Myanapa Corsica
#2 - 2012-09-28 09:45:32 UTC
Best way I've found so far is:

Import from web, then

http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&regionlimit=10000002

but is there a way instead of doing typeid=34&typeid=35 to typeid=34*TO*typeid=40 ?

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-09-28 09:58:57 UTC
Kivorno wrote:
Best way I've found so far is:

Import from web, then

http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&regionlimit=10000002

but is there a way instead of doing typeid=34&typeid=35 to typeid=34*TO*typeid=40 ?



if all you're interested in is the percentile sell price:

http://www.fuzzwork.co.uk/market/prices.csv

is pretty much everything (that's been reported at least once in the last 20 days. as I started it then) that's used for manufacturing, as a product or a component. 5% percentile price.

Updated once an hour. Prices from the forge region.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kivorno
Myanapa Corsica
#4 - 2012-09-28 10:17:51 UTC  |  Edited by: Kivorno
Thanks, has provided useful information :)

Getting somewhere near to what i want, imported all the data for the minerals

but if I wanted to import more, see a lot of other peoples spreadsheets can do a good chunk of items in game but it does seem tedious doing an import for 10-20 items at a time.

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint