1 Reply by StoneValley

(786 replies, posted in Site Discussion)

Hello there! Here's the cards missing prices from my current list. I've added links to pricing. Once these are added it will save me a considerable amount of time looking for them!

Name    Edition    Card Number    Condition    Language    Foil
Angel // Elemental    Extras: Commander 2020    20    Near Mint    English    https://www.tcgplayer.com/product/21441 … ge=English

Bird // Dinosaur Cat    Extras: Commander 2020    21    Near Mint    English    https://www.tcgplayer.com/product/21441 … ge=English

Drake // Goblin Warrior    Extras: Commander 2020    27    Near Mint    English    https://www.tcgplayer.com/product/21455 … ge=English

Elemental // Kraken    Extras: Commander 2020    33    Near Mint    English    https://www.tcgplayer.com/product/21456 … ge=English

Human Soldier // Zombie    Extras: Commander 2020    30    Near Mint    English    https://www.tcgplayer.com/product/21456 … ge=English

Hydra // Beast    Extras: Commander 2020    34    Near Mint    English    https://www.tcgplayer.com/product/21441 … ge=English

Punch Card Token    Extras: Commander 2020    37    Near Mint    English    https://www.tcgplayer.com/product/21457 … ge=English

Snake // Beast    Extras: Commander 2020    36    Near Mint    English    https://www.tcgplayer.com/product/21456 … ge=English

Spirit // Insect    Extras: Commander 2020    24    Near Mint    English    https://www.tcgplayer.com/product/21456 … ge=English

Beast // Fish    Extras: Commander 2021    16    Near Mint    English    https://www.tcgplayer.com/product/23705 … ge=English

Beast // Insect    Extras: Commander 2021    19    Near Mint    English    https://www.tcgplayer.com/product/23706 … ge=English

Beast // Whale    Extras: Commander 2021    17    Near Mint    English    https://www.tcgplayer.com/product/23705 … ge=English

Copy // Construct    Extras: Commander 2021    11    Near Mint    English    https://www.tcgplayer.com/product/23704 … ge=English

Demon // Fungus Beast    Extras: Commander 2021    9    Near Mint    English    https://www.tcgplayer.com/product/23703 … ge=English

Drake // Elemental    Extras: Commander 2021    4    Near Mint    English    https://www.tcgplayer.com/product/23702 … ge=English

Eldrazi // Champion of Wits    Extras: Commander 2021    22    Near Mint    English    https://www.tcgplayer.com/product/23706 … ge=English

Elemental // Copy    Extras: Commander 2021    6    Near Mint    English    https://www.tcgplayer.com/product/23702 … ge=English

Fractal // Copy    Extras: Commander 2021    15    Near Mint    English    https://www.tcgplayer.com/product/23705 … ge=English

Frog Lizard // Elephant    Extras: Commander 2021    21    Near Mint    English    https://www.tcgplayer.com/product/23706 … ge=English

Horror // Zombie    Extras: Commander 2021    3    Near Mint    English    https://www.tcgplayer.com/product/23702 … ge=English

Hydra // Boar    Extras: Commander 2021    20    Near Mint    English    https://www.tcgplayer.com/product/23706 … ge=English

Myr // Treasure    Extras: Commander 2021    10    Near Mint    English    https://www.tcgplayer.com/product/23704 … ge=English

Pest // Food    Extras: Commander 2021    7    Near Mint    English    https://www.tcgplayer.com/product/23703 … ge=English

Saproling // Food    Extras: Commander 2021    8    Near Mint    English    https://www.tcgplayer.com/product/23703 … ge=English

Spirit // Zombie    Extras: Commander 2021    2    Near Mint    English    https://www.tcgplayer.com/product/23702 … ge=English

Thopter // Golem    Extras: Commander 2021    12 ((NOTE: This should be Card # 25))    Near Mint    English    https://www.tcgplayer.com/product/23704 … ge=English

Thopter // Golem    Extras: Commander 2021    13 ((NOTE: This should be Card # 26))    Near Mint    English    https://www.tcgplayer.com/product/23705 … ge=English

Thopter // Golem    Extras: Commander 2021    14 ((NOTE: This should be Card # 27))    Near Mint    English    https://www.tcgplayer.com/product/23705 … ge=English

Treasure // Construct    Extras: Commander 2021    5    Near Mint    English    https://www.tcgplayer.com/product/23702 … ge=English

Wurm // Kraken    Extras: Commander 2021    18    Near Mint    English    https://www.tcgplayer.com/product/23706 … ge=English

