Click Here!
         
  Magic Online Trading League Bulletin Board
  Magic Discussion
  Built a card list cleaner and pricer - Looking for feedback (Page 1)

Post New Topic  Post A Reply
profile | register | preferences | faq | rules | memberlist | search

UBBFriend: Email This Page to Someone!
This topic is 2 pages long:   1  2 
  next newest topic | next oldest topic
Author Topic:   Built a card list cleaner and pricer - Looking for feedback
casparro
Member
posted January 18, 2014 01:04 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
The basic idea is that you should be able to dump a list of cards in it, and it will clean the list and give you appropriate pricing. Useful for formatting your list and checking on current approximate values. It should be able to handle any formatting, so stress test it!

Looking for feedback and if it's useful to anyone else. Thanks!

Link

[Edited 2 times, lastly by casparro on January 18, 2014]

 
headumpire
Member
posted January 18, 2014 03:26 PM   Click Here to See the Profile for headumpire Click Here to Email headumpire Send a private message to headumpire Click to send headumpire an Instant Message Edit/Delete Message Reply With Quote 
Very nifty little tool.

Can i ask where your prices come from? I would love one that does TCGLow/Mid.

Any chance you could add a list total at the bottom?

I would probably use this daily if those changes could be made!! Or just more info on the prices

Awesome!

 
casparro
Member
posted January 18, 2014 05:24 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Working on your requests. Thanks for the feedback!
 
Goaswerfraiejen
Member
posted January 18, 2014 06:00 PM   Click Here to See the Profile for Goaswerfraiejen Click Here to Email Goaswerfraiejen Send a private message to Goaswerfraiejen Click to send Goaswerfraiejen an Instant Message Edit/Delete Message Reply With Quote 
Nice tool, thanks for sharing! Some thoughts (mostly to help people sort and price their collections/collections they intend to purchase):

*Perhaps another column multiplying the quantity by the price for each?
*Perhaps a row or cell indicating the listed cards' total value?


Also, one question: what is the maximum number of entries in the text box?

__________________
"I have heard the mermaids singing, each to each. I do not think they will sing to me." -T.S. Eliot

RIP Ari

Legacy UGB River Rock primer. PM comments/questions.
Info on grad school in Phil.

 
casparro
Member
posted January 18, 2014 06:53 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Added a line total to the right and total at the bottom.
 
AGO
Member
posted January 18, 2014 07:29 PM   Click Here to See the Profile for AGO Click Here to Email AGO Send a private message to AGO Click to send AGO an Instant Message Edit/Delete Message Reply With Quote View AGO's Trade Auction or SaleView AGO's Trade Auction or Sale
Damn this is my dream come true. Possible to have an option to round to the nearest $0.25? Also how does it handle cards with multiple printings?
 
pugowar
Member
posted January 18, 2014 07:48 PM   Click Here to See the Profile for pugowar Click Here to Email pugowar Send a private message to pugowar Click to send pugowar an Instant Message Edit/Delete Message Reply With Quote 
I love it.
Couple suggestions.
Judge Foils and FtV foils dont seem to work.
Were you the one who had the program that let you put the card names in and it return the pictures of the cards?
That would be cool

I pasted my legacy deck: It didnt figure out a handful.

1 Bojuka Bog - [Foil] Worldwake
1 Dryad Arbor - [Foil] From the Vault: Realms
1 Forest (248) - Full Art - [Foil] Zendikar
1 Green Sun's Zenith - [Foil] From the Vault: Twenty
1 Karakas - [Foil] Judge Promos
1 Knight of the Reliquary - [Foil] Conflux
1 Maze of Ith - [Foil] From the Vault: Realms
1 Pernicious Deed - [Foil] Judge Promos
1 Plains (232) - Full Art - [Foil] Zendikar
1 Qasali Pridemage - [Foil] FNM Promos
1 Swamp (240) - Full Art - [Foil] Zendikar
1 Sylvan Library - [Foil] Commander's Arsenal
2 Hymn to Tourach - [Foil] From the Vault: Twenty
2 Loxodon Smiter - [Foil] Return to Ravnica
2 Maelstrom Pulse - [Foil] Grand Prix Promos
2 Savannah Revised Edition
2 Scavenging Ooze - [Foil] Media Promos
2 Scrubland Revised Edition
2 Windswept Heath - [Foil] Onslaught
3 Bayou Revised Edition
3 Knight of the Reliquary - [Foil] Modern Masters
3 Liliana of the Veil - [Foil] Innistrad
3 Thoughtseize - [Foil] Theros
3 Verdant Catacombs - [Foil] Zendikar
4 Abrupt Decay - [Foil] Return to Ravnica
4 Dark Confidant - [Foil] Judge Promos
4 Deathrite Shaman - [Foil] Return to Ravnica
4 Marsh Flats - [Foil] Zendikar
4 Swords to Plowshares - [Foil] From the Vault: Twenty
4 Tarmogoyf - [Foil] Modern Masters
4 Wasteland Magic Player Rewards

