open All Channels
seplocked Market Discussions
blankseplocked Spreadsheets?!?
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Duo Sandorian
Posted - 2011.06.28 11:47:00 - [1]
 

Spreadsheets, how do they work? I am a relatively new trader working on station trading and I know trading "secrets" are normally absurdly well guarded, but I was just wondering how exactly to start my own spreadsheets. What sort of information do I put on them, where does that information come from (There are a bunch of Export buttons in eve, do I use those?) Any information concerning the creation of spreadsheetswould be appreciated.

Brock Nelson
Posted - 2011.06.28 12:04:00 - [2]
 

Profit = Gross Profit - Gross Cost

Go from there with that simple formula

Atima
Minmatar
House of Marbles
Posted - 2011.06.28 12:22:00 - [3]
 

Edited by: Atima on 28/06/2011 12:22:39
This much like :

I've just bought a freighter, how do I make money with it?


When you need a spreadsheet, you'll know it. A spreadsheet is a tool.

You don't think right I have a screwdriver, what should I make?? You think right I need a screwdriver to assemble this flatpacked stuff.

Elise DarkStar
Posted - 2011.06.28 12:28:00 - [4]
 

Originally by: Atima
Edited by: Atima on 28/06/2011 12:22:39
This much like :

I've just bought a freighter, how do I make money with it?


When you need a spreadsheet, you'll know it. A spreadsheet is a tool.

You don't think right I have a screwdriver, what should I make?? You think right I need a screwdriver to assemble this flatpacked stuff.


Exactly. Saved me some typing. Thanks, jiveturkey.

Joe Forum
Amarr
Posted - 2011.06.28 12:57:00 - [5]
 

http://www.google.com/google-d-s/spreadsheets/

This is a good place to start.

knanid volatar
Posted - 2011.06.28 18:39:00 - [6]
 

Edited by: knanid volatar on 28/06/2011 18:40:25
Originally by: Duo Sandorian
Any information concerning the creation of spreadsheetswould be appreciated.


In Excel:

1. Click File (top left of screen)
2. Select New Document
3. In the sub menu that pops up click 'Blank Workbook'

Don't use googledocs that much so someone else will have to help there.

Hope that helps, let me know if you run into any issues.

kv

edit - on reflection, the process is likely to be fairly similar for both Googledocs and OpenOffice.

Wooker Tosk
Posted - 2011.06.28 19:26:00 - [7]
 

I can share in the OP's sentiment a little. While i'm no stranger to spreadsheets there are some more advanced methods of using them for profit in eve I'd love to know more about.

Using them with the API especially. If anyone knows more about this I'd love to read any guides out there. So far the pickings have been slim.

SencneS
Rebellion Against Big Irreversible Dinks
Posted - 2011.06.28 20:10:00 - [8]
 

Originally by: Wooker Tosk
I'd love to read any guides out there. So far the pickings have been slim.


There is a reason those pickings are slim...

People dump the heart and SOUL into their sheets, they often produce sheets which others have difficulty understanding just what is going on when, and where. The outcome is never really what the "user" wants, but is perfectly fine for the "Creator" wants..

Me personally, I have a sheet for pretty much every activity in EVE I've ever done, and that's including taking on more then 1000 moon scan results scattered across systems in low and null sec and produce which system can produce which T2 items. All the way down to a really simple mining capacity calculator.

My stuff is often so detailed it's overly detailed with information like volume of materials required to do X, so I know if I need my freighter or will my hauler or even a fat frigate will be enough. They almost always take into consideration buy price along with minimal sell price.

Here is something for the thread.

This is literally a cell in my marketing sheet. Cell "reference" are within the square brackets. e.g. [Quantity of Item]