Cat    Extras: Core Set 2021    11    Near Mint    English    https://www.tcgplayer.com/product/21669 … FMd193Y0I.

Knight    Extras: Dominaria    1    Near Mint    English    https://www.tcgplayer.com/product/16475 … FMd193Y0I.

Knight    Extras: Dominaria    2    Near Mint    English    https://www.tcgplayer.com/product/16475 … FMd193Y0I.

Saproling    Extras: Dominaria    11    Near Mint    English    https://www.tcgplayer.com/product/16476 … FMd193Y0I.

Saproling    Extras: Dominaria    12    Near Mint    English    https://www.tcgplayer.com/product/16476 … FMd193Y0I.

Saproling    Extras: Dominaria    13    Near Mint    English    https://www.tcgplayer.com/product/16476 … FMd193Y0I.

Myr    Extras: Double Masters    7    Near Mint    English    https://www.tcgplayer.com/product/22004 … FMd193Y0I.

Myr    Extras: Double Masters    24    Near Mint    English    https://www.tcgplayer.com/product/22006 … FMd193Y0I.

Thopter    Extras: Double Masters    8    Near Mint    English    https://www.tcgplayer.com/product/22004 … FMd193Y0I.

Thopter    Extras: Double Masters    26    Near Mint    English    https://www.tcgplayer.com/product/22006 … FMd193Y0I.

Wurm    Extras: Double Masters    29    Near Mint    English    https://www.tcgplayer.com/product/22007 … FMd193Y0I.

Wurm    Extras: Double Masters    30    Near Mint    English    https://www.tcgplayer.com/product/22007 … FMd193Y0I.

Zombie    Extras: Eldritch Moon    5    Near Mint    English    https://www.tcgplayer.com/product/12044 … FMd193Y0I.

Human Soldier    Extras: Ikoria: Lair of Behemoths    3    Near Mint    English    https://www.tcgplayer.com/product/21363 … FMd193Y0I.

Human Soldier    Extras: Ikoria: Lair of Behemoths    4    Near Mint    English    https://www.tcgplayer.com/product/21364 … FMd193Y0I.

Human Soldier    Extras: Ikoria: Lair of Behemoths    5    Near Mint    English    https://www.tcgplayer.com/product/21364 … FMd193Y0I.

Punch Card Token    Extras: Ikoria: Lair of Behemoths    14    Near Mint    English    https://www.tcgplayer.com/product/21457 … FMd193Y0I.

Construct    Extras: Kaladesh    2    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Construct    Extras: Kaladesh    3    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Servo    Extras: Kaladesh    4    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Servo    Extras: Kaladesh    5    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Servo    Extras: Kaladesh    6    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Thopter    Extras: Kaladesh    7    Near Mint    English    https://www.tcgplayer.com/product/12307 … FMd193Y0I.

Thopter    Extras: Kaladesh    9    Near Mint    English    https://www.tcgplayer.com/product/12308 … FMd193Y0I.

Clue    Extras: Modern Horizons 2    14    Near Mint    English    https://www.tcgplayer.com/product/24073 … FMd193Y0I.

Clue    Extras: Modern Horizons 2    15    Near Mint    English    https://www.tcgplayer.com/product/24074 … FMd193Y0I.

Food    Extras: Modern Horizons 2    17    Near Mint    English    https://www.tcgplayer.com/product/24075 … FMd193Y0I.

Food    Extras: Modern Horizons 2    18    Near Mint    English    https://www.tcgplayer.com/product/24075 … FMd193Y0I.

Treasure    Extras: Modern Horizons 2    20    Near Mint    English    https://www.tcgplayer.com/product/24076 … FMd193Y0I.

Treasure    Extras: Modern Horizons 2    21    Near Mint    English    https://www.tcgplayer.com/product/24076 … FMd193Y0I.

Elemental    Extras: Modern Horizons Foil    8    Near Mint    English    foil       https://starcitygames.com/elemental-tok … 1-t08-enf/

Token: Shapeshifter    Extras: Modern Horizons Foil    1    Near Mint    English    foil     https://www.cardkingdom.com/mtg/modern- … token-foil

Food    Extras: Throne of Eldraine    15    Near Mint    English    https://www.tcgplayer.com/product/19947 … FMd193Y0I.

Food    Extras: Throne of Eldraine    16    Near Mint    English    https://www.tcgplayer.com/product/19947 … FMd193Y0I.

