Most sports bettors track their results in a simple spreadsheet. They know their Profit and Loss, but they miss the hidden metrics that actually predict future success.
Are you winning because you are a skilled handicapper, or are you just running hot? Our Portfolio Bet Tracker answers this question. By pasting your betting history in bulk, this tool instantly generates a professional audit of your performance, calculating ROI, Closing Line Value (CLV), and P-Value (Variance).
Portfolio Bet Tracker
BATCH ANALYZERHow to Use the Portfolio Bet Tracker
This tool is designed for “Batch Processing.” You do not need to enter bets one by one. You can copy data directly from Excel, Google Sheets, or a text file.
1. Prepare Your Data
The tracker requires a specific CSV (Comma Separated Values) format. Each line represents one bet:
Stake, Odds, Result, [Closing Odds]
- Stake: Your bet amount (e.g., 100).
- Odds: The decimal odds you took (e.g., 1.95).
- Result: Use ‘W’ for Win, ‘L’ for Loss, ‘P’ for Push. (Half-Win ‘HW’ and Half-Loss ‘HL’ are also supported).
- Closing Odds (Optional): The odds when the market closed. This is required for CLV analysis but optional for ROI.
2. Paste and Analyze
Copy your list and paste it into the text area. Click “Analyze Portfolio” to generate your dashboard.
Understanding Your Metrics: Luck vs. Skill
This betting variance analysis tool goes beyond simple profit tracking. Here is how to interpret the advanced data.
ROI vs. CLV
ROI (Return on Investment) measures your past results. CLV (Closing Line Value) predicts your future results.
- If your ROI is high (e.g., 15%) but your CLV is negative (you are consistently betting worse odds than the closing line), the calculator will flag this as “Likely Luck.” Mathematical gravity will eventually pull your ROI down.
- If your ROI is low (or slightly negative) but your CLV is high, you are likely a winning bettor suffering from temporary bad variance.
The “Truth” Interval (Confidence Interval)
The calculator displays a 95% Confidence Interval. For example, if your ROI is 5%, the interval might show -2% to +12%.
This means that based on your sample size and volatility, your “True Skill” lies somewhere in that range. As you log more bets (sample size increases), this range narrows, giving you a definitive answer on your profitability.
P-Value (The Skill Test)
The tool calculates a T-Score and P-Value. In statistics, a P-Value of < 5% indicates “Statistical Significance.” In betting terms, this means there is less than a 5% chance that your profits are a result of random luck.
Frequently Asked Questions (FAQ)
Can I upload an Excel file?
Currently, you must copy and paste the text data. However, you can simply highlight columns A, B, C, and D in Excel, copy them, and paste them directly into the tool. It reads tab-separated values just as well as commas.
What does “Closing Line Value” (CLV) mean?
CLV measures whether you beat the market. If you bet the Chiefs at 2.00 (+100) and the line closes at 1.80 (-125), you gained value. Consistently beating the closing line is the surest sign of a sharp bettor, regardless of short-term wins or losses.
Why does the verdict say “Insufficient Data”?
Variance in sports betting is massive. A sample size of fewer than 30 bets is statistically meaningless. To get a “Skill Confirmed” verdict, you typically need a history of 500+ bets with a consistent yield.
Is my data private?
Yes. This betting tracker runs entirely in your browser using JavaScript. Your betting history is never sent to our servers or stored in a database. When you refresh the page, the data is gone.