=IF([Quantity of Item]=0,ROUNDUP(((IF([Quantity of Item]=0,0,IF([Purchased with Buy Order]="Y",MAX(([Quantity of Item]*[List Price of Item])*(1+(IF([Purchased with Buy Order]="Y",EXP(LN(1-(0.05*[Broker Relation Level]))-(0.1*[Personal Standing of Station's Faction])-(0.04*[Personal Corporate Standing of Station's Corporation]))/100,0))),100+([Quantity of Item]*[List Price of Item])),[Quantity of Item]*[List Price of item])))/(1-(IF([Sold with Sell Order]="Y",(EXP(LN(1-(0.05*[Broker Relation Level]))-(0.1*[Personal Standing with Station's Faction])-(0.04*[Personal Standing with Station's Corporation]))/100)+((1-([Accounting Level]*0.1))/100),(1-([Accounting Level]*0.1))/100)))),2),IF([Sold with Sell Order]="Y",MAX(ROUNDUP((((IF([Quantity of Item]=0,0,IF([Purchased with Buy Order]="Y",MAX(([Quantity of Item]*[List Price of Item])*(1+(IF([Purchased with Buy Order]="Y",EXP(LN(1-(0.05*[Broker Relations Level]))-(0.1*[Personal Standing of Station's Faction])-(0.04*[Personal Standing of Station's Corporation))/100,0))),100+([Quantity of Item]*[List Price of Item])),[Quantity of Item]*[List Price of Item])))/(1-(IF([Sold with Sell Order]="Y",(EXP(LN(1-(0.05*[Broker Relations Level]))-(0.1*[Personal Station with Station's Faction])-(0.04*[Personal Standing with Stations Corporation]))/100)+((1-([Account level]*0.1))/100),(1-([Accounting Level]*0.1))/100)))/[Quantity of Item])),2),ROUNDUP(((((IF([Quantity of Item]=0,0,IF([Purchased with Buy order]="Y",MAX(([Quantity of Item]*[List Price of Item])*(1+(IF([Purchased with Buy Order]="Y",EXP(LN(1-(0.05*[Broker Releations Level]))-(0.1*[Personal Standing with Station's Faction])-(0.04*[Personal Station with Station's Corporation]))/100,0))),100+([Quantity of Item]*[List Price of Item])),[Quantity of Item]*[List Price of Item])))+100)/(1-((1-([Accounting Level]*0.1))/100))/[Quantity of Item])),2)),ROUNDUP(((IF([Quantity of Item]<=0,[List Price of Item],(IF([Quantity of Item]=0,0,IF([Purchased with a Buy Order]="Y",MAX(([Quantity of Item]*[List Price of Item])*(1+(IF([Purchased with Buy Order]="Y",EXP(LN(1-(0.05*[Broker Releations Level]))-(0.1*[Personal Standing with Station's Faction])-(0.04*[Personal Standing with Station's Corporation]))/100,0))),100+([Quantity of Item]*[List Price of Item])),[Quantity of Item]*[List Price of Item])))/[Quantity of Item))/(1-(IF([Sold with Sell Order]="Y",(EXP(LN(1-(0.05*[Broker Relations Level]))-(0.1*[Personal Standing with Station's Faction])-(0.04*[Personal Standing with Station's Corporation]))/100)+((1-([Accounting Level]*0.1))/100),(1-([Accounting Level]*0.1))/100)))),2)))


Enjoy :)

Oh, it basically tells you what the minimal price to sell the item in question, according to the way the item was purchased and sold, you know Broker fees etc. Laughing

Yeah, people like to keep their stuff Private.

Mu-Shi Ai
The Chrysalis Group
Posted - 2011.06.29 01:14:00 - [9]
 

In my situation, my interest in spreadsheets only extends to keeping tabs on the higher-level stats of my trade business. To this end, I've made 9 columns on my Google Docs spreadsheet.

1) "Date": This, as you might expect, holds rows for the date of each day of trading.
2) "ISK Buy": The rows in this column show the total value, in ISK, that I bought for each day.
3) "ISK Sell": The rows in this column show the total value, in ISK, that I sold for each day.
4) "ISK Profit": The rows in this column show the total profit, in ISK, that I made for each day.
5) "% Profit": The rows in this column show the % profit that I had for each day. (Each cell divides the corresponding day's "ISK Profit" by its "ISK Sell")

Just a note: I rely on eve-profit.com to get the raw data regarding daily buy/sell/profit, and then I enter this information manually.

6a) "ISK Buy Avg.": There is simply one cell for this, the formula for which calculates the average of the values in my "ISK Buy" column.
6b) "ISK Buy Total": Another cell, which calculates the sum of the values in my "ISK Buy" column.

7a) "ISK Sell Avg.": Single cell, averages the values in the "ISK Sell" column.
7b) "ISK Sell Total": Single cell, sums the values in the "ISK Sell" column.

8a) "ISK Profit Avg.": Single cell, averages the values in the "ISK Profit" column.
8b) "ISK Profit Total": Single cell, sums the values in the "ISK Profit" column.

9a) "Daily % Profit Avg.": Single cell, averages the values in the "% Profit" column.
9b) "Total % Profit": Single cell, "ISK Profit Total" divided by "ISK Sell Total".

And then I made a small area dedicated to calculating my NAV at the end of each month. For me, all I need to record is wallet, sell orders, buy orders, and assets.

All-in-all, it's very helpful to be able to see how much profit you average daily, because you get a sense of how much you can expect to clear on the month. It's also good to be able to see if there's an imbalance in how much you buy and sell, so you can tweak your setup and avoid overstocking. Personally, I know I'm making nice profits on all the items I trade in, so I'm not so worried about knowing % profit at the micro level, but it's nice to be aware of it as a larger average or total.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only