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.
 

EVE Marginal Trading Profit Spreadsheet
Author
Previous Topic Next Topic
Aldarr Mentakk
Dragon.
Pandemic Horde
#1 - 2013-01-22 13:04:25 UTC  |  Edited by: Aldarr Mentakk
I made a spreadsheet for marginal traders to use to find their profits easier. Just follow the instructions and figure your profits. I welcome any feedback and suggestions. Just make a copy of it for yourself to edit it.

I know anyone can draw up a simple spreadsheet but at least now there is one readily available for people to take advantage of.

Keep in mind that this is only for buying directly from market and selling to open buy orders. This is not meant for station trading as there are other taxes incurred when setting up buy and sell orders yourself.

Please bump if you like this!

v1.0
-Has an area to input your ships cargo m3 as well as the item's m3 to tell you how many trips you'll have to do as well as profit per trip.
-Has a wallet tracker that allows you to input wallet data to track your profits/losses for 100 days.
v1.001
-Made changes where all the inputs are now located in cells A-F, for easier input. Just fill that information out and let the spreadsheet do the rest of the work.
-Changed the colors around a bit to highlight costs, losses, taxes, and profits.


https://docs.google.com/spreadsheet/ccc?key=0Ag1HAfKjpfIZdFFZS0hZRGJ3UUxMXzFDcEgzY09CaUE
Claire Coffee
Coffee Inc
#2 - 2013-01-22 16:06:44 UTC
That's pretty neat.

[b]DRINK COFFEE Do stupid things Faster with More Energy[/b]
Brandon Syne
Straxus Innovations
#3 - 2013-01-22 16:17:21 UTC
>manual inputs

ISHYGDDT
Aldarr Mentakk
Dragon.
Pandemic Horde
#4 - 2013-01-23 00:35:12 UTC
A new version will be out later today where all the input on the actual sheet will be on the left and all the calculated totals will be on the right, so no more having to search for where the input values are.
ItchyJuffoWup
Deep Core Mining Inc.
Caldari State
#5 - 2013-01-23 00:53:35 UTC
Really like the idea, i mare one similar that i use now I'm going to give yours a try and see whether i like your setup more!

"Insert witty quote from some old dead poet here"
Aldarr Mentakk
Dragon.
Pandemic Horde
#6 - 2013-01-23 01:20:37 UTC
I just uploaded the new one.

v1.001
-Made changes where all the inputs are now located in cells A-F, for easier input. Just fill that information out and let the spreadsheet do the rest of the work.
-Changed the colors around a bit to highlight costs, losses, taxes, and profits.
SinTeryx
Ministry of War
Amarr Empire
#7 - 2013-01-24 14:34:24 UTC
Great little tool. Especially as a mac user I have been hard pressed to find things like this. Much appreciated.
+1
-Sin

These may as well be farts in the wind but I have had a few beers since the start of this thread.
Aldarr Mentakk
Dragon.
Pandemic Horde
#8 - 2013-01-25 04:02:31 UTC
Also if anyone has any ideas for any other little tools I can add, such as the Wallet Tracker, just reply here and I'll see what I can do.
Aldarr Mentakk
Dragon.
Pandemic Horde
#9 - 2013-01-26 11:52:39 UTC
bump!
Aldarr Mentakk
Dragon.
Pandemic Horde
#10 - 2013-01-27 09:25:02 UTC
Aldarr Mentakk wrote:
bump!
Aldarr Mentakk
Dragon.
Pandemic Horde
#11 - 2013-01-30 10:06:02 UTC
I have a few spreadsheets in the making right now that I will be posting to the forums as soon as they are done in one new forum thread, so if you enjoyed this one keep an eye out for the new thread. Hopefully if everything goes well they will all be complete by the end of the week.
MailDeadDrop
Archon Industries
#12 - 2013-01-30 17:29:25 UTC
A few small defects.

  1. Column E Row 1 on the "Example01" and "Actual" pages should be "Unit Volume"
  2. Column E Row 2 on the "Example01" page should be something like "How much room 1 unit takes"
  3. Column F Row 1 on the "Example01" and "Actual" pages should be "Ship's Cargo Capacity"
  4. Column F Row 2 on the "Example01" page should be something like "Your Ship's Cargo Capacity in m3"
  5. Column G Row 1 on the "Example01" and "Actual" pages should be "Total Volume"


MDD
Aldarr Mentakk
Dragon.
Pandemic Horde
#13 - 2013-01-31 03:51:06 UTC
MailDeadDrop wrote:
A few small defects.

  1. Column E Row 1 on the "Example01" and "Actual" pages should be "Unit Volume"
  2. Column E Row 2 on the "Example01" page should be something like "How much room 1 unit takes"
  3. Column F Row 1 on the "Example01" and "Actual" pages should be "Ship's Cargo Capacity"
  4. Column F Row 2 on the "Example01" page should be something like "Your Ship's Cargo Capacity in m3"
  5. Column G Row 1 on the "Example01" and "Actual" pages should be "Total Volume"


MDD




fixed, thank you