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