Leaderboard

Issues submitted. You will need to delete any cover B through H that look like covers I through J (the 616 Comics variants). I renamed them correctly and submitted them with the data.

This week's update added the Comic title Jacin andthe Olympians. There should be a space between and and the, yes? Also added was the new Comic title The Making of Assassin’s Creed: 15th Anniversary Edition. Based on the title description, this sounds like it really belongs in the Book category. The database now includes the following three Comic titles: • Spider-Man 2 (Custom Sony Interactive Entertainment 2023) • Custom Sony Interactive Entertainment 2023 English Print Comic (Marvel) • Custom Sony Interactive Entertainment 2023 English Print Comic At least two of these look like they are the same thing, I am suspicious that all three of them are the same thing.

Greg, I am not sure if this gets you what you are looking for. It uses ValueYear4 to get the Current Price which is not accurate. If you have Locked the Price, the actual value you want for that week is not stored in the database (I don't believe). However, I checked a new database and all the Price and ValueYear4 matched in value (except for 2 which looked like they rounded to nearest whole dollar). What this does is uses the Condition value in a CASE expression to convert to the Percent value then multiplies with the ValueYear4 to get the adjusted price per Condition. I.Price < (I.ValueYear4 * CASE I.Condition WHEN 'MT' THEN 1.5 1.05 WHEN 'NM' THEN 1 WHEN 'NM-' THEN .9 WHEN 'VF-NM' THEN .8 WHEN 'VF' THEN .66 WHEN 'FN' THEN .33 WHEN 'VG' THEN .20 WHEN 'G' THEN .13 WHEN 'FA' THEN .08 WHEN 'P' THEN .02 END) * .5 PS If you have other than the Standard Conditions (CGC for example), you will need to use Setup->Grading... to get the Text value (under Cond) and the Percent value (under % of NM) and add additional WHEN ... THEN ... statements.

Yup. That's me. A comic comic.

I'm partial to B-flat minor...