Formdial Bet Log — Excel Edition

Description

The professional punter’s ledger, built in Excel

A seriously engineered bet-tracking workbook in the Formdial style. Log each bet in a few quick cells and the sheet settles it for you — wins, each-way returns at your terms (1/4, 1/5 or 1/2 odds), place-only bets, Rule 4 deductions, dead-heats and voids — with your running bank updating on every row. Enter the price however it’s quoted: decimal (3.75) or fractional (11/4, Evs) both settle correctly. The maths is verified to the penny against the same engine that powers the Formdial Ledger.

Stake in points or pounds

Keep your book in points or in £ — one switch flips every label across the workbook and the maths is identical either way. Set your own staking plan (a classic 1 / 2 / 5-point ladder comes ready) and pick your stake from a dropdown, or type a one-off.

Smart dropdowns that know the racing

Choose a country and code and the workbook narrows the tracks, trainers and jockeys to match — pick IRE + AW and you get Dundalk and Laytown, not the whole list. Every GB and Irish course seeded, plus the major French and US tracks; all lists editable, and you can always just type. A gentle red flag reminds you if you start a row and leave the country, track or code blank.

A living equity curve & full analytics

Total P/L, ROI, strike rate, a Beat-BSP gauge (the closing-line-value metric the pros judge themselves on) and a growing equity curve that rolls with your latest bet — 12, 18 or 24 months, your choice. Beyond the dashboard, four analysis sheets read your whole log live: Analytics splits every factor (bet type, stake, day, code, country, class, distance, race type); Courses maps your record at every track, Flat / AW / NH; Trainers and Jockeys keep a book of the names you back, best and worst five ranked by P/L, automatically.

Built to be lived in

Formula cells are protected so a stray keystroke can’t break the maths (no password — it’s your file). Works in Excel 2010 or newer and LibreOffice.

What you get

• The Formdial Bet Log workbook (.xlsx), yours forever — no subscription
• A second, fully-worked example workbook — 1,000+ settled bets to explore before you start your own
• Start Here guide, editable lists, instant download after checkout, and re-download the latest version anytime from your account

Prefer it automatic? The hosted Formdial Ledger is the same idea as a private web app — and this workbook’s columns match its import format, so you can upgrade later without retyping a single bet.

18+. A record-keeping tool — no tips, no bets placed. Please gamble responsibly.