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.
 

Keeping up with stock in a spreadsheet?

First post
Author
Previous Topic Next Topic
Joshua Meer
Doomheim
#1 - 2014-10-27 21:39:40 UTC
So I made a spreadsheet using google and copy paste. I seriously have no clue how I even got it all to work but I did.

However I would like to be able to see how many of an item I have for sale on the market on my spreadsheet.

Example : Imgur Picture

Where "Stock" is I would like an up to date amount of those items I have on the market. I use the type ids

for finding data and I also use excel 2013 for my spreadsheets.

I seriously have no clue even where to start looking at how to do this or if its even possible.

Thanks for any help.
salacious necrosis
Garoun Investment Bank
Gallente Federation
#2 - 2014-10-28 03:24:33 UTC
TL;DR

You can do this by sampling your market orders from the EVE API. Start here. "volRemaining" gives you want you want. You'll need to create an EVE API key at EVE Universe -> Support -> API Key management.

Longer answer:

You can set this up in Google Docs to auto-update your spreadsheet, but you'll need to write some javascript. There are several posts in this forum on how to do this by calling the EVE API directly.

(shameless-self-promotion)
This is really easy to do with EveKit as there is an API call that specifically selects live market orders. If you add your account there and create an access key for yourself, then I can share a google doc with you and post some javascript to get you started.
(/shameless-self-promotion)

Use EveKit ! - Tools for EVE Online 3rd party development
salacious necrosis
Garoun Investment Bank
Gallente Federation
#3 - 2014-10-29 00:11:35 UTC
I added a post on EveKit showing how to do this with Google Docs:

https://www.eve-kit.org/#/main/doc

If you make an EveKit account and access key, then you can copy this doc and insert your own credentials to sample your orders. Last time I checked, market orders had a cache time of 1 hour, so you won't exactly see live updates to your order history.

Use EveKit ! - Tools for EVE Online 3rd party development
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-10-29 02:42:48 UTC  |  Edited by: Steve Ronuken
To handle this properly, it's a little easier to do this in googledocs.

Mostly because I have code that's pretty much ready to do it now. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/MarketOrders.gs (if it doesn't work, try the previous version. I just updated it to handle numbers properly)

That's not to say it's not doable in Excel. My visual basic is just a litte rusty.


For what you'd want, you'd put it in a different tab, then vlookup it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Myopic Thyne
Accounts Payable.
#5 - 2014-10-30 18:15:20 UTC
For the record other option include another copy-paste field for your orders from the orders window in the wallet, or using something to eat the market logs that get spit out too.
Regnar Avastum
#6 - 2014-11-05 22:27:48 UTC
Why not just use an already established app called jEVEAssets?

http://eve.nikr.net/jeveasset

♔ ℜegnar's High-End Spreadsheets ♔™
salacious necrosis
Garoun Investment Bank
Gallente Federation
#7 - 2014-11-05 23:48:35 UTC
Regnar Avastum wrote:
Why not just use an already established app called jEVEAssets?

http://eve.nikr.net/jeveasset


No problem with that. The main point with Google docs (for me, at least) is that it's all online. So I can hit it from my phone, my friends laptop, my chromebook, etc.

Use EveKit ! - Tools for EVE Online 3rd party development