Showing posts with label bookkeeping. Show all posts
Showing posts with label bookkeeping. Show all posts

Wednesday, August 14, 2013

Remote Control of the ML Bot





We host a series of articles from our friends blog http://www.mtgeconomist.com , a blog dealing with mtg and mtgo economics.

You can read the original article here: 
http://www.mtgeconomist.com/en/mtgo-library-control-remoto-del-bot-parte-6-3/


Previously we took a look at all the settings of the bot. The main problem is that you have to be in front of the computer which is running the bot in order to make any changes in their behavior. To solve it, in this article I will explain how to view the status of your robot, statistics from sales/purchases and even how to make a remote control of the bot.




Control panel on the web

MTGO Library provides an additional service to the software that controls our digital cards store. This control panel can be accessed through our session on the bot website. Upon entering, you will see a page like the capture below.


This section is the “Dashboard” or main desktop where you can access to all available information remotely. As you can see there are 3 different areas:
  • Top menu: Access to all bot updates and its price list, as well as the renewal of the licenses (Lite and Pro). 
  • Side menu: Mainly displays performance statistics of the bot, however you can also make some changes from here. These options will be discussed in a future chapter because it is more related to strategies when creating your own chain of bots. 
  • Main section: Here it is shown the corresponding section selected from one of the previously commented menus. 
Within the left side menu options, firstly there is a series of display options with both, bot information and statistical data:


  • Dashboard: Displays a screen capture with the operating system of the bot. Below it is a bar with connection status of that computer. On the right side you can see a summary of the following information from bot: bot status (online/offline and if it is with a customer); status of the Magic Online client (online/offline); 
  • Transaction fee or commission due to the bot transactions; date and type of the last transaction; license type (Free/Lite/Pro) and expiration date; and the total value of the collection managed by the bot.
  • Trades log: on ​​top of this page there are diagrams with the latest sales statistics representing the total value of trades, number of trades of the most frequent customers, percentage of buyings against sales… Afterwards, there is an advanced search engine transaction, and below there is a list of the transactions for the last 24 hours. In the summary of each transaction you can see its mode (buy/sell/trade), total value, customer name and its date. If you want to see the details, you just have to click on the bar of the transaction to see the following information: 
    • List of cards exchanged with their individual price 
    • Total value and the value without the customer accumulated credit 
    • Tickets received 
    • Previous and current customer credits 
    • Tickets available on the store after this transaction 
    • Fee generated by this transaction 
    • Total fees after this transaction (debit to MTGO Library) 
    • Links to screenshots generated just when the bot confirms the transaction
  • Cards Log: This section is very useful when you want to track the benefits of a specific card. After searching a card, this section shows all its buys and sales with their values attached. The site also summarizes the profit or loss made by this card. Thus, by using this information you can decide, for example, to change the prices of a particular card. 
  • Collection History: Summary of the total value of your collection divided by rarity. It is updated every 24/48 hours and, although it is useful to get an idea of ​the value for your stock, often these data are not very accurate. For example, there are some days that I have had almost no sales and my collection changed its value around +-200 tickets. 
  • Transaction Fee: List with each renting fee generated and deducted by one of the official MTGO Library accounts. These accounts remove fees by taking tickets from your store every time its the renting fee exceeds the value of 1 ticket. 
  • Multimonitor: Current screenshot from each of your bots. It also shows their online status and the commission generated by each one independently. Remember that for every bot you have to pay the fees generated by their respective transactions.
Below these statistics options there are some sections which modify the data the bot works with:
  • Credits: Displays the available credits for each client who has done transactions in your store. Each customer on the list offers an option to show all his transactions, as well as the possibility to edit their credits for any reason. 
  • Messages: Allows you to change the text of the advertisement shown in the “classifieds” section on Magic Online. This option is very useful if you want to remotely change your advertising. Changes are made every hour, so it may take you a bit to see the update of your advertisement. 
  • Sharing Credits: If you have more than one bot, from here you can make to share the credit between themselves. This means that a customer will have available the same credits in your entire chain of bots. 
  • Blacklist: Finally, your session on MTGO Library website allows you to add users to a blacklist. Thus, a client on the blacklist cannot trade cards with your bots. You must be very sure to add someone here, and you should only do this if that customer has persistently abused from your stores. This explanation covers all the options you can handle from MTGO Library site to control your stores without being in front of the computer which runs the bots.

