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

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

Want Ads & Trades

 
  • Topic is locked indefinitely.
 

Market Spreadsheet

Author
Floriana Aulus
Center for Advanced Studies
Gallente Federation
#1 - 2015-09-01 01:17:37 UTC  |  Edited by: Floriana Aulus
I'm looking for a market/trade spreadsheet with these features:

- all the standard features of a trade spreadsheet (current min sell, current max buy, gross margin, taxes and fees, net margin, net percentage margin)
- ALSO, a column that includes the volume of sales of that item (e.g. in the last 24 hours); data for what is the current market stock of that item in the specific trade hub
- A function that lets me easily change the data I'm examining between different trade hubs
- Easy to customize filters and conditional formatting; so, for instance, if I want net percentage margin that is over 20% to be highlighted in green, I can do that. But if I want to change it to 15%, it's easy for me to do that by just changing one value in the spreadsheet. I'd like a similar conditional formatting function for gross margin (e.g. highlight in blue all items that are over 10m) and for trade volume

I'm willing the pay a good amount for this if it's done right, but of course what people think is "a good amount" varies a lot! So if any of you have a spreadsheet that can do the above (or comes close) or if you want to edit/create one, contact me in-game! The name is Floriana Aulus.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2015-09-29 10:11:52 UTC
There's no way to implement for all items

'- ALSO, a column that includes the volume of sales of that item (e.g. in the last 24 hours); data for what is the current market stock of that item in the specific trade hub'

Crest provides some api, but it only allows one item/query. Thus trying to do this for more than X items will not work.
Eve marketdata atm. returns somewhat bogus values and thus cannot be fully trusted and in general would not have this data for all items in all places.