Skip to main content

Options Trades PRO

The Options Trades sheet is your options trading tracker in Google Sheets™, one row per option strategy: what it puts at risk, what it can make, where it breaks even, and how it is performing. A covered call, an iron condor or a whole wheel campaign reads as a single line, however many legs, rolls and adjustments it went through.

The sheet is rebuilt every time you run Generate Trades. P&L, days held, DTE and status stay live between runs; everything else reflects your transactions as of the last run. Apart from the Strategy and Notes columns, don't edit it — your changes will be overwritten.

Grouping legs into one strategy with a Trade ID​

A strategy is every row you tag with the same Trade ID on the Transactions sheet. Use any id you like (e.g. TSLA-IC-OCT) and put it on:

  • every option leg of the strategy, including the legs you open later to roll or adjust it, and
  • any shares bought or sold as part of it — the shares of a covered call, or the shares of a wheel when you record the assignment as a stock buy.

Shares you want a strategy's options to protect, or whose P&L should count on its row, must carry its Trade ID.

An option without a Trade ID still gets its own row: one per contract and opening day, with an id like TSLA271217C00300000-20260301. Shares an untagged option is assigned into belong to your portfolio, not to the option's row. So a wheel (cash-secured put → assigned → covered call → called away) only reads as one strategy when every row carries the same Trade ID; untagged, the put and the call are two separate rows.

Both ways of recording an assignment work and give the same numbers: the assigned / exercise op, or a close at 0 plus a tagged share row at the strike. All legs of a strategy must be in the same currency — Generate Trades stops with an error naming the trade otherwise.

Columns​

