The Bookkeeping That Saves the Book: Inside One Trader's Options-on-Futures Spreadsheet

Traders love to talk about entries. Almost nobody talks about the spreadsheet that keeps them from blowing up.

That changed last month when a longtime member of the working group — a trader who runs a short-volatility book in soybean and Treasury options — agreed to share an anonymized copy of his position workbook with the desk. What follows is a cell-by-cell tour of the tool, along with the collective's commentary on where amateur versions of this same spreadsheet tend to come apart.

Tab One: The Position Map

The workbook opens on a tab he calls simply "BOOK." Every contract, strike, expiry, and quantity is laid out in a flat table — no formatting flourishes, no color coding beyond a single red conditional format for positions past his roll date.

The critical column isn't the strike. It's one he labels "UNDERLYING MULT," which converts each option's notional into its futures-equivalent exposure. This is the step most retail spreadsheets skip. An option on an S&P futures contract is not one contract of risk; depending on delta, it might be a third of one or three of them. Without the multiplier column, his view of directional exposure would be fiction.

"If I can't answer 'how many futures am I actually short' in one glance, the spreadsheet has failed," he told us.

The Greeks Snapshot, Taken at the Same Time Every Day

The second tab is a greeks log — but not a live feed. He snapshots delta, gamma, theta, and vega at 8:45 a.m. Central, fifteen minutes before the equity open and after the overnight grain session has settled.

The timestamp matters more than the numbers. Greeks drift intraday, and a book managed against moving targets becomes unmanageable. By fixing the snapshot time, his log becomes comparable day over day. The tab holds two years of rows, and the trend lines — vega creep in particular — have flagged two position adjustments he swears he'd otherwise have missed.

The desk's note: most home-built greeks tabs pull data whenever the trader happens to open the file, which makes the history meaningless. Consistency of measurement beats sophistication of model.

The Roll Calendar

Tab three is a calendar, but not of holidays — of decision dates. Each open position carries three dates: the theoretical roll window, the hard decision date, and the liquidity check date, scheduled roughly ten trading days before expiry.

The liquidity check is the one worth stealing. It's a forced task: pull the option's volume and open interest, compare the bid-ask spread against a threshold he set when the trade was opened, and record the result. If the market has gone quiet, the exit plan changes while there's still time to change it cheaply.

Amateur spreadsheets, in our member's experience, treat expiry as a single event. Professionals treat it as a sequence of decisions with dates attached.

The Stress Grid

The final tab is the one he calls "the honesty test." It's a matrix of scenarios — underlying moves of plus and minus 3, 6, and 10 percent, implied volatility up and down four vol points — with the book's resulting P&L in each cell.

Nothing here is predictive. The grid exists to answer one question before the market asks it: at what point does this position force my hand? Two cells are highlighted, marking scenarios where he has pre-committed to reducing size. Those commitments are written down, dated, and signed — literally — in a notes column.

"A stress test you run after the move isn't a stress test," he said. "It's an obituary."

Where Retail Spreadsheets Go Wrong

The desk compared his workbook against the common failure modes we see in retail tooling:

• No notional conversion. Options counted as contracts rather than delta-adjusted futures exposure, understating risk by multiples.
• Live, inconsistent greeks. Numbers pulled at random times produce a history that can't be compared against itself.
• Expiry treated as one date. No liquidity check, no roll window, no decision framework — just a countdown.
• Stress tests without commitments. Scenarios are modeled, but no pre-decided actions are attached, so the modeling changes nothing.
• Hidden hardcoding. Contract multipliers and tick values typed into formulas rather than a reference tab, so a roll into a different contract silently corrupts the math.

The Unglamorous Truth

None of this is clever. There's no machine learning, no exotic option pricing model, no API plumbing. It's a flat book, a fixed snapshot time, a calendar with teeth, and a grid of bad outcomes with responses written next to them.

That, the desk agrees, is the point. The workbook doesn't make the trader smarter. It makes the trader honest — with himself, on schedule, before the market does it for him. Every trader in the collective keeps some version of this file, and the differences between them matter far less than the discipline they all share: write it down, date it, and look at it when you don't want to.