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.
 

What to look for in custom made spreadsheets?

Author
Lukas Tandzi
The Scope
Gallente Federation
#1 - 2016-03-22 15:20:04 UTC
I'm about to buy myself some market spreadsheets. Is there any spreadsheets that you would highly recommend?
Part from the standard total margin and % margins is there any other columns that is a must have?

Had my eye on ℜegnar's High-End Spreadsheets for a while but gonna scout around some more.

Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2016-03-23 07:44:30 UTC  |  Edited by: Zad Murrard
All matter of personal taste and depends a bit what you do and where.

Some things that may be interesting
- profit / unit in isk not %
- average sales volume / chosen time unit
- estimated profit/day with the number of items you think you can sell per chosen time unit
- your estimated total profit with whatever number of items you choose to sell in some chosen time unit
- reference price in some other destination/destinations
- historical price average of the product in the last X days/weeks/months
- lowest price of the item in your chosen destination
- the relation of that price to the price you are listing your stuff
- relation of the number of items with lower price than yours to the number of items you are using
- conditional information which tells you in different terms the situation of the item, info can be eg: the item is under heavy competion, you should wait, the item is profitable, the item is not profitable, the item will be profitable most likely in X days/weeks/months, you are ouf of stock, you will be out of stock in X days/weeks/months
- if the item can also be manufactured, the price of the item when manufactured from buy/sell orders
- if the item is lp item, the lp price which could be used as an indicator to estimate whether the item is currently under or overpriced
- if the item is lp item, historical lp price indicator and the relation of current lp price to that
- supply source indicator, if the item can be only received from special occasions your approach to it could be different
- historical killboard analysis and recent killboard analysis, if the item is used in ships you want to know beforehand the sudden needs and also spot long term decreasing needs
- tired of typing, but there are many more potentially useful columns

Thus my overall recommendation:
Make your own spreadsheet and experiment what colums work best for you Cool
Hel O'Ween
Men On A Mission
#3 - 2016-03-23 17:30:06 UTC
Lukas Tandzi wrote:
I'm about to buy myself some market spreadsheets.


Buy? There are tons of free trading tools out there. No need to buy something, especially spreadshets.

EVEWalletAware - an offline wallet manager.

Miezip Eclipse
Project Eclipse
#4 - 2016-04-07 11:23:44 UTC
Just FYI https://forums.eveonline.com/default.aspx?g=posts&t=295315

all free, but not all up to date
Serena Darknight
Doomheim
#5 - 2016-04-11 01:36:44 UTC
Does these sheets require Excel 2013?