[Edited 1 times, lastly by pugowar on January 18, 2014]

 
casparro
Member
posted January 18, 2014 08:12 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
quote:
Originally posted by AGO:
Damn this is my dream come true. Possible to have an option to round to the nearest $0.25? Also how does it handle cards with multiple printings?

When its not able to figure out the set, it shows the set as "?". I'm open to other ideas. =)



[Edited 1 times, lastly by casparro on January 18, 2014]

 
psrex
Member
posted January 18, 2014 08:18 PM   Click Here to See the Profile for psrex Click Here to Email psrex Send a private message to psrex Click to send psrex an Instant Message Edit/Delete Message Reply With Quote 
I took a deck list and put it in for a test:

3 Ancient Tomb
2 City of Traitors
2 Island
4 Misty Rainforest
1 Mountain
4 Scalding Tarn
3 Volcanic Island
4 Lotus Petal
4 Brainstorm
2 Flusterstorm
4 Ponder
2 Repeal
2 Daze
1 Intuition
4 Show and Tell
4 Sneak Attack
4 Force of Will
2 Misdirection
4 Griselbrand
4 Emrakul, the Aeons Torn

#60

Sideboard:
2 Grafdigger's Cage
3 Red Elemental Blast
1 Shattering Spree
1 Spell Pierce
2 Stifle
2 Blood Moon
1 Wipe Away
1 Mindbreak Trap
2 Through the Breach

It properly ignored the lines that weren't cards, but it didn't properly recognize a few cards -- Ponder, Brainstorm, and Blood Moon. Overall it seems like a nice tool.

 
casparro
Member
posted January 18, 2014 10:30 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Fixed the output when it doesn't know the set.
 
casparro
Member
posted January 18, 2014 10:33 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Fixed the output for the cards listed which it didn't know what set they are. Looks less wrong now =)

quote:
Originally posted by psrex:
I took a deck list and put it in for a test:

3 Ancient Tomb
2 City of Traitors
2 Island
4 Misty Rainforest
1 Mountain
4 Scalding Tarn
3 Volcanic Island
4 Lotus Petal
4 Brainstorm
2 Flusterstorm
4 Ponder
2 Repeal
2 Daze
1 Intuition
4 Show and Tell
4 Sneak Attack
4 Force of Will
2 Misdirection
4 Griselbrand
4 Emrakul, the Aeons Torn

#60

Sideboard:
2 Grafdigger's Cage
3 Red Elemental Blast
1 Shattering Spree
1 Spell Pierce
2 Stifle
2 Blood Moon
1 Wipe Away
1 Mindbreak Trap
2 Through the Breach

It properly ignored the lines that weren't cards, but it didn't properly recognize a few cards -- Ponder, Brainstorm, and Blood Moon. Overall it seems like a nice tool.


 
Zarfolos132
Member
posted January 18, 2014 11:42 PM   Click Here to See the Profile for Zarfolos132 Click Here to Email Zarfolos132 Send a private message to Zarfolos132 Click to send Zarfolos132 an Instant Message Edit/Delete Message Reply With Quote 
omg this is awesome. if you continue this to where you can average several sites, or pick a specific one, that would be great. My only suggestion at this stage would be (idk anything about this programming stuff so idk how hard this would be) if it doesn't recognize the card at all, as opposed to what set said card is from, maybe a way to differentiate? say a drop down if it know that card X is a card, just different sets printed that would let you choose? I really like how it works threw a small list up there had most and the few it didn't I had to just put the set in, though it didn't recognize indestructibility even with the set. I hope you keep going, this could become a widely used tool my friend.
 
pugowar
Member
posted January 19, 2014 04:56 AM   Click Here to See the Profile for pugowar Click Here to Email pugowar Send a private message to pugowar Click to send pugowar an Instant Message Edit/Delete Message Reply With Quote 
The prices do seem quite a bit off on some of those foils. Where are you getting the data from?
 
casparro
Member
posted January 19, 2014 08:24 AM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Yeah, foils are WAAAAAY of. Trying to fix those.
 
headumpire
Member
posted January 20, 2014 06:59 AM   Click Here to See the Profile for headumpire Click Here to Email headumpire Send a private message to headumpire Click to send headumpire an Instant Message Edit/Delete Message Reply With Quote 
Very nice changes. Where is the price data from?
 
AGO
Member
posted January 20, 2014 07:20 AM   Click Here to See the Profile for AGO Click Here to Email AGO Send a private message to AGO Click to send AGO an Instant Message Edit/Delete Message Reply With Quote View AGO's Trade Auction or SaleView AGO's Trade Auction or Sale
Its gives Foil prices for cards that do not have a foil version. Like Argivian Archaeologist [foil] is priced at $22.83 but foils do not really exist.
 
