Saturday, February 2, 2013

ML Bot Correction + Personal Percentages

Setting up Personal Percentages

Hi everyone, I've had a few emails asking me about the corrections and personalpercentages interactions so I've decided to make this table to make it all easier for whoever might be thinking of having different prices for specific sets.

I used Personal Percentages to allow my main bot buying/selling standard sets with a strong positive correction without affecting my "lower" classic corrections (which are harder to sell).

If you're having difficulties with what will the "final percentage" be after setting both corrections this table will help!

 (click to zoom)


For example if you have your bot set to buy all regular rares for -30% and wish to buy Return to Ravnica regular rares at about +10% above cardsmtgo3 pricelist, then you need to set it on personal percentages as +55% or +60% resulting in +9% or +12% respectively.
( RTR;RARE;+0%;+0%;+55%;+0% )

Be aware that having ML Bot at +80% and set personal percentages at +80% will result in buying at 224% above pricelist (more than triple the value on pricelist)

Hope it helps. Please comment if you have any questions or need assistance.
a

11 comments:

  1. AlbertFebruary 2, 2013 at 9:06 AM

    Superb work!! !!

    ReplyDelete
  2. x4dowFebruary 2, 2013 at 9:16 AM

    been doing a lot of commenting and few of my own posts, so I've decided that my next one had to be something actually useful :).

    ReplyDelete
  3. AlbertFebruary 2, 2013 at 9:29 AM

    The table you made is absolutely useful :) I guess you spent lot of time

    ReplyDelete
  4. x4dowFebruary 2, 2013 at 10:03 AM

    first half of it i made on calculator (1.8x1.8) 1.8x1.75 etc. then I've figured out a way to do it with formulas (excel)

    =((1+C34)*(1+$D$6))-1 and drag right. repeat repeat repeat :P

    ReplyDelete
  5. AlbertFebruary 2, 2013 at 11:14 AM

    And the colors? Formula too?

    ReplyDelete
  6. AlbertFebruary 2, 2013 at 11:14 AM

    And the colors? Formula too?

    ReplyDelete
  7. x4dowFebruary 2, 2013 at 11:48 AM

    i will email you the Excel doc.

    ReplyDelete
  8. x4dowFebruary 2, 2013 at 11:50 AM

    colors were manually, but thats quick to do

    ReplyDelete
    Replies
    1. UnknownMarch 5, 2013 at 6:45 PM

      Thanks for this x4dow. Recreated for use with my bot calculation file. I'm sure you've already found it (especially since you've already finished), but there is a way to automatically do coloring as well. It's called "Conditional Formatting" and can color all the selected cells for you quickly and easily based on a multitude of criteria.

      Delete
  9. AlbertFebruary 2, 2013 at 3:22 PM

    Recevied. Thanks, much appreciated

    ReplyDelete
  10. Darksteel ShamanMay 12, 2013 at 7:19 PM

    Very helpful.

    ReplyDelete