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.
 

Spreadsheet Creation
Author
Previous Topic Next Topic
Gnlarck
Brutor Tribe
Minmatar Republic
#1 - 2012-01-05 02:39:12 UTC
Alright, I know the basics about making spreadsheets. Entering forumlas etc.

However, I was curious as to how to make the API system work?
I.e. Being able to use my trader alts full API key to keep tabs on my order ammounts and once I hit an 'update' button, it automatically pulls the market information and updates the volumes I have left in my orders so I don't have to do it all manually.

I hope you guys understand what I'm after, Thanks!

GN Big smile
Block Ukx
420 Enterprises.
#2 - 2012-01-05 03:40:42 UTC


Yes, it is possible to program a button to do what you want in excel.

You will need to learn:
1) How to create buttons in excel.
2) Work with worksheets and objects in excel.
3) HTTP requests with visual basic.
4) Learn about API requests (MarketOrders.xml.aspx in your case)

You should visit the Tech forum for more information.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-01-05 14:08:50 UTC
Important thing to be aware of: 'Full api keys' aren't something to use any more. You can't create new ones, and the older ones will be going away at some point. Instead you have Customised Access Keys. Where you can have a bunch of different keys, all with different access levels.

https://api.eveonline.com/char/MarketOrders.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Is the url for getting the data out. using it as a xml data source in excel will allow for updates (and it'll just show up as rows of data). Though you'll lose historical data if you don't copy it somewhere else after that.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter