Trades
One row per option trade: ticker, CSP or CC, strike, premium, dates and status. Collateral, net P/L, days held and annualized return calculate themselves.
Free download · Excel, Google Sheets, Numbers
The free wheel strategy spreadsheet that grows into a tracker
Log every put and call you sell. The sheet adds up your premium, profit, win rate and annualized return by itself. No sign-up, no email needed.
100 kB · 500 trade rows · 3 tabs
| Ticker | Type | Strike | Premium | Status | Net P/L |
|---|---|---|---|---|---|
| KO | CSP | 70.00 | 0.95 | expired | $94.35 |
| KO | CSP | 70.00 | 1.10 | assigned | $109.35 |
| KO | CC | 72.00 | 0.80 | open | — |
| AMD | CSP | 150.00 | 3.40 | closed | $218.70 |
| AMD | CSP | 145.00 | 3.10 | open | — |
Realized P/L $422.40Win rate 100%
Price
$0
Free, no account
Trade rows
500
Formulas pre-filled
Tabs
3
Trades, summary, guide
Move to YieldCove
1 click
Columns already match
01
What's inside
Three tabs. You only type in the white columns.
Wheel summary
Premium collected, realized P/L, win rate, capital at work and a weighted annualized return, plus a per-ticker table and premium by month.
How to use
Plain-English instructions: what each status means, how to record a roll, and how to bring the file into YieldCove.
02
How the numbers work
The same rules YieldCove uses.
- Expired
- The option expired worthless: you keep the whole premium, minus the opening fee.
- Closed early
- You bought it back: premium minus the buy-back price, minus both fees.
- Assigned
- You keep the premium and now own (or deliver) the shares. Log the covered call on a new row.
- Annualized, weighted
- Total profit divided by capital × days at risk, times 365. A big, long trade counts more than a tiny, short one.
03
Outgrow it in one click
When the sheet gets long, keep your history.
- Create a free YieldCove account.
- Open Positions → Import and choose this file. The columns already match, French or English.
- Your trades become a live tracker: prices, assignment cost basis, roll chains and Canadian ACB.
Using Google Sheets? File → Import → Upload, then pick the .xlsx. To import into YieldCove later, download it back as .xlsx.
Import my spreadsheet free04
Want it in your inbox?
Optional. The download above works without it.
05
Plan the next trade
Free calculators for the rows you are about to add.
Cash-secured put calculatorPremium, breakeven, collateral and annualized return for the put you are about to sell.Covered call calculatorPremium, breakeven and capped profit for a call sold against shares you own, whether it expires or the shares are called away.Probability calculatorThe odds a strike finishes in the money, from the option's implied volatility.Ex-dividend date guideWhen a dividend can get your covered call assigned early, with a worked example.
06
Common questions
What the numbers mean — and what they leave out.
- Is the wheel spreadsheet really free?
- Yes. Download it, use it and share it. No account and no email are required.
- Does it work in Google Sheets and Apple Numbers?
- Yes. Upload the .xlsx to Google Sheets (File → Import) or open it in Numbers. The formulas, dropdowns and colours carry over.
- How do I record a roll?
- Mark the old contract as closed with its buy-back price, then add the new contract on a new row. Each leg keeps its own profit.
- Can I import it into YieldCove later?
- Yes. In YieldCove, open Positions → Import and pick the file. Example rows can be unticked in the preview.