ColumnDescription
Trade IDThe Trade ID of the strategy, or the generated id of an untagged option.
UnderlyingThe underlying ticker. Several are joined with " / ".
Status"Open", "Closed", or "Expired, regenerate" when an open leg has expired since the last Generate Trades.
StrategyYours to fill. Pick the strategy from the dropdown, whose names come from the Option Strategies list on the Configuration sheet — add your own there. Your choice is kept every time the sheet is rebuilt.
ShapeThe open legs as a trader reads them, e.g. -2 P220 / +2 C300 / -1 C310 09Oct26: quantity with its sign (+ long, − short), put or call and strike, the expiry when several are open, the underlying when the strategy has several. Once closed, every contract the strategy traded.
CurrencyThe currency of the strategy's legs.
Capital at riskThe most the position can lose at its nearest expiry; when shares from your portfolio cover a short call, the capital the strategy ties up. See Capital at risk. Shows "Unlimited" for an uncovered short call.
CoverageFor strategies with short calls: "Covered (contracts)" (by long calls), "Covered (shares)" (by the strategy's own shares, or by shares you hold without its Trade ID) or "Naked". Blank when the strategy never had a short call. Portfolio shares cover the call but stay off the row: their P&L isn't in it.
Max profitThe most the strategy's own legs can end up making: what is already realized plus the best outcome of the open legs at the nearest expiry. Portfolio shares never count. "Unlimited" for uncapped upside; blank when it can't be known at that expiry (a calendar or diagonal, whose later long leg's time value decides).
BreakevensThe stock price(s) at which the row's Total P&L crosses zero at the nearest expiry, e.g. 451 or 123.84 / 496.16. A short call's breakeven is above its strike, a short put's below, and a straddle has one on each side. Only the strategy's own legs count, never portfolio shares. Blank when the strategy spans several underlyings.
Open date / Close dateWhen the first leg opened and when the last one closed (blank while open).
Days heldDays since the open date (to the close date once closed).
Next expiry / DTEThe earliest upcoming expiry among the open option legs, and the days left until it. Moves on to the next expiry by itself.
SizeHow many units of the structure you opened: 1 for one iron condor, 2 when you opened (or later added) a second identical one. An unevenly adjusted position reads 1 — Shape shows why.
Initial premiumThe cash the structure brought in (positive, a credit) or cost (negative, a debit) when opened. Legs added later count; the new legs of a roll don't.
Credit / DebitWhether the initial premium was a credit or a debit.
LegsThe number of different contracts open today — a quick check that you tagged every leg. Once closed, every contract the strategy traded.
Realized P&LP&L of the closed legs, fees included.
Unrealized P&LLive P&L of the open legs at current prices.
Total P&LRealized + unrealized.
Realized / Unrealized / Total P&L (base currency)The same three figures in your base currency (the column shows its code, e.g. "Total P&L (EUR)").
Capital at risk (base currency)Capital at risk converted at the exchange rate of the day the capital was committed, not today's rate. Equal to Capital at risk when the strategy is in your base currency.
ROI / ROI (base currency)Total P&L ÷ capital at risk. For a call covered by portfolio shares, this is a yield on the capital tied up, like a cash-secured put. Blank when capital at risk is "Unlimited".
Return on premiumTotal P&L ÷ the initial premium (as a positive amount).
% of max profitTotal P&L ÷ max profit — how much of the possible gain you have captured. Blank when max profit is "Unlimited" or blank.
Net credit after rollsWhat the option legs brought in net: every roll's buy-back is charged, while a final close or an assignment leaves the credit as collected.
Annualized ROIROI × 365 ÷ days held (simple, not compounded).
RollsHow many times the strategy was rolled: a day on which an option leg closes (or expires) and a new leg of the same type and side (e.g. short put → short put) opens.
NotesYours to fill. Starts with the notes of the strategy's Transactions rows; your own text is kept, and clearing the cell brings the default back.

Capital at risk​

Capital at risk is the most the position on the books can lose at its nearest expiry. It is recalculated every day you open something (a new leg, a roll, more shares) and never lowered on a day you only close legs — taking profit doesn't hand capital back. It excludes fees; all the P&L columns include them.

Short calls are covered first by the strategy's own long calls and shares, then by shares of the same underlying you hold in your portfolio without a Trade ID (in any account); portfolio shares go to the earliest-opened strategy first. Portfolio shares count as plain collateral: the amount they tie up at the call's strike, less the strategy's net credit. The strategy's own options can't hedge them, since they aren't on the row. A short call left without cover makes capital at risk "Unlimited".

For example, holding shares without a Trade ID, you sell a 400 call at 12, buy it back at 15 (−300), then sell a 440 call at 14 (+1,400). Capital at risk is 42,600 (44,000 tied up at 440, less the 1,400 credit), max profit 1,100, and the breakeven 451 (440 + 14 − 3): above it, the row loses money. Sell a 440 call at 14 and buy a 400 put at 10 against untagged shares, and capital at risk is 43,600 (44,000 − 400) — the put can't protect shares outside the row. Tag the shares with the same Trade ID to make it a real collar (capital at risk 3,600).

A hedge counts for as long as it exists. On a calendar or diagonal, capital at risk is the spread width while the long leg is alive; if the long leg expires while the short is still open, the figure jumps and stays there. Shares you tag into a strategy after its options closed become part of that strategy's capital at risk.

After an option expires​

The P&L of an expired leg is already right (it is priced at 0), but the row shows Status "Expired, regenerate" until you run Generate Trades again, which closes the leg, sets the close date and settles coverage. A conditional format on that text makes these rows easy to spot.

Exercised and assigned options

On Options Trades, an exercised or assigned option closes at 0 and keeps its premium as P&L, and the shares are booked at the strike — the way your broker shows it. The Trades sheet keeps the tax treatment instead, folding the premium into the share cost basis. The totals agree; only the split between the option and the shares differs.

Keep the sheet intact​

  • Keep the header row in its original order, and keep the Trade ID column formatted as plain text (otherwise an id like 01 turns into 1 and loses its Strategy and Notes).
  • Don't add anything below the table.
  • The hidden OptionLegs sheet holds one row per leg and feeds the live columns. Don't edit or sort it.

Dates follow your spreadsheet's calendar days, whatever its timezone.