Percentage Corrections & Estimating Potential Profits

Hello friends,

I'd like to take a quick moment to say "Thank You" to everybody that helped with the Personal Percentages spreadsheet. I've had a chance to catch up on a few things and perform some much needed updates. There is also an additional tab called "ProfitLossCalc", which I'm sure many will all find useful when looking to quickly assess a profit/loss.

New Features:

• Updated drop-down menus to match updated percentages inside of MTGOLibrary
• The ability to preview card costs and calculate potential profits with/out fees
• based on type of license (Pro = 0%, Wiki-Ads = 2.5%, and No Wiki-Ads = 3.5%)
• There is no longer an "N/A" or a "Value/?" in fields where the formula can not calculate a number; instead they will appear blank and update as you enter data
• Ability to calculate profit or loss of trades while considering, if any, above mentioned trade fees

Now, let me say that if you are already familiar with the sheet and just want to get started, you can download the file here.  If you're interested in what's new (aside from above bullets) and/or this will be your first time using the sheet, read on.

Updated Drop-down menus

With the recent updates there have been a lot of great new additions to MTGOLibrary. One such addition, is the ability to select percentage corrections in increments of 1. This makes it easier than ever to set prices for your bot. You can now select increments starting as low as 1 inside of the PrecentageCalculations.xlsm

To Fee or Not to Fee...

There are 2 different modes that MTGOLibrary bots operate in, Pro and Lite. Beneath each of these modes, there are 2 ways one can run a bot. Either by paying a percentage of all transactions or by buying a subscription.

While the 2 operating modes are quite different, the methods of paying for their use are the same. The first way is by purchasing credit. This method of payment is done via a "licensing fee" which is based on a percentage of all your transactions. In this later method, for each transaction the licensing fee is deducted from your purchased credit. This is the method most smaller bots and low transaction bots will choose to run in, making this tab particularly important for them.

Now, depending on whether or not you choose to have the Wiki message displayed to your users at the beginning of a trade, will determine what your licensing rate is. Those that choose not to display the message pay a licensing fee of 3.5% on all transactions. Those folks that choose to display the message pay a licensing fee of 2.5%.

If you're interested in seeing how much a card will truly cost you (the cost in tickets + the licensing fee), you can now view that from the "prices" tab. Everything is as before when it comes to entering the information, except there are 3 more columns on the end. These display your profit with no fee, your profit with a 2.5% fee and your profit with a 3.5% fee.

In an effort to help determine how much one made on the sale for a particular card, there is the "ProfitLossCalc" tab. This tab will take buy/sell price, license percent and a quantity. Given this information, it will calculate if you made a profit or lost money (as seen in below screenshot).

For example, if I enter a price of 28.758 with a license fee of 2.5% and buy a quantity of 3, it will really end up costing me 88.431 total. When I sell those 3 cards at 31 each (with same 2.5%) I will bring in 90.675, a profit of 2.244. 

Care to see how much you could make if you had a subscription to the pro version of your bot? No problem, go ahead and just delete the 2.5% in each of the Buy and Sell Fee boxes. There you go.

Interested in getting started with the new sheet yet? Great! You can download the latest version here.

As always, I'll look forward to your feedback. Email, MTGO, Google Chat, Skype...whatever works for you I'm on them all :)

Cheers,

Jimmi

MTGO: b1nary0mega

The 'b1naryb0t' network

Percentage Correction evaluator II

We have a third update to the tool created by James.
You can download the new excel here.

Many thanks to the creator, James, and the blog readers who suggested and provided new ideas!

Let's keep it improving: feel free to post any idea!

Percentage Correction evaluator

Thanks to James, we have a new tool to evaluate the percentage corrections that best fit your bot.

The excel spreesheet is useful when trying to determine what percentage corrections work for your bot. Trying to find the settings that maximize the income and make the bot productive is not an easy task.... this helps a bit!

Many thanks again!

UPDATE: we updated the spreesheet

Directly quoting James, the creator:

There are 2 tabs in the workbook folks can choose from, they are "Settings" and "Prices". 

The "Settings" tab will allow people to see how different percentage settings within the bot will interact with the PersonalPercentages.txt file and show them the final result. 

The "Prices" tab is similar to the old file, in that it will allow folks to see what they are going to be selling and/or buying a card for. This sheet really is to be used for testing buying and selling prices when first setting up a bot. 

There are 2 other sheets, but they do not perform any calculations. The first of them is "Corrections" and this sheet is basically a calculation of the percentages and provides the matrix for which the first 2 sheets derive their final correction result. The second sheet, called "About" is just a quick thanks to folks for their feedback and how they can get in touch.

Modding MTGO; Custom Game Mats

If you’re a big fan of MTGO like me, you’re probably pretty disappointed with the lack luster game mats they give you with your profile. While you can change the game mat in your personal settings, you can't upload a custom image. That said there is a way to overwrite the current background files yourself.

Most of the assets in the current version of MTGO are .PNG files. The game mat .PNG files are located in the directory where you installed MTGO like this;

..\Magic Online\Graphics\UI\backgrounds\gamemat\

You can then overwrite those image files with ones of your own. Sometimes the kicker overwrites these images with the defaults again so make sure you keep a backup ready just in case. I run MTGO without the kicker as it’s faster and Wizards publishes updates on Wednesdays.


Each image is 512 x 256 so you will have to use an image editor program like Photoshop or GIMP to manipulate it. I really like the free wallpapers that Wizards give us every week so I usually edit one of those and overwrite it into the folder, Because the dimensions are so wide, but not very tall, I suggest resizing the image to 512 width, but leave the aspect ratio of the current image the same. Then use the Crop tool to edit the height to 256 height.

Sometimes the game mat doesn’t show the edges very well so try to make your image centered as much as possible. I’ve attached a replacement for the default Green Felt_e.png using this weeks MTGO wallpaper, Rune-Scarred Demon for you to try out.