Message:

<p>[QUOTE=&quot;Ken Dorney, post: 3561300, member: 76086&quot;]Attached here is perhaps the most simplistic version one can make.&nbsp; On Column A Line 2 I have entered the amount plus the buyers fee.&nbsp; Line 3 is where you enter your local currency amount you want to bid.&nbsp; Column B Line 2 has the current exchange rate from different currencies (if applicable, otherwise leave it at a value of &quot;1&quot;).&nbsp; Line 3 has the total amount it translates to in the end.&nbsp; </p><p><br /></p><p>I exclude shipping and other fees from this (though one can easily add columns for postage, bank fees, etc) but I always round the numbers up to account for those fees (if a buyers premium is 17.5% I round to 18, exchange is 1.159 it becomes 1.2).</p><p><br /></p><p>Its super easy to use the same formulas to add lines for an infinite number of auction houses.&nbsp; This is how I personally keep track of what I am bidding.</p><p><br /></p><p>And my answer to all the other posts about this topic, I simply bid what I am willing to pay.&nbsp; I dont worry about what others are paying and as long as I have a pretty good idea of the hammer+commission+postage and am happy with the amount, then I bid.</p><p><br /></p><p>Oops!&nbsp; CT does not allow an .xls extension to be attached to a thread.&nbsp; I took a screen shot to show what the formula is that I used in the relevant cel.&nbsp; If you know what that means, that should do it.&nbsp; Otherwise PM me with your e-mail and I can send it that way.</p><p><br /></p><p>[ATTACH=full]946852[/ATTACH][/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in