A spreadsheet is a genuinely good options tracker, and anyone telling you otherwise is usually selling an alternative. For a straightforward book it is free, flexible, portable, and you already know how to use it.

It also has four specific failure points, and they arrive in a predictable order. This lesson is about identifying which of them you have hit — because the answer decides whether you need a better spreadsheet or a different tool.

What a spreadsheet does well

For a book of independent, single-leg positions that open and close cleanly, a flat table is the correct data structure. One row per trade, a handful of formula columns, and a pivot table for review. Nothing is missing.

Failure one: rolls turn rows into chains

The first crack. A roll creates a second row that is not an independent trade — it is a continuation. To compute the chain's cumulative P&L you need a parent reference and a formula that walks it.

This is doable with a parent-ID column and a lookup, and plenty of people do it. It is also the point at which the spreadsheet stops being self-explanatory: you now have a recursive relationship encoded in a flat table, and the formula that traverses it is fragile enough to become its own source of error.

Failure two: assignment changes the instrument

The second crack is worse, because it is not just a relationship — it is a type change. Your put row becomes a share lot, and the premium has to follow it as a basis adjustment.

A flat table has no natural way to say “this option credit modifies that share lot’s cost”. People solve it with a second sheet and manual cross-references, which works until a partial assignment splits a lot, at which point the premium has to be allocated proportionally across two rows and the manual bookkeeping becomes genuinely error-prone.

Failure three: current prices

Any figure involving what a position is worth now — unrealised P&L, premium captured, whether you have hit a 50% target — needs live marks. A spreadsheet either gets them from a data function that breaks periodically, or you type them in by hand, which stops happening after a fortnight.

In practice most manual trackers quietly become closed-position archives: excellent history, no live view. That is a legitimate choice, but it means the tracker cannot help you with the decisions in managing winners and losers.

Failure four: several accounts

Two brokers means two exports in two formats. Consolidating them is straightforward the first time and tedious every month after, and concentration across accounts stays invisible until you build the view that shows it.

Making a spreadsheet last longer

If you would rather keep the spreadsheet — a reasonable position — three changes buy a lot of runway:

One row per chain, not per ticket. Update the same row on each roll: cumulative credit, cumulative buybacks, current strike, current expiry, days held. You lose ticket detail and keep the number that matters.

A separate share-lot sheet with a running basis column. Every option credit against those shares posts to it.

Never type a derived value. Dates and prices in; annualised return, duration and capital out, always as formulas.

What can go wrong

Formula drift. A dragged formula that skips one row is invisible and permanent.

Manual price updates. They stop, and then the live columns are quietly stale rather than obviously empty.

Rebuilding it every year. A common pattern, and it loses the multi-year history that made tracking worthwhile.

Switching tools for the wrong reason. If the spreadsheet is working, trade count alone is not a reason to change.