How to make a remote access to your bot

As you can see, although the control panel of MTGO Library website has many functions, it may happen that you wish to directly manage any of your bots for pausing, restarting, changing the custom price of a card… There are many methods to solve this problem, however I will explain in detail the one I use: LogMeIn.


Why I use this service? There are many reasons, but the most important are:
  • Its basic version is offered for free 
  • Very fast and easy-to-use interface 
  • Easily manages a lot of computers from a single place. It may be used from different platforms (PC Windows, Mac, iPhone and iPad) 
The last point is very important for me, as it allows the remote control of the bot from your phone when you are far from home (obviously you should have an internet connection).
The steps to start using LogMeIn on the computer you install your bot are the following:
  1. Create an account at LogMeIn
  2. Login to your account on their website and, from the “Home” section, select “add computer” 
  3. Download their application (Free version) and install it on the computer which runs the bot. It will ask you the computer name and if you use a proxy for your connection. 
  4. That’s it! In order to use the remote control of your bot, go again to your “Home” section and you will see your computer on the list. Click over it and type the username and password of the user of that computer. 

Conclusions

With these tools you have a complete remote control system for your bot, so you can manage its behavior at any time. This feature is very important because sometimes you have to fix prices of cards, pause the bot, perform maintenance tasks, know the sales/purchases of your store…

The next chapter of this series will show you some of the most common strategies to create your own chain of bots.

Tuesday, April 16, 2013

Profits! How to calculate them.

Hello Fellow Botters,


Today I will talk about calculating profits. Everyday, about 3 times a day I get and email, Pm, or Skype message asking me "how do you calculate profits"? I have been thinking about it for sometime now and I came up with a way to figure this out by combing a few tools already available to us.

Before we get started you will need to download MTGO Tool that was created by Sebastian B. a few months back. You can download that (Click here). Next you will need to download and excel file calculator that I created you can down load that (Click here).

This profit calculator takes into account price fluctuations and it will give you a total profit dollar amount for your chains (up to 6 bots per chain)

Ok so lets get started:

Step 1:  Download your CSV file from your Magic Online bot account.
Go to collection -----> Select all -----> Right click and export.

Step 2:  Open the MTGO Tool (Run in administrator)
Load your current CardsMTGO3 file and load your CSV file you download in step 1.
You will use the results of this in step 3.

Step 3: Input data into ProfitCalc.xls
Use the chart below to help you.


A). Input data from your Csv file using the MTGO Tool (step 2) week 1
B). Put any price corrections you use with your bots
C). Input data from your Csv file using the MTGO Tool (step 2) week 2
D). Put any price corrections you use with your bots.
E). Total profit between week 1 and week 2 ( keep in mind it might not all be in actual tickets, some could be in collection growth)
F). Input the (+/-) difference from base amount of tickets in the bot/chain. What I mean by this, each bot should have a base amount of tickets that you want on it at all times, for instance you might want 500 actual tickets on there at all times, 500 would be your base. So if you go to your bot during this profit calculation and 550 tickets are on there then you would insert 50 in this field and take 50 tickets from your bot. So basically reset your bot to your base ticket amount and insert the difference here.

You can do this once a day, once a week, once a month, or once a year, just keep in mind you need the beginning information and the end information for what ever your duration you choose.


This takes about 10 minutes to complete with a single bot or 30 minutes for 5 bots. I made a calculator for single bots and for chains up to 6 bots.


I hope this helps everyone.

Have any questions email me: jason@mtgolibrary.com
Skype: mtgolibrary.support
Mtgo handle: teamstoge



Wednesday, February 13, 2013

MTGO Tool 0.0.12 released

To those who missed the last post about this. I'm creating a MTGO Tool for ML Bot users mainly. Because at the moment you need your "CardsMTGO3.txt" pricelist file from ML Bot to actually use the software.In the future I will probably make it possible to be used without pricing aswell.

At the moment the tool is still in beta since I have only been working on it the past week.

The tool can be downloaded from here. Also the changelog is available here. To run it you need to have an active internet connection. Why do you need an internet connection to run it?
On startup I connect to my server validating that the beta is still active. This is because in the future I want to have the possibility to inactivate the beta versions.


