Silly question regarding market fees calculation
By
Bosstone,
Posted on: 2012-01-17 14:56 in The Market and Inventions
I can't remember offhand what the actual percentages are, but as a formula that looks correct, with one exception: You either need a set of parentheses that encompasses both the market cuts:
EARNINGS = SALE_PRICE - ((SALE_PRICE * .1) + (LIST_PRICE * .05))
Or change the + to -:
EARNINGS = SALE_PRICE - (SALE_PRICE * .1) - (LIST_PRICE * .05)
Right now what you have will add the list price cut to your earnings instead of subtracting.
De minimis non curat Lex Luthor.
OP, I don't believe that is quite correct.
My understanding is that Sales Fee is 10% of Sale Price, *but* List Fee is included
as part of that (ie, it's essentially refunded).
So,
Assuming a List Price of 1000 and a Sale Price of 5000, your formula looks like
it would calculate Earnings of 4550 rather than 4500.
Code:
I think the formula you want is: E = SP - (LP * .05) - ((SP *.1) - (LP *.05))List @ 1000 List Fee: 50 (5% of LP) Sell @ 5000 Sale Fee: 500 (10% of SP) - 50 LF = 450 -------------------------------------------------------------- Sale: 5000 Total Fee: 500 Earnings = 4500
Regards,
4
PS> Also keep in mind that there is a minimum listing fee of 5, so Earning
can actually go negative if for instance, you list at 1 and it sells for 1.
(Edit: Re-arranged equation to illustrate "process" flow better.)
I've been rich, and I've been poor. Rich is definitely better.
Light is faster than sound - that's why some people look smart until they speak.
For every seller who leaves the market dirty stinkin' rich,
there's a buyer who leaves the market dirty stinkin' IOed. - Obitus.
Ah, I see where my misunderstanding is. Thank you so much for your help on this!
Main Character: Ice/Storm/Ice Controller (Justice, 1340 badges)
Here's the really simple and correct answer...
E = SP * 0.9
It doesn't really matter what you list something at. The listing fee cancels out of the equation.
E = SP - (LP * .05) - ((SP *.1) - (LP *.05))
E = SP - (LP * .05) - (SP *.1) + (LP *.05)
E = SP - (SP *.1)
E = SP * 0.9
Goodbye and thanks for all the fish.
I've moved on to Diablo 3, TopDoc-1304
Quote:
Yep. That's the practical TL;DR distillation of market fees.|
Originally Posted by TopDoc
E = SP * 0.9
|
I wanted to show more of the actual process that occurs with my formula, in the
sense, that when you list something, the fee is charged and taken right then
and there, and when you actually sell, a further fee is also taken.
But, the end result is a total fee that is 10% of Sales Price, paid in two separate
transaction steps.
Regards,
4
I've been rich, and I've been poor. Rich is definitely better.
Light is faster than sound - that's why some people look smart until they speak.
For every seller who leaves the market dirty stinkin' rich,
there's a buyer who leaves the market dirty stinkin' IOed. - Obitus.
Quote:
Huh. I learned something today.
|
Originally Posted by FourSpeed
My understanding is that Sales Fee is 10% of Sale Price, *but* List Fee is included
as part of that (ie, it's essentially refunded). |
De minimis non curat Lex Luthor.
Quote:
Oh, well, that does make it simple! Thank you!
|
Originally Posted by TopDoc
Here's the really simple and correct answer...
E = SP * 0.9 |
Main Character: Ice/Storm/Ice Controller (Justice, 1340 badges)
Quote:
Yes, and that will work perfectly as long as you sell it. If you list something but remove it from the market without selling it, then your listing fee will not be refunded.
|
Originally Posted by flipside
Oh, well, that does make it simple! Thank you!
|
Avatar: "Cheeky Jack O Lantern" by dimarie
Quote:
I like to be optimistic that I'm selling everything I'm listing. Sometimes that is stupid optimism, but I'd say I'm in the 80/20 rule there. |
Originally Posted by peterpeter
Yes, and that will work perfectly as long as you sell it. If you list something but remove it from the market without selling it, then your listing fee will not be refunded.
|
Main Character: Ice/Storm/Ice Controller (Justice, 1340 badges)
Writing an Excel formula to calculate final earnings based upon an initial list price and projected sale price. The math for the fees seems simple, but I'm not as intelligent as I like to think I am
, so wanted to make sure the math was right. Can someone confirm/deny? Thanks in advance!
EARNINGS = SALE_PRICE - (SALE_PRICE * .1) + (LIST_PRICE * .05)
Main Character: Ice/Storm/Ice Controller (Justice, 1340 badges)