Skip to content

Requirements

ConstantineVac edited this page Mar 10, 2023 · 5 revisions

What you need:

  1. An installation of Python 3.7 or higher.
  2. Required Python libraries: pandas, requests, beautifulsoup4, tqdm, openpyxl, pyfiglet, re, decimal, time, os, tinker.
  3. An Excel file to use as your binder with the following columns: Card Name, Expansion Set, Set ID, Card Version, Rarity, Set Number, Price, Timestamp, URL.
  4. Internet access for updating prices from cardmarket.com.

Additional information:

  • The excel file should be saved as a .xlsx file format.
  • The Card Name should be written exactly as it appears on the card, including spaces (ex. Giratina VSTAR). Don't worry about Gold or Rainbow cards, nor Alt arts and Full arts. These are determined by the Set Number (ex. The Legendary Giratina V Alt Art is number 186 in Lost Origin set, while Giratina V regular is 130).
  • The Expansion Set refers to the name of the set where the card belongs, and can be written with spaces (e.g. "Lost Origin").
  • The Set ID is the unique identifier code for the set, which can usually be found on the bottom right corner of the card (ex. LOR).
  • The Card Version column can contain 'None' if the card does not have any special versions (such as Alt Arts, Full Arts or Oversized cards).
  • The Rarity column allows users to categorize their cards based on rarity. You either write these lines yourself (not recommended) or get them for all your cards with the app. You can also count how many for example, Secret Rares or Promos you own!
  • The Set Number shouldn't be written with leading zeros, the app will fill the missing digits, to ensure that all cards are numbered consistently with 3 digits (e.g. "001"), if your card is number 78 in a specific set, the app will fill 078 automatically.
  • The Price column will be automatically updated by the app using cardmarket.com's 7-day average price for each card.
  • The Timestamp column will be automatically updated by the app with the date and time when the Price was last updated.
  • The URL column is REQUIRED, but can be manually added or generated automatically by the app using the card's information in order to quickly access the card's information on cardmarket.com.

Overall, the app is designed to make it easy for Pokémon TCG collectors to keep track of their collection's value and update their prices quickly and accurately.