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 Market Orders
Author
Previous Topic Next Topic
MatthewMN
Star Frontiers
Brotherhood of Spacers
#1 - 2012-06-08 05:22:46 UTC
Hey All,

Is there a way to make excel auto update how many remaining items are left on a sell order? I have the excel set up the way I like it, but it's hard going from Eve Mon or other tools and updating the remaining amounts each day.



Thanks,
MatthewMN
MatthewMN
Star Frontiers
Brotherhood of Spacers
#2 - 2012-06-08 17:00:10 UTC
Bump
Diana Kim
State Protectorate
Caldari State
#3 - 2012-06-08 17:23:06 UTC
Sure. You can use eve-central API for excel macro, request your items on your station, and then parse it, looking for items with your price, extract quantity and put in desired cell.

Honored are the dead, for their legacy guides us.

In memory of Tibus Heth, Caldari State Executor YC110-115, Hero and Patriot.
Fiat Money
EVE Sky Corp
#4 - 2012-06-08 17:39:05 UTC
MatthewMN wrote:
Hey All,

Is there a way to make excel auto update how many remaining items are left on a sell order? I have the excel set up the way I like it, but it's hard going from Eve Mon or other tools and updating the remaining amounts each day.

Thanks,
MatthewMN


If you can make your spreadsheet use EVE API you have it, but as Transaction API can only be triggered each hour once, that's not a solution for short time updates like used for fast trading and stuff.

As for myself, I'm using Excel Fu for years now and it works fine for order monitoring. Just export your orders out of EVE client and sync it with your last export, highlight orders that have been used up, so you will never forget to set up another one. The only disadvantage of that method is, that the tool will never distinguish between a canceled and finished order, so item counts and median prices are missleading.

I've also begun with pencil and paper the very first time Big smile now a nice sheet can manage hundreds of orders with two clicks.
MatthewMN
Star Frontiers
Brotherhood of Spacers
#5 - 2012-06-08 17:39:48 UTC
Is "eve-central API for excel Macro" something I can google? or can you help me out with a link? Thanks!