HandicapParking
Member
posted January 20, 2014 09:37 AM   Click Here to See the Profile for HandicapParking Click Here to Email HandicapParking Send a private message to HandicapParking Click to send HandicapParking an Instant Message Edit/Delete Message Reply With Quote View HandicapParking's Trade Auction or SaleView HandicapParking's Trade Auction or Sale
Debtor's Knell got confused with Debtor's Pulpit, but then I spotted the slight difference in punctuation: It's actually Debtors' Knell, which resolves properly.

Maybe stripping punctuation from the input and the lookup will improve usability. I imagine wizards wouldn't print two cards that differ by punctuation only and otherwise have identical strings of characters, but I could be wrong.

 
casparro
Member
posted January 20, 2014 06:20 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
yeah, once again, foils = pain in the ass

quote:
Originally posted by AGO:
Its gives Foil prices for cards that do not have a foil version. Like Argivian Archaeologist [foil] is priced at $22.83 but foils do not really exist.

 
casparro
Member
posted January 20, 2014 06:25 PM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
All pricing comes from ebay completed listings.
quote:
Originally posted by headumpire:
Very nice changes. Where is the price data from?

 
lickaneye
Member
posted January 21, 2014 12:24 AM   Click Here to See the Profile for lickaneye Click Here to Email lickaneye Send a private message to lickaneye Click to send lickaneye an Instant Message Edit/Delete Message Reply With Quote 
Very nice.

Going a step further, this would also work well as a trade evaluation tool. Simply doubling everything on the page or putting it side by side would probably accomplish this.

 
harbingerofthevoid
Member
posted January 21, 2014 05:59 AM   Click Here to See the Profile for harbingerofthevoid Click Here to Email harbingerofthevoid Send a private message to harbingerofthevoid Click to send harbingerofthevoid an Instant MessageVisit harbingerofthevoid's Homepage  Edit/Delete Message Reply With Quote View harbingerofthevoid's Have/Want ListView harbingerofthevoid's Have/Want List
Small thing. Maybe use the official set codes instead.

Example:

Thoughtseize LRW => false
Thoughtseize lrw => false
Thoughtseize LORWYN => true
Thoughtseize Lorwyn => true
Thoughtseize lw => true

LRW being the set code for Lorwyn. Or atleast that's what I gather from : http://en.wikipedia.org/wiki/List_of_Magic:_The_Gathering_sets

Or at least, some kind of popup/modal guide to the set abbreviations your script is using.


[Edited 1 times, lastly by harbingerofthevoid on January 21, 2014]

 
casparro
Member
posted January 21, 2014 09:19 AM   Click Here to See the Profile for casparro Click Here to Email casparro Send a private message to casparro Click to send casparro an Instant Message Edit/Delete Message Reply With Quote View casparro's Have/Want ListView casparro's Have/Want List
Thanks for the feedback. Updated to use the official set code. All of the examples below should work now =)

quote:
Originally posted by harbingerofthevoid:
Small thing. Maybe use the official set codes instead.

Example:

Thoughtseize LRW => false
Thoughtseize lrw => false
Thoughtseize LORWYN => true
Thoughtseize Lorwyn => true
Thoughtseize lw => true

LRW being the set code for Lorwyn. Or atleast that's what I gather from : http://en.wikipedia.org/wiki/List_of_Magic:_The_Gathering_sets

Or at least, some kind of popup/modal guide to the set abbreviations your script is using.


 
lickaneye
Member
posted January 21, 2014 10:40 AM   Click Here to See the Profile for lickaneye Click Here to Email lickaneye Send a private message to lickaneye Click to send lickaneye an Instant Message Edit/Delete Message Reply With Quote 
The list below didn't return any prices. I originally thought it was because the line items weren't set specific, but some searches without set specific lines worked (E.G. Tundra). Here is a sample list with no pricing output:

hallowed fountain
watery grave
breeding pool
godless shrine
jace memory adept

Regarding which set the output should return, when there are multiple matches, I would suggest defaulting to the most current printing.


 
dputz
Member
posted January 21, 2014 10:52 AM   Click Here to See the Profile for dputz Click Here to Email dputz Send a private message to dputz Click to send dputz an Instant Message Edit/Delete Message Reply With Quote 
Very nice. this is very easy to use and well done.

1 thought, maybe a clear button to clear the contents of the text box...you know, for lazy folks like me

Again, nice job!

 
chaos021
Member
posted January 21, 2014 11:01 AM   Click Here to See the Profile for chaos021 Click Here to Email chaos021 Send a private message to chaos021 Click to send chaos021 an Instant Message Edit/Delete Message Reply With Quote View chaos021's Have/Want ListView chaos021's Have/Want List
I love it! Thank you sir.

__________________
"Message to women worldwide: Girls....we're stupid. We don't like games. We don't know games. We can't read minds. Say it like you mean or STFU." -rockondon

My Sale Thread

 

This topic is 2 pages long:   1  2 

All times are PDT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | MOTL Home Page | Privacy Statement & TOS

© 1996-2013 Magic Online Trading League

Powered by Infopop © 2000
Ultimate Bulletin Board 5.47e