T O P I C R E V I E W |
Moonkeeper | http://rapidshare.com/share/2C937FCD7041709671659B16E16DC0D9 I just got a request for this via e-mail from a previous post. This is an Excel sheet that'll update the value of your collection. It pulls TCG Player mid-prices by running a macro and multiplies them by .75 to attempt to get closer to eBay prices. edit: Updated to include sets through Journey Into Nyx; Fixed M10 name change convention
[Edited 3 times, lastly by Moonkeeper on May 13, 2014] |
Mr.C | Is it still the same function if I want to use the low price? |
Moonkeeper | To change it to the low price, highlight column C then click find/replace in the find box put: ,7, in the replace box put: ,8, click replace all If you want to pull TCG prices without multiplying it by anything than just set the multiplier box on the Collection sheet to 1. |
blandestk | This is fantastic! Thanks for putting it together. I haven't been to this site in years. What is the deal with the MOTL price guides? Are they up at all? Apologies for a topic I'm sure is up a billion times already. |
Moonkeeper | quote: Originally posted by blandestk: This is fantastic! Thanks for putting it together.I haven't been to this site in years. What is the deal with the MOTL price guides? Are they up at all? Apologies for a topic I'm sure is up a billion times already.
Thanks. I used to take the price guide that was on this site and import it into Excel. I think eBay changed some of their site and it broke the price guides in such a way that they were unfixable. The people that put it together and maintained the csv file put a lot of work into it. They had to correct code with every change and set release.
|
Moonkeeper | This is updated to include sets through Born of the Gods. The link is in the original post. Any questions feel free to post. Any suggestions let me know. |
ryan2754 | No foils correct? |
Moonkeeper | No foils. |
ryan2754 | This up to date with Journey? __________________ -Schmitty, MOTL's Psychiatrist 70th in Refs [328] on MOTL (2 behind inca911) 2nd in Refs [328] in OH-IO (87 behind souladvocate) 1st in Posts in OH-IO (Passed the legendary ValMTG) “If Brad Stevens is the future of coaching in college basketball, the sport is in a good place" - Rick Pitin
|
Goaswerfraiejen | quote: Originally posted by ryan2754: This up to date with Journey?
BnG. __________________ "I have heard the mermaids singing, each to each. I do not think they will sing to me." -T.S. EliotRIP Ari Legacy UGB River Rock primer. PM comments/questions. Info on grad school in Phil.
|
Moonkeeper | Hey guys. I saw in my e-mail that there were a couple responses to this asking for updates. I'll update as soon as I can. We had kid #4 back in February and my Magic activity has been somewhat limited since (I haven't even played a game of Magic since). A couple people that I've talked to via e-mail have made their own mods to it as well. If anyone else wanted to update it I would not take offense. Once life calms down a bit I'll add the more recent sets (and hopefully start playing again). |
Moonkeeper | I just updated this in the original thread to include Journey into Nyx and to fix the naming convention change that caused the m10 links to break. |
tragicmagic | Do you know if this can be imported into Crystal Commerce? |