Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Joshua Meer
Black Hole Logistics
0
|
Posted - 2014.10.27 21:39:40 -
[1] - Quote
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
Federal Defense Union Gallente Federation
1
|
Posted - 2014.10.28 03:24:33 -
[2] - Quote
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) |
salacious necrosis
Federal Defense Union Gallente Federation
1
|
Posted - 2014.10.29 00:11:35 -
[3] - Quote
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.
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4090
|
Posted - 2014.10.29 02:42:48 -
[4] - Quote
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 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Myopic Thyne
Shattered Paradigm Eon.Apocalypse
30
|
Posted - 2014.10.30 18:15:20 -
[5] - Quote
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
14
|
Posted - 2014.11.05 22:27:48 -
[6] - Quote
Why not just use an already established app called jEVEAssets?
http://eve.nikr.net/jeveasset
Providing-áTrade/Manufacture/Research spreadsheets
|
salacious necrosis
Federal Defense Union Gallente Federation
1
|
Posted - 2014.11.05 23:48:35 -
[7] - Quote
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.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |