Companion files
A Practitioner’s Guide to Pricing, Hedging, and Where the Money Actually Comes From
These are the companion files of Quantitative Finance by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, corrected where they were wrong. Every figure the book prints is reproduced in them by a live formula rather than a typed constant, and each workbook ends with a Checks sheet setting the printed figure beside the computed one: 84 controls in all, every one green. Around them: the same four models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Twelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula, and each closes on its checks sheet. Download these four88 KB
Chapters 2, 4, 5 and 6
The closed form built from d1 and d2 with every intermediate on its own row, so the price of 11.454068 can be read as a construction rather than taken as an output. Put by parity, the zero-volatility floor and the break-even daily move sit beside it as identities that must hold.
The lattice is the sheet worth opening first. It is computed from the binomial distribution rather than by laying out a tree, which means a thousand-step price is a single formula and the entire convergence table — 10 steps at 11.220175 through 1000 at 11.451696 — recomputes when you change the volatility, the strike or the maturity. The oscillation as the step count crosses the strike is visible rather than described, and the halving of the error with each doubling of steps is a computed column. The simulation results are the runs reported in the book; what is live beside them is the standard error, which is the quantity that decides whether the number can be trusted at all. Revised: the error-halving column and the three identities beside the price, described here before they were in the file, are now in it, and each simulated price is shown in standard errors from the closed form: all four runs land below it, the million-path run by 1.71.
Download the workbook18 KBChapter 8
All five Greeks from their formulas — delta 0.612816, gamma 0.015953, vega 0.382882 per point, theta −0.018048 per day, rho 0.498276 — and beside each of them a finite-difference estimate computed from the pricing function itself, with the step size as an input.
That second column is the point of the workbook. Shrink the step and the numerical estimate converges on the analytic one; shrink it further and it starts to disagree again, for reasons of floating-point cancellation rather than of finance. Seeing where the agreement breaks is the fastest way to understand what a Greek reported by somebody else’s system is actually worth — and the sheet also converts each sensitivity into what it means on ten thousand contracts, which is the form in which it reaches a risk report.
Revised: the finite-difference delta and vega read −4,980.55 and −4,982.83, not 0.612816 and 0.382882: a missing bracket subtracted the strike term of the lower price instead of adding it. Both now agree with the analytic value to the sixth decimal, rho has its own finite difference, and each step is an input. The break-even move against theta net of financing is exactly 1.2562; against raw theta it is 1.5042.
Download the workbook15 KBChapters 9, 16 and 17
The input against the model, on one sheet. Eight points of volatility are worth 3.061643, or 26.7 per cent of the price; the three models disagree by 0.029701, or 0.2593 per cent; and the ratio between them — 103 times — is computed rather than quoted, so it can be recomputed on whatever instrument you type in. On a short-dated far out-of-the-money option it is a different number, and the sheet will tell you what it is.
Vega is shown across strikes and maturities so that its non-constancy is obvious, and implied volatility is solved by iteration from a price you enter. The last sheet is the afternoon of tests from Chapter 17 — parity, monotonicity, the boundary cases, the zero-volatility limit, the deep-in-the-money limit — each with a PASS or a FAIL, ready to be pointed at a pricing library you did not write and do not trust.
Revised: the implied-volatility iteration returned −227 per cent and a price of −70.98 for a quote of 12.50, from the same missing bracket; six passes of Newton’s method now reach 26.7302 per cent and reproduce the quote. Vega across strikes and maturities is on its own sheet, and peaks at a strike of 107.12 at one year, not at the money.
Download the workbook20 KBChapters 12, 13, 14 and 15
The delta hedge laid out period by period on a single path: the share position, the cash account, the financing, the rebalancing trade and the running profit, so the mechanics are visible before the statistics arrive. Change the drift — the direction of the stock — and watch the profit at expiry barely move. Change the realised volatility by two points and watch it move a great deal. That is Chapter 13 in two keystrokes.
Across many paths the trade pays 1.5981 when realised volatility is 20 per cent, 0.0004 when it is 24, and −1.6022 when it is 28, against an analytic approximation of ±1.5315 that the sheet shows beside them rather than in place of them. And when you are exactly right, the dispersion that remains — 2.3031 at twelve rebalances, 0.5265 at 252 — is what a delta-hedged book actually owns. The square-root rule predicts a fall of 4.58 and the measurement gives 4.37; the gap is shown, with the reason, rather than smoothed away. Revised: the rebalancing count worked only at 52, and the table now runs to any count from 1 to 252; and the shortfall is 85 per cent in the step from monthly to weekly, not all of it, since weekly to daily falls short too, 2.1865 against 2.2014.
Download the workbook49 KBThe four workbooks with their 51 inputs emptied. The checks sheets count what is still missing and test what holds for any inputs.
All chapters
The three models, the sensitivities, volatility and the price, and the hedging simulator, with the same formulas and every input emptied: the option on the Inputs sheet, and the simulation runs a spreadsheet cannot produce, the four priced runs and the means and dispersions over many hedged paths. The lattice step counts, the volatility ladder, the vega grid and the finite-difference steps stay, because they are the axes of their tables or a method, not data.
The book’s 51 inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 11.454068 for the price, 0.029701 across the three models, 4.37 against the rule’s 4.58.
Download the blank set74 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 17
The pricing record, six inputs and the one nobody can observe, with Kestrel 100 beside a blank column. The closed form built on one page, with its three identities. The lattice convergence log. The simulation run report, with the standard error beside every price. The model comparison memo, noise taken out. The Greeks report with a second path to each. The risk report line, the lot in currency. The volatility note. The library acceptance tests. The hedge log, period by period. What the trade paid, and why. The rebalancing policy. The desk report line, with the questions to ask of it.
Download the PDF30 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the three models, seven on the sensitivities, seven on volatility and the price, six on the hedge and what it pays, seven on discrete hedging, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 4, 5 and 7 · Case one
Chapter 7 measures the three models 0.029701 apart; chapter 5 says the standard error decides whether a simulated number can be trusted. Put together: the lattice sits 0.002372 from the closed form, and the whole spread is the million-path run, 1.71 of its own standard errors low. On the models’ own disagreement the input outweighs the model 1,291 times, not 103. Pooled, the book’s four runs sit 2.36 standard errors low (if independent: ADDED), which is a question to put to whoever ran them.
Chapters 13 and 14 · Case two
Chapter 13 prices the edge, chapter 14 the residue; they never meet. Sold at 24 and realised at 22 (ADDED), hedged weekly, the trade expects 0.765765 an option and loses in 25.3 per cent of years. On the book’s own four-point edge, hedged monthly, it loses in 24.4 per cent. Keeping losing years to one in ten (ADDED) on a two-point edge takes 196 rebalances a year.
Chapter 14 · Case three
Chapter 14 gives the two-thirds-power rule and leaves the answer to the desk. At 15.00 a rebalance on the lot and a charge of 0.20 a unit of residue (both ADDED), the optimum is 67.71 a year, 3,047 in all. Weekly costs 1.7 per cent more, daily 58.6 per cent more; half or twice the optimal count costs 10.9 and 13.8 per cent more. The price of residue matters more than the argument over daily against weekly.
Download the three cases34 KB| Blue text | a hardcoded input — you may edit these |
| Yellow fill | an input cell; everything else on the sheet is a formula |
| Black text | a formula — do not overtype these |
| Checks sheet | the printed figure beside the computed one, with a PASS or a FAIL; in the blank set and the cases, each control states its own verdict and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
A workbook that agrees with a book proves nothing on its own — the author wrote both. What the Checks sheets do is different: they force the model to reproduce a number that was printed before the model existed, from a formula rather than from the number itself.
On this book the checks caught two things a reader would never have seen. The lattice was rebuilt from the binomial distribution because a laid-out tree cannot reach a thousand steps in a spreadsheet, and the closed form had to reproduce all seven printed convergence prices to six decimal places before it could be trusted. And gamma, vega and theta came out wrong at first because a defined name for the normal density collided with the one for the cumulative distribution — spreadsheet names are case-insensitive, and the check sheet was the only thing that noticed.
What a spreadsheet cannot do is stated rather than hidden: a million simulated paths and twenty thousand hedged paths do not fit in one, so those results are the runs reported in the book. What is computed live beside them is the quantity that decides whether they can be trusted.
Quantitative Finance develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The four workbooks corrected, 84 checks. The finite-difference delta and vega read −4,980.55 and −4,982.83, not 0.612816 and 0.382882, from a missing bracket; the implied volatility of a 12.50 quote read −227 per cent, not 26.7302; the hedging simulator worked only at 52 rebalances; the square-root rule’s shortfall is 85 per cent in the first step, not all of it. The error-halving column, the identities beside the price and vega across strikes and maturities, described on this page, are now in the files. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in corporate finance, with free companion files. The full list of titles is on the author page.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.
Also available as a standalone free template: black-Scholes and binomial option pricing.