Steam Card Profit Calculator (Excel + Python)
Content: Steam_Card_Calculator_v1.0.zip (14.25 KB)
Uploaded: 19.05.2026
Positive responses: 0
Negative responses: 0
Sold: 0
Refunds: 0
$6.99
Excel + Python kit that tells you if a Steam game is actually worth buying for the trading cards it drops.
Paste an AppID, get instant ROI / Profit / Loss verdict per game. Handles Steam´s 15% market fee, the 50% auto-drop rate, and ranks deals side-by-side.
WHAT YOU GET
- Steam_Card_Calculator.xlsx — 4-sheet workbook with formulas and conditional formatting (red = loss, green = profit, yellow = breakeven). 50 games per sheet.
- update_prices.py — one-command refresher. Pulls live game names, set sizes, and median card prices straight from Steam Store and Community Market APIs. About 2 minutes for 50 games.
- README — quick start, math walkthrough, list of sites to find cheap card-bearing games.
HOW THE MATH WORKS
Expected Drops = Set Size × Drop Rate
Cards Value Gross = Expected Drops × Avg Card Price
Net (after fee) = Cards Value Gross × (1 - Steam Fee)
ROI % = (Net - Purchase Price) / Purchase Price × 100
Tune the fee and drop-rate in the Settings sheet to model different scenarios.
TECH REQUIREMENTS
Excel, LibreOffice Calc, or Google Sheets (after import). Python 3.10+ with openpyxl and httpx (one-line pip install). Steam Community account, no API keys.
Paste an AppID, get instant ROI / Profit / Loss verdict per game. Handles Steam´s 15% market fee, the 50% auto-drop rate, and ranks deals side-by-side.
WHAT YOU GET
- Steam_Card_Calculator.xlsx — 4-sheet workbook with formulas and conditional formatting (red = loss, green = profit, yellow = breakeven). 50 games per sheet.
- update_prices.py — one-command refresher. Pulls live game names, set sizes, and median card prices straight from Steam Store and Community Market APIs. About 2 minutes for 50 games.
- README — quick start, math walkthrough, list of sites to find cheap card-bearing games.
HOW THE MATH WORKS
Expected Drops = Set Size × Drop Rate
Cards Value Gross = Expected Drops × Avg Card Price
Net (after fee) = Cards Value Gross × (1 - Steam Fee)
ROI % = (Net - Purchase Price) / Purchase Price × 100
Tune the fee and drop-rate in the Settings sheet to model different scenarios.
TECH REQUIREMENTS
Excel, LibreOffice Calc, or Google Sheets (after import). Python 3.10+ with openpyxl and httpx (one-line pip install). Steam Community account, no API keys.
No feedback yet