Skip to content

Latest commit

 

History

History
169 lines (132 loc) · 5.68 KB

readme.md

File metadata and controls

169 lines (132 loc) · 5.68 KB

Pokemon Card Price Tracker

This Python script automates the process of fetching Pokémon card prices from Cardmarket and saves them into a CSV file.
It uses Selenium with undetected_chromedriver to bypass Cloudflare protection and extract Trend Price and 30-Day Avg Price.

🚀 Features

✔ Fetches live prices from Cardmarket
✔ Bypasses Cloudflare protection using undetected_chromedriver
✔ Saves prices into a CSV file
✔ Automatically calculates total Trend Price & 30-Day Avg Price
✔ Runs minimized so it doesn’t interrupt your workflow
✔ Extracts Pokémon name and set from the URL
✔ Stores historical price data in JSON (data/price_history.json)
✔ Visualizes individual and total price history with Matplotlib

📌 Installation

1️⃣ Install Python Dependencies

Run the following command to install the required Python packages:

pip install pandas undetected-chromedriver selenium matplotlib

2️⃣ Ensure You Have Google Chrome

The script requires Google Chrome installed on your system.

3️⃣ Setup Data Directory

Create a data folder in your project root directory to store historical data:

mkdir data

📂 CSV File Setup

Save your Pokémon URLs to:

C:\Users\NAME\Downloads\pokemons_cards.csv

This CSV should have one column labeled URL:

URL
https://www.cardmarket.com/en/Pokemon/Products/Singles/Crown-Zenith/Giratina-VSTAR-CRZGG69
https://www.cardmarket.com/en/Pokemon/Products/Singles/Crown-Zenith/Arceus-VSTAR-CRZGG70

2️⃣ Run the Script

🚀 How to Run the Scripts

▶️ Fetch Prices and Update History

Run main.py to fetch prices and update your CSV and historical data:

python main.py
  • Prices will be saved in:
C:\Users\NAME\Downloads\updated_pokemons_cards.csv
  • Historical price data stored in:
data/price_history.json

📈 Visualize Price Trends

📊 Visualize Historical Prices

You can visualize historical price changes using the provided visualizer script:

python visualizer.py
  • Search using partial or full card names.
  • See the historical trends visually.
  • Visualize total collection price changes by typing total.

3️⃣ Check Output

After running, you’ll get:

  • Updated prices saved in C:\Users\NAME\Downloads\updated_pokemons_cards.csv
  • The final CSV file will contain: 
    Pokemons;Set;URL;Trend Price;30-Day Avg Price
Giratina VSTAR CRZGG69;Crown Zenith;https://www.cardmarket.com/en/Pokemon/Products/Singles/Crown-Zenith/Giratina-VSTAR-CRZGG69;232.3;244.37
Arceus VSTAR CRZGG70;Crown Zenith;https://www.cardmarket.com/en/Pokemon/Products/Singles/Crown-Zenith/Arceus-VSTAR-CRZGG70;208.29;172.72

⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️

🖥 How to Use (Standalone .EXE Version)

1️⃣ Convert the Script to .exe

To make a standalone .exe that does not require Python, follow these steps:

✅ Install PyInstaller

Make sure you have PyInstaller installed by running:

pip install pyinstaller

✅ Create the .exe

Run this command inside the folder where your gui_version2.py file is located:

⚠️ THIS PART IS NOT FINAL ⚠️
⚠️ WIP ⚠️

  • Select the CSV
  • Wait until it is finished! (Progress Bar)
  • Select where you want to save the new CSV file
  • Can choose to see the graph of the history prices
pyinstaller --onefile --noconsole --hidden-import pandas --hidden-import selenium gui_scraper.py

✔ --onefile → Creates a single .exe file
✔ --noconsole → Hides the black terminal window
✔ --hidden-import pandas --hidden-import selenium → Ensures all dependencies are included
image image

✅ Find the .exe

After PyInstaller finishes, go to:

C:\Pokemon-Card-Tracking-main\dist\

You will find:

gui_scraper.exe

2️⃣ Package and Send to Friends

  • Create a new folder (e.g., PokemonScraperApp).
  • Move gui_scraper.exe into the folder.
  • Right-click the folder → Compress to ZIP.
  • Send the .zip file via Google Drive, Discord, or WeTransfer.

3️⃣ How Your Friends Can Use the App

  1. Unzip the file into a folder.
  2. Double-click gui_scraper.exe to run it.
  3. Upload their CSV file when prompted.
  4. Wait for the updated CSV to be saved in the same folder.

⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️⚠️

❓ Troubleshooting

🔹 Chrome Opens and Closes Automatically?

That’s normal. The script opens a hidden Chrome session to fetch prices and then closes it automatically.

🔹 Getting HTTP 429 (Rate Limit) Error?

Try increasing the time.sleep(5) delay in the script to avoid hitting Cardmarket’s rate limit.

🔹 .exe Doesn’t Work on Another PC?

Ensure Google Chrome is installed. The .exe uses Chrome to fetch prices.

💡 Next Steps

🚀 Features Roadmap

  • ✅ Schedule automatic daily price updates using Windows Task Scheduler