Skip to content

Latest commit

 

History

History
35 lines (31 loc) · 2.45 KB

README.md

File metadata and controls

35 lines (31 loc) · 2.45 KB
Raw

My-Comic-Book-Collection

Python script that takes just a few inputs from an Google sheet to query for additional details from https://comicspriceguide.com.
Result is an updated sheet with current values, description, and other helpful features as well as a helpful HTML page with your entire collection in s nice visual layout.

Provide the following columns in a google sheet:

  • Title - Your Comics Title (Amazing Spider-Man)
  • Issue - The Issue Number (101)
  • Grade - Grade of the book (.5 increments .5-9.0 / .2 increments above that 9.2, 9.4, 9.6, 9.8)
  • CGC - Yes/No if the Book has been graded by a professional grading service
  • Variant - Some Issues have multiple printes/covers, this is where yoo indicate the specific cover you have (E)
  • Price_Paid - The Price you paid for the book
  • Book Link - Sometimes the app may notselect the right book, this allows you to provide the direct URL, when populated the app uses this rather than searching.

Sheet enriched with:

  • Publisher - Publisher of the title
  • Volume - Volume
  • PublishDate - Original Publish Date
  • KeyIssue - Is the book considered a "Key Issue" (Yes/No)
  • Cover_Price - Original Cover Price
  • Graded Price - Value of book if professionally graded
  • Ungraded Price - Value of book if not professionally graded
  • Value - Value of book in current state
  • Comic_Age - Comic "Age" (Silver, Modern)
  • Notes - Short description of the comic, including references to 1st appearances
  • Confidence - Confidence the app had when attempting to match
  • Book Link - If not provided as input
  • Cover Url - Cover image
  • CURRENTDATE - The date the scan was performed and the value of the book at that time, allowing you to scan periodically and easily identify price fluctuations.

HTML Results:

  • A single HTML page with the covers of each of your books, formatted to look stunning on any format
  • Hover-over any book to see book details (Title, Grade, Value, CGC Graded, Key Issue)
  • Click any book to go directly to that book on https://comicspriceguide.com

IMPORTANT NOTE: Though I have taken an effort to try and simulate a normal user session wtih delays there is a chance the bot could be detected. If you run this and are detected by https://comicspriceguide.com you stand a chance of having your IP banned from that site.