How to Build a Real-Time Commodity Price Tracker with Python

Commodity prices move fast — oil, gold, copper, wheat. Traders, analysts, and supply chain managers need real-time visibility. Here's how to build an automated commodity price tracker that scrapes, stores, and alerts on price movements. Data Sources Trading Economics : Comprehensive commodity overview pages Investing.com : Real-time futures prices CME Group : Official exchange data for major commodities World Bank : Monthly commodity price indices (Pink Sheet) Building the Price Scraper import requests from bs4 import BeautifulSoup import re import json from datetime import datetime import sqlite3 import time API_KEY = " YOUR_SCRAPERAPI_KEY " class CommodityTracker : def __init__ ( self , api_key , db_path = " commodities.db " ): self . api_key = api_key self . db = sqlite3 . connect ( db_path ) self . db . execute ( """ CREATE TABLE IF NOT EXISTS prices ( id INTEGER PRIMARY KEY AUTOINCREMENT, commodity TEXT, price REAL, change_pct REAL, unit TEXT, source TEXT, scraped_at TEXT ) """ )