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

✅ 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