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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Excel and APIs
Author
Previous Topic Next Topic
Xargun
X-Industries and Design
#1 - 2016-05-12 20:18:47 UTC
I want to setup an Excel spreadsheet and use API to automatically import mineral prices from Amarr. I believe this is possible. Can someone point me in the right direction on where to find this information ? Thank you

Xargun
Jay Aaron
M-Spec Industrial Resources Ltd
Agents of Fortune
#2 - 2016-05-12 23:27:21 UTC
Google "Eve api" and you'll be pointed to a wealth of resources...
Mad Vemane
University of Caille
Gallente Federation
#3 - 2016-05-13 01:34:43 UTC
there is a tutorial on eve central's website

you could also use:

=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30003480&typeid=***********),"//buy/max")

replace ***** with the id of minerals, //buy/max for buy price, //sell/min for sell price (or //buy/avg //sel/avg for average price)

ID 34 to 40 will give you minerals, and 11399 for morphite

(You can also use this to import price of any item if you know their ID, or you can use something a bit more complicated to get name to ID)
Xargun
X-Industries and Design
#4 - 2016-05-13 15:27:02 UTC
Mad Vemane wrote:
there is a tutorial on eve central's website

you could also use:

=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30003480&typeid=***********),"//buy/max")

replace ***** with the id of minerals, //buy/max for buy price, //sell/min for sell price (or //buy/avg //sel/avg for average price)

ID 34 to 40 will give you minerals, and 11399 for morphite

(You can also use this to import price of any item if you know their ID, or you can use something a bit more complicated to get name to ID)


I got it to work but Amarr's id is 30002187. Thanks for the help.

Xargun