Changelog 2013-02-13 - v0.0.12 (Full changelog avaiable inside installer and here)
-New features
     -Possibility to load unlimited .csv files from external .txt file. Check myCollections.txt for details how to.
     -Added setting to select to load all cards or just cards marked for trade.
     -Added a ticket count to the overview tab. Ticket value is not included in collection value.
-Notes:
     -Due to some setup changes the new version is 0.0.12 instead of 0.12.

If you have installed this program previously you will have to uninstall the previous version and then install this.


Features planned for next release:
-Collection comparision.

Got any suggestions for user input parameters for such a feature? Send me an email! Also suggestions for how the output should look like would  be nice.


If you have any questions, suggestions or bug reports, send me an email at mtgoswebot@gmail.com.
As I'm currently doing this for free, donations are more then welcome in all forms, cards, tickets, paypal and even just a bit of feedback would be nice. And you will get your MTGO name listed in the donors menu. (I have not created this yet). Don't forget to check comments for further details!

Regards,
Sebastian

Wednesday, October 31, 2012

New Sets

I’ve been going through some life changes recently so when Return to Ravnica (RTR) came out, all I was able to do is to have the bots grab RTR cards and get back to trying to adapt to the other more important things going on around me.

About a week ago, things calmed down a bit and I decided to check on my bots to see what has happened since RTR was released.  Imagine my shock when I saw that not one RTR card had entered my bot empire.

This got me thinking of an experiment: What would happen if I bought a bunch of boosters, opened them up and immediately placed them on the bot?  Obviously the prices would reflect this strategy and few bots would even have cards from a new set. 

So, let’s go through the numbers: There are 101 commons, 80 uncommons, and 68 rares and mythics in RTR.  There are also 10 commons, 3 uncommons and 1 rare or mythic in each booster.  For the sake of arguments, let’s assume a perfect distribution.  The point of this exercise is to get a ballpark figure to see if this strategy is indeed viable, not a mathematical proof.

For our purposes, let’s assume we desire a playset, four (4) copies of each card, for each rarity.

101 commons * 4 = 404 cards divided by 10 per booster pack means we’d need 41 booster packs, at $4 each gives us $164 needed to obtain a playset of commons. 

80 uncommons * 4 = 320 cards divided by 3 per booster = 107 boosters *$4 = $428 for a playset of uncommons.

68 rares * 4 = 272 cards, or boosters, as there is only one per pack, costing $1,088.

So, in order to break even, each rare or mythic would have to cost 4 tickets.  (1,088/272)

Uncommons would have to cost $428/320 or 1.34 tickets each.

Commons would have to be prices at $164/404 or .41 each.  (5 cards for 2 tickets).

As we can see, these prices are not sustainable.  Throw in the renting fee for the bot, in addition to fact that there are always undesirable cards and reprints which will never sell for the break even price and it is not difficult to see why bots do not use this approach.


Tuesday, September 13, 2011

When to Cash Out (Part 7)

Last time I discussed my attempts at writing my own MTGO bot and the difficulties which lie therein and how my failure to plan for the contingency of YATBot 3 not being created cost me profits while my inventory gathered virtual dust.

After I had given up my pursuit of writing my own bot, I began to ponder what to do next. Did I want to sell off my inventory and walk away, or did I want to seek out another bot?

This decision was fairly an easy one to make. EBay was being inundated with collection auctions and some auctions were pretty much being given away. Since this created a massive glut, I knew that my collection would not bring fair market value and holding onto the collection would not help matters any. If anything, this was the perfect time to gobble up all this inventory but I had no plans or available monies to take advantage of this fact. So the search began for a replacement bot and slightly lamented over this missed opportunity.

I came upon MTGO Library and have been pleased ever since. It had all of YATBot's features and so much more. I could even run one bot and have MTGO Library handle all the cards, so I began the process of transferring all the inventory to a single account.

I also began to conceive of a way to measure the effectiveness of MTGO Library. Under YATBot, I had a spreadsheet which showed the number of trades and the number of cards traded were tracked. I let my wife handle this bookkeeping details and once a week I looked at the progress. I could tell you how many cards in profit each of the bots were bringing in. Obviously the commons would give me more cards than rares, but beyond that, it was difficult to explain to non MTGO people what my profit margin was, how much money the bots were making on paper and even more importantly, how much cash in hand I was actually receiving.

We'll get into how MTGO Library solved this problem next time.