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.
 

So I'm a spreadsheet noob...
Author
Previous Topic Next Topic
Aina Sasaki
Garoun Investment Bank
Gallente Federation
#1 - 2012-07-05 04:23:14 UTC  |  Edited by: Aina Sasaki
As the title implies, i'm not exactly an expert when it comes to spreadsheets. I've never really used them before, nor am I really familiar with what their use actually is. However, I have read on several occassions that a few market people use them, and have found them to be quite helpful in some way. Although I have not had a problem with making ISK, i'll take any extra advantage I can get if it is not too obnoxious to implement. So... I have some questions about these... things. :o

1. How are spreadsheets used for market activity in Eve?

2. For those who use spreadsheets for market stuff, how useful do you find them?

3. Do you know of any particularly good guides for learning how to create these kinds of spreadsheets?

4. What is your favorite color? Shocked


Hope to hear what the MD experts have to say here! :Smile

- Rei
enterprisePSI
#2 - 2012-07-05 08:10:04 UTC
what is the speed velocity of an unladen swallow?

The tears of the many, outweigh the tears of the few. Or the one. enterprise-psi©
Andy DelGardo
#3 - 2012-07-05 08:53:15 UTC
Aina Sasaki wrote:

1. How are spreadsheets used for market activity in Eve?

2. For those who use spreadsheets for market stuff, how useful do you find them?

3. Do you know of any particularly good guides for learning how to create these kinds of spreadsheets?

4. What is your favorite color?



General: A spreadsheet is a mere tool to do whatever calculation u want to lay out, the advantage is the rapid development/iteration and the visual ease of use, compared to "tools" like programming or paper/mind calculation. There are other tools that exists like "IPH (ISK per hour)", but many of us use spreadsheets because u can tinker and compose them to your exact needs. For example i use the data highlight functions in excel and find those extremely helpfully to identify opportunities and evaluate the waste amount of data.

1) XML data import from Eve-Central and other sites to grab the prices and orders. Than u simply try to calculate the profit or add the data also to a database for your own historically data. This differs by profession, a trader is looking for trade margins, while a producer at least needs to calculate the production profit. The hauler need to find region differences.

2) Extremely usefully, since i get "current" market data i can rely on, if i uploaded the data just 5mins ago. So i can calculate whatever i like and be sure it reflects actual in-game data. Spreadsheets are also more flexible and even as a programmer myself, i still find it more usefully than writing a "market" tool, since the ability to easily visualize data is what makes a spreadsheet shine.

3) Check/search the Eve lab forum for eve-central xml guides, than there are those:
http://ues.eve-eei.us/ues.php
http://dedafsindustrialtool.blogspot.de/

4) blue


bye Andy
SegaPhoenix
Chicks on Speed
#4 - 2012-07-05 14:41:47 UTC
enterprisePSI wrote:
what is the airspeed velocity of an unladen swallow?


FTFY

http://www.youtube.com/watch?v=y2R3FvS4xr4
Estel Again
Doomheim
#5 - 2012-07-05 15:40:23 UTC
2. indispensable
3. just do it; it's the best way to get the hang of it
4. yellow
Aina Sasaki
Garoun Investment Bank
Gallente Federation
#6 - 2012-07-05 23:07:23 UTC
Thanks Andy. I'll check that stuff out later. I hope it can be helpful! :D

- Rei
Katriana Mosvani
Aliastra
Gallente Federation
#7 - 2012-07-06 21:29:19 UTC
Andy DelGardo wrote:
[quote=Aina Sasaki]


*snip*

Spreadsheets are also more flexible and even as a programmer myself, i still find it more usefully than writing a "market" tool, since the ability to easily visualize data is what makes a spreadsheet shine.

*snip*



Yes, I find myself writing tools to automate certain processes, then generating spreadsheets to manipulate for visualization.
Hotstud SexyFamilia
University of Caille
Gallente Federation
#8 - 2012-07-07 07:30:39 UTC
Hmmm interesting.
Aina Sasaki
Garoun Investment Bank
Gallente Federation
#9 - 2012-07-07 10:18:08 UTC
Hotstud SexyFamilia wrote:
Hmmm interesting.


How so? :o

- Rei
khall Aa'Blauth
Pator Tech School
Minmatar Republic
#10 - 2012-07-11 10:56:57 UTC
They are useful, truely useful.

I've set up a small one to help me ensure that the fee and taxes don't eat my profits when the difference between buy and sell is minimal.

Basically it goes like this.

A is the price of item when bought ( input in any cell, ex F4)
A tax + fee is then added to buy price ( formula =F4+(F4/100*2.5) this will add 2.5 % taxes and fees
B is the price of item when sold (input in any cell, ex J4)
B tax is the price of item with tax deducted from sale price (formula =J4-(J4/100*1) this will deduct 1% taxes
C is A tax minus B tax ( formula would be cell with B tax minus cell with A tax+fee )

This gives a two input spreadsheet that quickly tells you that you can buy a item for ex 5 ISK and sell for as low as 5.18 ISK as still don't take a loss.
You can expand this to calculate profits in % as well.

Another option is to make taxes and fees calculate outside the example above, and then have those values added automatically. At the same page as the rest you'd have inputs for tax and fee at buy and those added in a cell under that. =tax buy+broker fee, and then the same for sales tax. Then you'd link the output of those calculations to the formula in A tax + fee and B tax. ( ex: total fee + tax buy is in cell G8 ) Formula for A tax + fee would then be =F4+(F4/100*G8) The formula would then refer to whatever values it finds in cell G8. Useful when stanings and skills changes the expenses instead of rewriting every formula.

Hope I helped to clear it up instead of confusing. Basically, it saves you loads of time
Matrim Barr
Caldari Provisions
Caldari State
#11 - 2012-07-11 11:01:40 UTC
Nikodiemus
Ganja Clade
Shadow Cartel
#12 - 2012-07-11 11:43:39 UTC
Step 1: Wonder how much money you can make producing 100mn MWD
Step 2: List quantities of all inputs and their costs on market including BP and job time//install cost
Step 3: Profit (maybe) else -> go back to step 1 and substitute 100mn MWD with XXXXXX
Vellen Thoss
The Scope
Gallente Federation
#13 - 2012-07-13 12:59:59 UTC  |  Edited by: Vellen Thoss
enterprisePSI wrote:
what is the speed velocity of an unladen swallow?


African or European?

That being said, I guess I need to lrn2spreadsheet.
Batelle
Federal Navy Academy
#14 - 2012-07-13 16:49:34 UTC
the only thing I had trouble with was getting my spreadsheets to update prices automatically. If I could get them to do that AND check my assets API to see how many units of X i have in station Y, then I'd be a rich guy.

"**CCP is changing policy, and has asked that we discontinue the bonus credit program after November 7th. So until then, enjoy a super-bonus of 1B Blink Credit for each 60-day GTC you buy!"**

Never forget.
Chevalleis
The Scope
Gallente Federation
#15 - 2012-07-13 17:33:06 UTC
You just have to create an xml cell that leads to a price website and it will update automatically as the site updates its data. If that's what you were asking.