For readers of Your Broker Is Lying to You · 4 spreadsheets · Free
Four spreadsheets. The math, the journal, the drawdown, the audit.
Your Broker Is Lying to You is a Mark Fields field manual about why 70–85% of self-directed retail traders lose money every year. The book is the field manual. The bundle is the operating system — four spreadsheets that turn it into something you actually use.
Open in Excel or Google Sheets. The instruments that turn I should probably track this into actual data.
No email gate. No signup. No upsell. The .xlsx files are free because the math should be free.
Spreadsheet 01
Position Sizing Calculator
The only math in this book.
Enter your account size, your max risk per trade, your entry price, and your stop loss. The spreadsheet calculates your position size automatically. If the number it returns makes you flinch, you have entered the wrong numbers. The flinch is the data.
The spreadsheet does not decide whether to trade. The Playbook does that. This spreadsheet decides how much when the Playbook says yes. That is all it does. That is all it needs to do.
Includes a Read Me tab with full instructions, a Calculator tab for live use, and an Examples tab with three composite scenarios from the book (the man in Turin, the pharmacist in Bologna, the accountant in Verona).
Download .xlsx
Spreadsheet 02
Trade Journal
A trade you do not record is a trade you did not learn from.
Fifteen columns per trade: date open, date close, instrument, direction, setup, entry, stop loss, position size, exit, risk in R, P/L in euros, P/L as percentage of account, holding time in days, lesson learned, and whether you passed the Inaction Checklist. The sheet calculates the P/L, the risk and the holding time for you.
The Stats tab recalculates automatically. Win rate is reported because the signals industry reports it. Profit factor is reported because it matters more. Average win vs average loss is reported because that is the actual edge, if any. Your average R multiple is reported because it tells you whether your stops are honest. The rest is vanity.
The Lesson Learned column is not optional. If you cannot write a sentence there, you have not learned anything, and the trade was a coin flip you will repeat.
Download .xlsx
Spreadsheet 03
Drawdown Tracker
The number on the screen is your enemy. The number you remember is your friend.
Track every day’s starting and ending equity. Calculates the running drawdown from your peak. Does not lie. Does not tell you that -3% is fine because next week will be different. Tells you that -3% is -3%.
Conditional formatting: green is fine, yellow is approaching, red is breached. The rules are hard-coded: 2% daily loss = stop trading today. 5% weekly loss = stop trading this week. 20% max drawdown = stop trading for 30 days, full stop, no negotiation.
The rules are not negotiable. The rules exist because the alternative is you, at 2 a.m., opening a position to make back what you lost. That is how the man in Turin ended up at €11,400 from €30,000.
Download .xlsx
Spreadsheet 04
Risk Audit
Seven questions. Each one a yes or a no. At the end, a verdict.
Did you check the Inaction Checklist? Did you calculate position size via the formula? Do you have a stop loss before entry? Are you within your daily loss limit? Within your weekly limit? Within your max drawdown? Have you traded this setup before?
Seven yes/no questions. Total time to answer: two minutes. The cost of skipping it: the rest of your trading account.
The verdict is not a suggestion. The verdict is what the Playbook of the book requires. Four of the seven questions are vetoes, not votes: fail the Inaction Checklist or any of your three limits and the answer is stop, whatever the score. Score 5 or higher: you have earned the right to trade today. Score 3 to 4: caution. Score below 3: stop. The spreadsheet will tell you in plain English which question brought you down.
Download .xlsx
How to use the spreadsheets
They are not four documents. They are one loop, and it runs in this order.
01 · Position Sizing Calculator — the math. Before any trade: how much. Account size, risk per trade, entry, stop. The sheet does not decide whether to trade; it decides how much when you have already decided.
02 · Trade Journal — the memory. After every trade: what you did, what it cost, what you learned. The Lesson Learned column is not optional. This is the file you will still be using in two years; the others only matter while you are active.
03 · Drawdown Tracker — the scoreboard. Once a day: your starting and ending equity, and the drawdown from your peak. It calculates the three limits for you and turns red when you breach one.
04 · Risk Audit — the gate. Before every trade: seven questions, two minutes. Four of them are vetoes — fail the Inaction Checklist or any of your three limits and the answer is stop, whatever the score. This is the only one of the four you open while a position is on.
The order that matters is the loop: Audit before the trade, Journal after it, Drawdown every day, and the Calculator whenever you need to size a position. Read the Read Me tab of each one first. They are written for someone who has never opened a spreadsheet before.
If you have read the book, you will recognise the composite scenarios from the Examples tab. They are the man in Turin, the pharmacist in Bologna, and the accountant in Verona. The spreadsheets are calibrated for all three. They are calibrated for you, too, whether you are one of them or you are someone who has not yet opened a brokerage account.
You are statistically the loser. The spreadsheets will not change that. They will help you lose less, slowly, until one day you realise you are not losing any more. That day, you can put them down.