Food    Extras: Throne of Eldraine    17    Near Mint    English    https://www.tcgplayer.com/product/19947 … FMd193Y0I.

Food    Extras: Throne of Eldraine    18    Near Mint    English    https://www.tcgplayer.com/product/19946 … FMd193Y0I.

Zombie Army    Extras: War of the Spark    8    Near Mint    English    https://www.tcgplayer.com/product/18812 … FMd193Y0I.

Double-Faced Card Placeholder    Extras: Zendikar Rising    7    Near Mint    English    https://www.tcgplayer.com/product/22310 … FMd193Y0I.

Gavi, Nest Warden    Oversized: Commander 2020    7    Near Mint    English    foil    https://www.tcgplayer.com/product/21294 … FMd193Y0I.

Jirina Kudro    Oversized: Commander 2020    8    Near Mint    English    foil    https://www.tcgplayer.com/product/21294 … FMd193Y0I.

Kalamax, the Stormsire    Oversized: Commander 2020    9    Near Mint    English    foil    https://www.tcgplayer.com/product/21294 … FMd193Y0I.

Kathril, Aspect Warper    Oversized: Commander 2020    10    Near Mint    English    foil   https://www.tcgplayer.com/product/21294 … FMd193Y0I.

Otrimi, the Ever-Playful    Oversized: Commander 2020    12    Near Mint    English    foil    https://www.tcgplayer.com/product/21294 … FMd193Y0I.

Azorius Guildgate    Ravnica Allegiance    244    Near Mint    English    foil    https://www.cardkingdom.com/mtg/ravnica … 244-b-foil

Augmenter Pugilist // Echoing Equation    Strixhaven: School of Mages    147    Near Mint    English    https://www.tcgplayer.com/product/23571 … FMd193Y0I.

Blex, Vexing Pest // Search for Blex    Strixhaven: School of Mages    148    Near Mint    English    foil    https://www.cardkingdom.com/mtg/strixha … -pest-foil

Blex, Vexing Pest // Search for Blex    Strixhaven: School of Mages    148    Near Mint    English    https://www.tcgplayer.com/product/23597 … FMd193Y0I.

Extus, Oriq Overlord // Awaken the Blood Avatar    Strixhaven: School of Mages    149    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … q-overlord

Flamescroll Celebrant // Revel in Silence    Strixhaven: School of Mages    150    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … -celebrant

Flamescroll Celebrant // Revel in Silence    Strixhaven: School of Mages    324    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … tended-art

Jadzi, Oracle of Arcavios // Journey to the Oracle    Strixhaven: School of Mages    151    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … f-arcavios

Kianne, Dean of Substance // Imbraham, Dean of Theory    Strixhaven: School of Mages    152    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … -substance

Kianne, Dean of Substance // Imbraham, Dean of Theory    Strixhaven: School of Mages    326    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … tended-art

Mila, Crafty Companion // Lukka, Wayward Bonder    Strixhaven: School of Mages    153    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … -companion

Pestilent Cauldron // Restorative Burst    Strixhaven: School of Mages    154    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … t-cauldron

Pestilent Cauldron // Restorative Burst    Strixhaven: School of Mages    154    Near Mint    English    foil        https://www.cardkingdom.com/mtg/strixha … ldron-foil

Plargg, Dean of Chaos // Augusta, Dean of Order    Strixhaven: School of Mages    155    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … n-of-chaos

Selfless Glyphweaver // Deadly Vanity    Strixhaven: School of Mages    157    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … lyphweaver

Shaile, Dean of Radiance // Embrose, Dean of Shadow    Strixhaven: School of Mages    158    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … f-radiance

Torrent Sculptor // Flamethrower Sonata    Strixhaven: School of Mages    159    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … t-sculptor

Torrent Sculptor // Flamethrower Sonata    Strixhaven: School of Mages    159    Near Mint    English    foil     https://www.cardkingdom.com/mtg/strixha … lptor-foil

Uvilda, Dean of Perfection // Nassari, Dean of Expression    Strixhaven: School of Mages    160    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … perfection

Valentin, Dean of the Vein // Lisette, Dean of the Root    Strixhaven: School of Mages    161    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … f-the-vein

Valentin, Dean of the Vein // Lisette, Dean of the Root    Strixhaven: School of Mages    161    Near Mint    English    foil    https://www.cardkingdom.com/mtg/strixha … -vein-foil

Valentin, Dean of the Vein // Lisette, Dean of the Root    Strixhaven: School of Mages    333    Near Mint    English    foil    https://www.cardkingdom.com/mtg/strixha … d-art-foil

Wandering Archaic // Explore the Vastlands    Strixhaven: School of Mages    6    Near Mint    English    foil     https://www.cardkingdom.com/mtg/strixha … chaic-foil

Wandering Archaic // Explore the Vastlands    Strixhaven: School of Mages    6    Near Mint    English    https://www.cardkingdom.com/mtg/strixha … ng-archaic

Wandering Archaic // Explore the Vastlands    Strixhaven: School of Mages    286    Near Mint    English    foil    https://www.cardkingdom.com/mtg/strixha … d-art-foil

Animate Dead    The List    420    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … imate-dead

Aura Shards    The List    437    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … -commander

Boros Challenger    The List    201    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … challenger

Guttersnipe    The List    367    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … icol-bolas

Herald's Horn    The List    343    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … ralds-horn

Jubilant Mascot    The List    351    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … ant-mascot

Liliana's Devotee    The List    316    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … as-devotee

Maelstrom Nexus    The List    218    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … s-non-foil

Man-o'-War    The List    65    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … masters-25

Memnite    The List    262    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … f-mirrodin

Nezumi Graverobber    The List    108    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … raverobber

Painful Lesson    The List    363    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … n-amonkhet

Pillage    The List    321    Near Mint    English    https://www.cardkingdom.com/mtg/mystery-booster/pillage

Springjack Shepherd    The List    36    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … d-non-foil

Young Pyromancer    The List    371    Near Mint    English    https://www.cardkingdom.com/mtg/mystery … 4-core-set

Beanstalk Giant // Fertile Footsteps    Zendikar Rising Commander    61    Near Mint    English    https://www.cardkingdom.com/mtg/zendika … talk-giant

Struggle // Survive    Zendikar Rising Commander    102    Near Mint    English    https://www.cardkingdom.com/mtg/zendika … le-survive


Also, the prices for the Japanese language Strixhaven Mystical Archives foils aren't even close. I'm not talking Etched Foils, I know that's still a work in progress. I'm unable to list them until those point to the proper versions. I will try to do that soon.

Go to forum: Site Discussion

2 Reply by StoneValley

(46 replies, posted in Announcements)

I believe the cleanest solution would be to develop an etched flag, and the most common across the internet is Foil-Etched. This is a trend that is obviously not going anywhere anytime soon.

Go to forum: Announcements

3 Reply by StoneValley

(24 replies, posted in Buying & Selling Cards)

meldon44 wrote:
=MAX(.18,ROUND(S2*VLOOKUP(F2,{"Near Mint",1;"Good (Lightly Played)",0.95;"Played",0.9;"Heavily Played",0.7;"Poor",0.4},2,0),2))

That is much cleaner than what I was doing @meldon44, and am very familiar with the VLOOKUP and INDEX/MATCH functions, rounding and arrays. As soon as I saw your formula it clicked. I guess this solution just didn't pop in my head when I was building out my excel workflow, but I will definitely try it out! I also agree with your prices for the most part, but in anything that fluctuates as much as MTG singles - lower is usually the winner, but selling low without giving away the baby with the bathwater is the balance, so I'm always tinkering with the % for NM and will probably continue to do so. You're about 2% greater percentage off than me for NM, so I might dig a little deeper and see how that goes. Thanks for the post!

Go to forum: Buying & Selling Cards

4 Reply by StoneValley

(24 replies, posted in Buying & Selling Cards)

I'm sure I'm not the only one using Excel and .csv files to keep everything straight, and I'm sure there's enough of us to share good ideas amongst ourselves...and I don't mind starting. It's all relatively easy using Excel (or whatever software suite you prefer) and .csv files. Once you have the deckbox format downloaded there are all sorts of things you can do. As you are loading the cards into the system you annotate the condition, language, etc. Going back and updating a current collection takes a long time, but once you're updated adding new items is easier. Especially pack-fresh adds. If we pick up a 30,000 card collection the majority of initial time is spent in condition/set/authenticity checking and keeping records in Excel. Then we load it in deckbox from .csv. Obviously I'm still a human and make mistakes, but they are reduced considerably. We also use Excel to update our prices by condition. Just set up a custom sort by condition with NM on top and Poor on the bottom. Then run your formula from top to bottom and at each condition section change the formula to increase the percentage taken off the base price provided by deckbox. An example: 'My Price' is in column O and 'Price' is in Column S in the version of the deckbox .csv we use the most often. I slide down to the Lightly category and in Column O I generally type, =S2-(.05*S2) and it takes 5% off deckbox prices. I double click in the lower right corner of that cell and it copies the formula through the rest of my 16,216 individual lines in about ten seconds. I go to the next condition, and might make it =S1234-(.1*S1234) NOTE that S1234 is just for explanation, the actual number would be the cell where that next condition starts once again double clicking bottom right of the cell and it drags that down to the bottom. This formula would take 10% off deckbox prices. As there are no hard rules I may change those percentages to more or less, but I keep moving down the list, reducing prices for each condition. It's how I also set everything to not sell any card for less than 18 cents by a simple 'Sort Smallest to Largest' and fix them. The same concept could be used to easily run a sale. From the time I download the current list, update it, and upload the new list is about five minutes.

Managing a card database of almost 100,000 cards as I do would be impossible without .csv files and using Excel to keep everything straight. I'm very familiar with Excel due to previous experience, but there are a lot of ways to get what you need done through Google searches. It may be frustrating at first, but the time saved in the end will be well worth the effort! Anyone else have some neat Excel tricks they use to manage their extensive database and might be willing to share?

Go to forum: Buying & Selling Cards

5 Reply by StoneValley

(24 replies, posted in Buying & Selling Cards)

This is an interesting topic, and 'how' deckbox works has caused us to modify how we sell our cards here. If you take a quick look, we're listing over 90,000 cards and I've taken condition into our pricing so the list price drops with each condition tier. I have customers use this same system in our physical shop (Stone Valley Games) so my inventory is kept up in real-time. Fairly easy to set up a standalone computer / tablet preset to your seller list. If they find something they like it's quick to make a deckbox account and place an order. I update our list every other day or so, and I had to develop a workflow to be as efficient as possible due to 'the snipers' as someone pointed out. Trust me, I know it can be frustrating to continually get sniped (if you really want to feel horrible, do the price comparison from what the cards were worth when you sold them to how much they are worth today...sobering). However, I will always honor the price as listed when they order. The only time I won't (can't) is if we literally don't have the card, and since there are over 90K cards miscounting occasionally happens. I believe as the seller it's my responsibility to keep those prices updated and to honor sales. By keeping the prices updated I generally don't take quite such a big hit, but this is a buyers market and the deckbox system show buyers every seller with that card and generally the lowest price wins, right? It's super easy for them to see the new hotness that was just broken by a pro last night and snatch up those cards in real time. It is the way. I have several loyal customers who like what we do and how we ship, etc., and I greatly appreciate their continued patronage but at the end of the day we're slinging cardboard and most folks are looking for deals. 

I used to keep three different systems and would update between the three every day in different platforms, including my own shop. I had built a rudimentary Excel tool that took about three hours to run. Insanity, but again I believe it is our responsibility for pricing and accountability as the seller. By trimming everything down I have now simplified everything and with a few quick formulas in Excel can pump out a completely updated list in about five minutes. One base system, one base selling platform. I'm losing out on selling in other platforms, but over the years I'm finding my sanity is worth more to me than a few more sales. That's also why it is worth it for me to pay deckbox to sell in my own shop. Again, that cost to me is well worth the time and frustration I no longer have to deal with. Now, if I really wanted to make money I would finish developing the tool I started that could update across numerous databases with the click of a button...but the way we run now works just fine.

I know I don't have a vote, but I like the fact that folks can just place an order here, it's super easy for them. Easy for buyers is good for everyone. There's no waiting on one side or the other to check the system and provide an update dragging things out for hours/days. For us, if they order and we don't have the card we refund the price and process the rest of the order, always keeping the buyer completely informed on what's going on. While there will always be snipers, I believe there are even more folks just looking for good card prices to round out, or bling, or fill gaps in their decks / collections. For the overarching question here, it's always an interesting exercise to gauge second and third order effects. In this case I believe installing an automatic pause in the system would just drive buyers to other systems where they can scratch that itch in real-time, and once they are gone they'll most likely not be back. I wonder how difficult it would be to turn something like that on as an individual seller? That might help you out with your issue without imposing the change across the entire system.

Go to forum: Buying & Selling Cards

6 Reply by StoneValley

(1 replies, posted in Buying & Selling Cards)

I've sent you an 'email' message from your profile - but I don't know if that medium is working as I've never received a reply from anyone I've sent a message to that way. Did you receive the message? Thanks. --Eric

Go to forum: Buying & Selling Cards