Sports Trading and Investing Scanner & Notifier Development

Developer Spec: +EV Each-Way Scanner & Notifier

Project Goal:
Build a tool to identify +EV each-way betting opportunities by comparing live bookmaker EW prices against Betfair’s implied true place probabilities, calculate expected value and suggested stake, notify the user via Telegram, and log all activity for backtesting.


---

1️⃣ Core Requirements

Data Sources

1. Betfair API

Pull live Win and Place market prices for all UK horse racing events.

Use the API to calculate “true” place probabilities for each runner.



2. Bookmaker Scraping (Web or API)

William Hill & Bet365 (other bookmakers optional later).

Scrape each-way odds and place terms (e.g., 1/5, 1/4).

Include race time and location.
---

Calculations

1. Expected Value (EV)

Compare bookie odds vs. Betfair implied probabilities.

Calculate EV% for each selection.

2. Suggested Stake

Use progressive staking rules (user-configurable % of bankroll based on EV).

Optional: fractional Kelly for future enhancement.

---

Notifications

Send Telegram alert for any +EV bets over a user-defined threshold (e.g., EV ≥ 10%).

Message content should include:

Race name + time + location

Horse name

Bookmaker EW price & place terms

Betfair implied price

EV%

Suggested stake
---

Logging

Save every calculation/alert to Excel (.xlsx) for backtesting.

Columns: Timestamp, Race, Horse, Bookie Odds, Betfair Odds, Place Term, EV%, Suggested Stake.
---

UI / Dashboard

Minimal GUI:

Start/Stop scanner

Manual refresh

Table view of current +EV bets with sortable columns
---

2️⃣ Technical Requirements

Language: Python 3.x

Libraries:

betfairlightweight (Betfair API)

requests / BeautifulSoup or Selenium (for scraping)

pandas (data handling)

openpyxl (Excel logging)

python-telegram-bot (notifications)


Real-time updates: ideally poll every 1–5 minutes.

Configurable parameters: EV threshold, bankroll size, staking % rules, polling interval.

Robust error handling: API downtime, missing data, scraping errors.



---

3️⃣ Deliverables

1. Python project with clear folder structure and modular code.


2. Fully working scanner + Telegram notifications.


3. Excel logging integrated and verified.


4. Instructions for setup: API keys, Telegram bot, scraping requirements.


5. GUI for manual monitoring.

---

4️⃣ Success Criteria

Accurate calculation of EV and suggested stakes based on Betfair & bookmaker odds.

Real-time notifications for +EV bets.

Reliable logging to Excel for review and backtesting.

Easy configuration of key parameters