Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Commander Disarray
|
Posted - 2011.07.17 23:23:00 -
[1]
Ok, I've created an Excel sheet with macros to figure out how much I'm profiting (or losing) from trading. I'm using only the Wallet Transactions exported from this site and using macros to format and calculate that data. I can sum up the Buys and Sells to get the gross buys and sells for a given period of time, then subtract buys from sells to get the gross profit. Great, but we know it doesn't end there.
I can then take the gross sells, and multiply that with my transaction tax rate and figure out my net sell amount (right?).
The problem lies with the brokers fees. There are two times where they are applied, I believe. Once when you create a sell order, and once when you create a buy order. Is it possible to just take my broker fee rate, and multiply that with my gross sells and gross buys to get the total brokers fee amounts for both, and then use that to calculate my net profit/loss?
I'm not sure if it's that simple, and I have a feeling I'm missing something. I'm trying not to use Wallet Journal but can I figure all this out without it?
-Confused trading noob
|
Exemplary
|
Posted - 2011.07.17 23:57:00 -
[2]
Edited by: Exemplary on 17/07/2011 23:58:46 Edited by: Exemplary on 17/07/2011 23:58:09 I don't think you need to calculate broker fees. Your total sums are already broker fee deducted. If you wanted to know what your own broker fees amount to, just try to sell/buy an item at a station and look at the brokerage charge percentage. Then it should be simple to factor that in to calculations.
When tax and broker fees are in combination, just add them together as a single deduction when calculating.
Hope this helped!
|
Thoraemond
Minmatar Far Ranger
|
Posted - 2011.07.18 00:25:00 -
[3]
Market Order Broker Fees are paid when you set a standing Buy Order or a standing Sell Order (i.e., they are not paid when you set an order with duration "Immediate"). If you update a standing order, you pay a Market Order Broker fee on the increase in value at the time you execute the update. There is a minimum Fee of 100 ISK.
As for how much the Fee is: Chart illustrating the effect of standings on Market Order Broker Fees.
|
Commander Disarray
|
Posted - 2011.07.18 03:09:00 -
[4]
Originally by: Exemplary Edited by: Exemplary on 17/07/2011 23:58:46 Edited by: Exemplary on 17/07/2011 23:58:09 I don't think you need to calculate broker fees. Your total sums are already broker fee deducted. If you wanted to know what your own broker fees amount to, just try to sell/buy an item at a station and look at the brokerage charge percentage. Then it should be simple to factor that in to calculations.
When tax and broker fees are in combination, just add them together as a single deduction when calculating.
Hope this helped!
Let's say for example, my total buys for July are 43 billion. My total sells for July are 44.1 billion. So my gross profit is 1.1 billion. I apply my tax rate (.007) to my total sells, which comes out to about 300 million, so my first net profit amount so far is 800 million.
I've found my broker fee to be .003311...
So I guess where I'm still confused is here. Do I take that broker fee percentage and multiply it with my gross sell and gross buy amounts? Doing that makes my broker fees for gross sells 146 million, and for gross buys 142 million, giving me a net net profit of 517 million. Does that sound right????
|
Deus Mallius
ANZAC ACADEMY
|
Posted - 2011.07.18 06:50:00 -
[5]
Edited by: Deus Mallius on 18/07/2011 06:50:39 You can't do total sell - total buy.
You do Item sell - item buy- fees.
So you buy an item for 100 isk, sell it for 200, fees are (for ease, using a brand new char) 3%, so profit is 200 - 100 - (1% * 100 + 1% * 200 + 1%* 200) = 200 - 100 - 5 = 95 isk profit.
edit - spelling
|
Commander Disarray
|
Posted - 2011.07.19 16:56:00 -
[6]
Originally by: Deus Mallius Edited by: Deus Mallius on 18/07/2011 06:50:39 You can't do total sell - total buy.
You do Item sell - item buy- fees.
So you buy an item for 100 isk, sell it for 200, fees are (for ease, using a brand new char) 3%, so profit is 200 - 100 - (1% * 100 + 1% * 200 + 1%* 200) = 200 - 100 - 5 = 95 isk profit.
edit - spelling
That mostly makes sense, except where did the second "1% * 200" in your fee calculation come from (I underlined it)?
Also, I'm guessing there isn't a way to import buy data on each item sold? Is there an app for that?
|
Roguehalo
Caldari Roguehalo Ship Brokers
|
Posted - 2011.07.19 17:42:00 -
[7]
If you are setting regional buy orders and selling inventory in situ then your selling brokerage fees will differ depending on the standings you have with the station owner.
|
MMarlon
SRBI Circle-Of-Two
|
Posted - 2011.07.19 17:56:00 -
[8]
Second 1%*200 is again brokerage fees; You can import nice log of your transactions using API and excell, I think there was something on forums, google it.
|
Nomad Quento
Minmatar
|
Posted - 2011.07.19 20:03:00 -
[9]
Originally by: Commander Disarray Ok, I've created an Excel sheet with macros to figure out how much I'm profiting (or losing) from trading. I'm using only the Wallet Transactions exported from this site and using macros to format and calculate that data. I can sum up the Buys and Sells to get the gross buys and sells for a given period of time, then subtract buys from sells to get the gross profit. Great, but we know it doesn't end there.
I have created a webpage that does exactly what you want, EVE-Profit.com, so unless this Excel sheet is something you do for your own personal joy then I have already taken broker fees and tax into consideration :-)
// Nomad Quento
|
Greagore
|
Posted - 2011.07.19 20:14:00 -
[10]
To make it easier I will expand the persons above example
You buy something for 100isk on a buy order on a your cost is thus:
100 1 =(100*1% broker fee) 101 Total expenses
You then sell it for 200 isk 200 (2) =(200*1% broker fee) (2) =(200*1% sales tax) 194 = Total revenue
So revenue 194 - expense 101 = gross margin 93
|
|
IceFyre S18
Zulu Labs Zulu People
|
Posted - 2011.07.19 21:06:00 -
[11]
Originally by: Nomad Quento
Originally by: Commander Disarray Ok, I've created an Excel sheet with macros to figure out how much I'm profiting (or losing) from trading. I'm using only the Wallet Transactions exported from this site and using macros to format and calculate that data. I can sum up the Buys and Sells to get the gross buys and sells for a given period of time, then subtract buys from sells to get the gross profit. Great, but we know it doesn't end there.
I have created a webpage that does exactly what you want, EVE-Profit.com, so unless this Excel sheet is something you do for your own personal joy then I have already taken broker fees and tax into consideration :-)
// Nomad Quento
That is very good, just set up my account. Why you don't have hundreds of users? --
|
Nomad Quento
Minmatar
|
Posted - 2011.07.19 22:14:00 -
[12]
Originally by: IceFyre S18
Originally by: Nomad Quento I have created a webpage that does exactly what you want, EVE-Profit.com, so unless this Excel sheet is something you do for your own personal joy then I have already taken broker fees and tax into consideration :-)
That is very good, just set up my account. Why you don't have hundreds of users?
It is growing... slowly, but it is growing. BTW - I like your numbers in the statistics - really nice :-)
// Nomad Quento
|
IceFyre S18
Zulu Labs Zulu People
|
Posted - 2011.07.20 10:45:00 -
[13]
I'm sorry hijacking this thread, Nomad can you make statistics public so I can show my E-Peen to everybody?
|
Nomad Quento
Minmatar
|
Posted - 2011.07.20 13:40:00 -
[14]
Originally by: IceFyre S18 I'm sorry hijacking this thread, Nomad can you make statistics public so I can show my E-Peen to everybody?
Replied to you in my EVE-Profit thread.
// Nomad Quento
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |