Joe's Trading Post
  • Home
  • Abandoned Travels
    • Abandonments >
      • 2014-2015 >
        • Mayo Urbex
        • Howey Mansion
        • Uncle James Farmhouse
        • Coffee Farmhouse 01
        • Barber Homestead
        • Fallout Shelter
      • 2013 >
        • CMX Construction
        • Orange House 01
        • Fertilizer Plant
        • Egg Plant
        • Box Plant
        • Ellaville Bridge Revisited
        • Gold Kist Farms Silos
        • Lafayette House 03
        • Columbia House 01
        • Columbia Barn 01
        • Cash's Towing
        • Coastal Revisited
        • Suwannee Shack
        • Hernando House 01
        • Lafayette House 02
        • Lafayette House 01 Revisited
        • Lafayette Chimney Revisited
        • Lafayette Quarry Revisited
        • Williston Urbex
        • Elljay Garage
      • 2012 >
        • Suwannee Barn 01
        • Coastal Service Center
        • Lafayette Quarry
        • Lafayette Chimney
        • Lafayette House 01
        • Lafayette Trailer 01
        • Ellaville
        • Gilcrest House 01
        • Georgia Quarry
        • Family Farmhouse
      • 2010-2011 >
        • Citrus Shack
        • Citrus House 01
        • Georgia House 01
        • Bahia Honda
    • Travels >
      • Italia >
        • Venezia
        • Firenze
        • Amalfi Coast
        • Roma (Coming Eventually)
      • France >
        • Catedral de Notre Dame
      • Cuba
      • United States >
        • Key Largo
        • Smoky Mountains
        • Jasper
        • Shenandoah National Park
        • Colorado 01
        • Colorado 02
        • High Shoals Falls
    • Nature >
      • Super Wolf Blood Moon
    • Water >
      • Blue Heron Bridge 04
      • Blue Heron Bridge 03
      • Ginnie Springs 02
      • Ginnie Springs 01
      • Ginnie Springs 03
      • Blue Heron Bridge 02
      • Blue Heron Bridge 01
  • Games
    • MTG Arena >
      • Arena Sleeve Gallery >
        • Arena Sleeve Gallery Home
        • Arena Sleeve Gallery 2023
        • Arena Sleeve Gallery 2022
        • Arena Sleeve Gallery 2021
        • Arena Sleeve Gallery 2020
        • Arena Sleeve Gallery 2019
        • Arena Sleeve Gallery 2017/2018
      • Arena Sleeve Quick Gallery
      • MTG Arena
      • My Arena Gameplay Data
    • Magic: The Gathering
    • Star Wars: Destiny
    • Diablo Immortal
    • Fallout 76
  • Food
    • Recipes
    • Energy Drinks
  • VATS Sucks
    • VATS Sucks Welcome
    • My Story
    • Troubleshooting Steps
    • VATS Help >
      • 1984-1985
      • 1986-1989 >
        • Passkey Ignition Switch
        • Start Enable Relay
        • VATS Cranking Fuel Enable Signal
        • Schematics
      • 1990 >
        • Start Enable Relay
        • VATS Fuel Enable Signal to ECM
        • Schematics
      • 1991 >
        • Schematics
      • 1992 >
        • Info
        • Schematics
      • 1993 >
        • Info
        • Schematics
      • 1994-1996
      • ZR1
  • Stuff
    • Cars
    • Budget Finds
    • News/Updates
    • Blahg
  • About

Blahg

MTG Arena Collection Real World Value ( Just for Fun!)

10/2/2019

3 Comments

 
Picture
Many players think that virtual game items have no real world value. And they're absolutely right!

The value you get from your purchased virtual items are strictly to let you enjoy the game more, be it changing the way something looks, using a more powerful item, or simply for bragging rights. That virtual item you bought brought you some kind of joy.

However, what if there was a way that you could parallel your virtual items with real world items to find a real world value?

After all, you most likely did spend real money on Magic: The Gathering Arena. Even if you did not, you can look at it as if someone gave you a large collection for free, just for playing.

Since there actually is a direct comparison to a real world product in this virtual game environment, then this makes it easy to calculate what your in game virtual items are virtually worth.

If you have not yet read my previous article on Throne of Eldraine Season Rewards and Real World Value, then check out that article HERE

While that article goes very in depth on how values are calculated, fortunately you won't need to do any math at all to figure your collection value out. All that is needed is an Arena tracker to export your collection, a quick cleanup of the data, and then you can import it into another collection system to give you the values.

Let's get started!

TL:DR version

  1. Use a tracker that has a collection manager and that can export your collection to a file
  2. Cleanup your output file so it's just 2 columns, Quantity on the left, Card name on the right. Save as a TXT file.
  3. Fix TXT file so each row is "Number [space] CardName", make sure there's no tabs or commas between them.
  4. Import into EchoMTG's deck list feature. It will make one huge deck and display the total value.

Getting Started

This is not difficult if you are somewhat computer savvy, but if you are not very technical, you may want to skip this project.

I am in no way sponsored or paid by any of the companies whose products I will be referring you to. I simply use them myself.

Things you will need:
  • MTG Arena installed with an already established account
  • Tracker that can export your entire collection. I use MTGArena.Pro
    • A comparison of others can be found HERE
  • Something to edit a spreadsheet with, I use Google Sheets in this example.
  • Notepad, or other simple text editor
  • EchoMTG Account, make sure you can log into the website (Free account)

Installing a Tracker

There are many trackers available for Arena.

You can find a quick table of features of the various trackers HERE to choose which one you want. Just make sure it includes a Collection Tracker and/or Browser.

I use MTGArena.PRO. It's the most powerful one of all the trackers I've tested.

For a full write-up of how to install MTGArena.Pro, click HERE (COMING SOON)

Make sure that your tracker has synced itself with its website counterpart. To check this, log into the website for your tracker and check your card collection inventory to make sure everything is showing up correctly.

Exporting your Collection

Once your MTGArena.Pro client has synced itself, then you may now log into the website.
Their site is located here: https://mtgarena.promtgarena.pro

Once you log in:
  • At the top of the site, click on My Arena --> Collection
Picture
Select My Arena--> Collection
  • At the top of the Collection Manager, select the field that says Display and change it to Owned.
  • Next, look on the top right of the collection manager and click on the little circular icon with the little down arrow in it. This will expand the search and filtering features of the Collection Manager
  • Next, click on the Export button
Picture
Change Display to Owned; Click the menu expansion, Click Export
An Export window will pop up, asking you to select a format to download to.
  • Click on MTGGoldfish CSV
A window will pop up asking to open or save the file.
  • You can either save it or go ahead and open it with a spreadsheet application.
It should have opened and/or saved as the file name "collection.csv"
Picture
Click on MTGGoldfish CSV

Cleaning up the Data

Before we can import this into another system for pricing, we will need to clean up the data first. You may be asking, "But why can't I just import this into MTGGoldfish?". It is because MTGGoldfish will not let you bulk import a collection unless you pay for a premium membership. Since we want to find this out for free, we will be using another system.

  • Open the collection.csv file in your favorite spreadsheet application. For the purposes of being free, I will be using Google Sheets as an example. You are free to use Excel, Libra Office or any other spreadsheet software.

Once the file is opened, we can see what MTGArena.Pro exported.

You should see a spreadsheet with a few columns, such as the card name, the set it is from and the quantity.
Picture

The only two columns we are concerned with are Card and Quantity.
  • Delete the other columns.
  • Next, you need to move the quantity column in front of the card column.
  • Next, you can delete the header row that says Quantity and Card.
You should just be left with two columns, one with numbers and the other with the card names.
Picture
If you wish to sort alphabetically and remove all the basic lands, you can. You may also remove the lands later after importing it into the pricing website.
  • Once completed, save this as a CSV file (Comma Separated Values).
  • Let us call it "collection.csv"
Picture

We have one more cleanup step to perform.
Open collections.csv in a simple text editor, such as Notepad.

You will something like this:
Picture
Note the commas between the card names. We need to remove all of these commas using the Replace tool in Notepad.
Picture
  • Click Edit--> Replace
The Replace window should open up.
  • In the Find What field, type in a single comma
  • In the Replace With field, type in a single space (just hit the space bar once)
  • Then click the Replace All button
Your file should now look like this:
Picture
  • Save this file as "collection.txt" and close it.

Now we need to log into EchoMTG.
EchoMTG is a collection tracker for the physical MTG card-collecting world. It tracks and bases all of its values on TCGPlayer.

Here is the address for EchoMTG: https://www.echomtg.com


The free version only allows you to import 350 cards into its collection database. But there is a cool feature called Lists/Decks that allow for unlimited cards, without adding them to your collection. This will also show you the value of this list/deck.

  • On EchoMTG, on the left hand menu, click on Lists/Desks
Picture
Give your List/Deck a name in the field above
Click on the Select File button, then find where you saved your collection.txt file

Picture
  • Click on the Create New List button
You should see a list of card names scrolling quickly by on the right hand side of the screen. This could take a minute or two depending on your internet connection and how large your collection is. Once completed, the scrolling will stop.
Picture
You can now click on your newly created list. Give it a few seconds for the card names to populate. Remember, there is probably 1000's of cards in here.
Picture
As you can see from the image above, as of this writing, my MTG Arena virtual collection is worth virtually somewhere between $1,369-$2,576.

Remove Basic Lands

Due to the basic lands being imported, it automatically selected some of the vintage lands, which, in total, added about 150 cards to my list, totaling about $75 in value. Therefore, I would also just subtract this from whatever final value I came up with. Basic lands in Standard have little to no value. You could add in each land you have, but it is just not worth the effort.

You could remove the basic lands from the spreadsheet earlier in the process, or once imported into EchoMTG, you can slowly click the - (minus sign) next to each of the 5 basic lands and remove them all. It all depends how tech savvy you are.

The easier option is to just mouse over each of the basic lands and see what their value is. Looking at my example image below, you can see that it EchoMTG chose to import a Fifth Edition basic Island, which is worth quite a bit more than any basic land in Standard.

For this example, multiply $.79 x 31 cards = $24.49 and subtract that from your total value.

Do this for each of the other basic lands as well.
Picture
Speaking of lands, if you have the full art basic lands for Unhinged or Zendikar,those are worth roughly $1 on average in the real world.

Figure you probably bought 24 of each of them in real life, 24 of each full art basic lands (120 cards total) is worth another $60-$120. Double this if you have both sets.

In Conclusion

Pricing for EchoMTG is pulled from TCGPlayer. The values shown are between lowest market value and the average market value. Lowest value typically lists damaged or high play cards as well, so this may not be entirely accurate for near mint cards. Keep in mind the Average price includes those that have listings that are multiple times more than a card is worth, which can skew that number as well. You should probably just take the average of the two values for a more real world representation of what your collection is worth.

This pricing does not take your card styles into account either. Since the card styles are essentially "foils" in Arena, you can value them in this manner. Though, they now look like the extended art cards from Throne of Eldraine, so this would signifigantly increase the value over a foil.

I hope you enjoyed this article. It was certainly fun to research and write! If you would like to see more articles such as this, please leave me a comment or contact me with more ideas.
3 Comments
MckinneyVia link
4/7/2022 09:01:14 am

Excellent article! Your post is essential today. Thanks for sharing, by the way.

Reply
Joel Swan link
6/9/2022 05:46:56 am

Great Article! Thank you for sharing this is very informative post, and looking forward to the latest one. If you're looking for a money-making app, download this link https://bit.ly/3MSDRA9

Reply
Sherry Mello link
6/9/2022 05:48:14 am

Nice article! Thanks for sharing this informative post. Keep posting!
Visit link: https://hobigames.app/

Reply



Leave a Reply.

    Categories

    All
    Biking
    Budget
    Diablo Immortal
    Energy Drinks
    Fallout 76
    Food
    Free Games
    MTG
    MTG Arena
    PC
    Tabletop Provisions

    Archives

    August 2022
    February 2022
    August 2021
    June 2021
    April 2021
    March 2021
    February 2021
    January 2021
    September 2020
    August 2020
    July 2020
    June 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    June 2019
    May 2019
    April 2019

    RSS Feed

Copyright 2022
  • Home
  • Abandoned Travels
    • Abandonments >
      • 2014-2015 >
        • Mayo Urbex
        • Howey Mansion
        • Uncle James Farmhouse
        • Coffee Farmhouse 01
        • Barber Homestead
        • Fallout Shelter
      • 2013 >
        • CMX Construction
        • Orange House 01
        • Fertilizer Plant
        • Egg Plant
        • Box Plant
        • Ellaville Bridge Revisited
        • Gold Kist Farms Silos
        • Lafayette House 03
        • Columbia House 01
        • Columbia Barn 01
        • Cash's Towing
        • Coastal Revisited
        • Suwannee Shack
        • Hernando House 01
        • Lafayette House 02
        • Lafayette House 01 Revisited
        • Lafayette Chimney Revisited
        • Lafayette Quarry Revisited
        • Williston Urbex
        • Elljay Garage
      • 2012 >
        • Suwannee Barn 01
        • Coastal Service Center
        • Lafayette Quarry
        • Lafayette Chimney
        • Lafayette House 01
        • Lafayette Trailer 01
        • Ellaville
        • Gilcrest House 01
        • Georgia Quarry
        • Family Farmhouse
      • 2010-2011 >
        • Citrus Shack
        • Citrus House 01
        • Georgia House 01
        • Bahia Honda
    • Travels >
      • Italia >
        • Venezia
        • Firenze
        • Amalfi Coast
        • Roma (Coming Eventually)
      • France >
        • Catedral de Notre Dame
      • Cuba
      • United States >
        • Key Largo
        • Smoky Mountains
        • Jasper
        • Shenandoah National Park
        • Colorado 01
        • Colorado 02
        • High Shoals Falls
    • Nature >
      • Super Wolf Blood Moon
    • Water >
      • Blue Heron Bridge 04
      • Blue Heron Bridge 03
      • Ginnie Springs 02
      • Ginnie Springs 01
      • Ginnie Springs 03
      • Blue Heron Bridge 02
      • Blue Heron Bridge 01
  • Games
    • MTG Arena >
      • Arena Sleeve Gallery >
        • Arena Sleeve Gallery Home
        • Arena Sleeve Gallery 2023
        • Arena Sleeve Gallery 2022
        • Arena Sleeve Gallery 2021
        • Arena Sleeve Gallery 2020
        • Arena Sleeve Gallery 2019
        • Arena Sleeve Gallery 2017/2018
      • Arena Sleeve Quick Gallery
      • MTG Arena
      • My Arena Gameplay Data
    • Magic: The Gathering
    • Star Wars: Destiny
    • Diablo Immortal
    • Fallout 76
  • Food
    • Recipes
    • Energy Drinks
  • VATS Sucks
    • VATS Sucks Welcome
    • My Story
    • Troubleshooting Steps
    • VATS Help >
      • 1984-1985
      • 1986-1989 >
        • Passkey Ignition Switch
        • Start Enable Relay
        • VATS Cranking Fuel Enable Signal
        • Schematics
      • 1990 >
        • Start Enable Relay
        • VATS Fuel Enable Signal to ECM
        • Schematics
      • 1991 >
        • Schematics
      • 1992 >
        • Info
        • Schematics
      • 1993 >
        • Info
        • Schematics
      • 1994-1996
      • ZR1
  • Stuff
    • Cars
    • Budget Finds
    • News/Updates
    • Blahg
  • About