Let's get one thing out of the way: there's nothing wrong with starting in a spreadsheet. If you're selling covered calls on a couple of positions and tracking premiums in Google Sheets or Excel, that's a perfectly reasonable approach. Spreadsheets are flexible, free, and familiar.
But if you've been at this for a while, you've probably started to feel the cracks. The spreadsheet that worked beautifully for two positions gets weird at five and becomes a part-time job at eight or ten. It's not a matter of if your tracking spreadsheet breaks down — it's when and how.
Here are the specific inflection points where covered call spreadsheets start falling apart, and what to do when you hit them.
Selling a covered call and letting it expire worthless is clean and simple. One row in the spreadsheet: date, ticker, strike, expiration, premium collected. Done.
Rolling is where things get messy. You buy back your $52 call for $1.10 and sell a $53 call two weeks out for $1.40. You netted $0.30 in additional premium, but in your spreadsheet it's two separate transactions: a buy-to-close and a new sell-to-open.
Now your formulas need to handle this. Does the buyback cost reduce the premium for that row, or do you add separate rows for the close and the new open? Either way, the "total premium collected" calculation just got more complicated. Roll again and the formula chain gets longer.
Most spreadsheets handle the first roll fine. By the third roll on the same position, the tracking logic is held together with duct tape and nested IF statements.
At two or three positions, your spreadsheet fits on one screen and makes sense at a glance. At five, you're scrolling. At eight, you're scrolling a lot.
Say you started with INTC and F — four clean rows each. Three months later you've added KO, CSCO, SCHD, WBA, T, and PFE. Each has gone through two or three rounds of calls. INTC had a roll. WBA paid a dividend. KO shares got called away and you restarted the wheel.
Your spreadsheet is now 60+ rows. The "Running Cost Basis" column has formulas referencing cells scattered across a dozen different rows. Adding a new covered call to CSCO means scrolling to find the right section, inserting a row in the middle (which might break formula references), entering the data, and verifying the cost basis formula still works.
This is where errors start creeping in. A missed entry here, a broken formula reference there, and suddenly you're not sure if your INTC cost basis is $45.30 or $44.50. That uncertainty means you can't confidently select your next strike price.
When a covered call gets assigned and your shares are sold, you need to close out the entire position in your spreadsheet. That means:
This is when spreadsheets accumulate cruft. People are reluctant to delete old rows (what if I need that data later?), so closed positions pile up alongside active ones. The signal-to-noise ratio drops. Some people solve this with separate tabs for active vs. closed positions, but then you're flipping between tabs to reconcile data after a mid-cycle assignment.
Here's where it really gets hairy. True cost basis isn't just "share price minus this round of call premiums." If you entered via a cash-secured put, that premium counts. Dividends count. A net debit on a roll increases your cost basis.
Building a spreadsheet formula that correctly computes cost basis across:
...is genuinely hard. It's not a single formula — it's a chain of dependent calculations that has to be replicated and adapted for every position. Most people either simplify (and lose accuracy) or spend more time maintaining formulas than actually analyzing their positions.
At some point, you want to zoom out. How much total premium have you collected this month? This quarter? What's your overall return on capital deployed? Which tickers are your best performers?
Spreadsheets can technically do this with SUMIF formulas and pivot tables. But every new ticker means updating summary formulas, and every structural change to your tracking section risks breaking the aggregations. Traders who maintain elaborate reporting spreadsheets often spend meaningful time each week on maintenance alone — time that could go toward analyzing positions or finding new trades.
When your spreadsheet hits these inflection points, you have two options: build an increasingly complex spreadsheet that demands regular maintenance, or move to a tool designed specifically for this workflow.
MyATMM was built by someone who hit every one of these inflection points and decided to build the tool he wished existed. It handles the entire wheel cycle — puts, assignments, covered calls, rolls, dividends — and automatically computes true cost basis across the full history of each position. Portfolio-level performance comes out of the box, not from fragile SUMIF formulas.
Adding a new trade takes seconds. Rolling a call is a single transaction, not a formula gymnastics exercise. When shares get called away, the position closes cleanly and your data is preserved. AI-powered screenshot import lets you snap a picture of your brokerage confirmation instead of typing everything manually. And a built-in screener covers 550+ weekly-option stocks with 25+ filters for finding new covered call candidates.
If you're running the wheel on two positions and your spreadsheet is working, keep using it. Seriously. Don't fix what isn't broken.
But if you've hit three or more of the inflection points above — if your formulas are getting fragile, if you're not 100% sure your cost basis numbers are right, if adding a new position feels like a chore — it might be time to graduate to something purpose-built. MyATMM has a free tier for up to three tickers with no credit card required, so you can migrate your most active positions and see if it clicks before committing.
MyATMM provides purpose-built cost basis tracking for option sellers, with the flexibility to track covered calls, cash-secured puts, and wheel strategy positions.
Track up to 3 tickers completely free forever. No credit card required.
Create Your Free Account TodayBuilt for covered calls, cash-secured puts, and the wheel strategy