Wheel Strategy Spreadsheet: Free Google Sheets Options Tracker Template

If you run the wheel strategy regularly, a spreadsheet quickly becomes more than a nice-to-have. You need one place to track cash-secured puts, covered calls, assignments, rolling decisions, premium collected, and the real return on the capital you are tying up.

This guide walks through a practical wheel strategy spreadsheet you can use in Google Sheets to manage your trades, review your process, and stay organized over time. It also includes a free Google Sheets options tracker template you can copy and start using right away.

Get the template: Free Wheel Strategy Options Tracker v1

What this wheel strategy spreadsheet helps you track

A strong wheel strategy spreadsheet should help you answer a few questions fast: what positions are open, how much premium you have actually collected, which tickers are producing the best results, when rolls improved a trade, and whether assignments are helping or hurting your process.

That is the difference between a spreadsheet that simply stores trades and one that actually improves decision-making.

Who this free Google Sheets options tracker is for

• Wheel traders selling cash-secured puts and covered calls across multiple tickers
• Anyone who wants a cleaner way to track assignments, rolls, and adjusted basis
• Traders who prefer using a Google Sheets options tracker before moving to a dedicated tool
• Investors who want to review trade decisions, not just raw P&L

Quick start: how to use the spreadsheet

1. Open the template and make your own copy in Google Sheets.
2. Add the tickers you actively trade or monitor.
3. Log every new cash-secured put or covered call in the trade log.
4. Record rolls, assignments, closes, and stock sales as separate events.
5. Review the summary tab weekly to spot mistakes and improve your process.

If you only make one improvement to your current trade tracking, make it this one: write down why you opened the trade. That note becomes more useful than the final profit number when you review the position later.

Motivation: Why Meticulous Tracking is Crucial

The options market, with its inherent complexities, demands more than just a basic understanding of strategies. A recent study by the Options Clearing Corporation (OCC) revealed that a significant portion of options traders fail to consistently track their trades, leaving potential profits and useful insights on the table.

You're already familiar with the Wheel Strategy, but are you truly mastering your portfolio? For the serious options trader, simply knowing that you made a profit is not enough. You need to know why, how, and how to repeat or avoid past outcomes. That is where meticulous trade tracking comes in.

You can build your own process from scratch by learning how to create a solid tracker and by using the right formulas with this Google Sheets formula guide for options tracking. But if you want a faster path, this article gives you a ready-made template and a practical structure you can use immediately.

Get the free Google Sheets template: Free Wheel Strategy Options Tracker v1

Note:

• Instructions on how to make a copy are provided towards the bottom of this article. Follow along below and use the tracker as you go.
• The template is populated with mock data to get you started. You can delete the sample data once you get going.
• Disclaimer: This template is provided for informational purposes only and does not constitute financial advice. Trading options and tracking them involves risk and complexity. Feel free to adapt this tool to your needs, but understand the formulas and their limitations.

Organizing Your Options Tracking: A Multi-Sheet Approach

Forget messy spreadsheets crammed onto a single page. A professional wheel strategy spreadsheet works best as a multi-sheet system, with each tab serving a distinct purpose.

The template includes five core sections:

• The Stock Watchlist
• The Trade Log
• Performance Summary
• Owned Shares - Managing Your Assignments
• KPI Dashboard

Sheet 1: The Stock Watchlist - Your Potential Universe

This is your pre-trade scouting report. Before you even think about selling an option, you need to identify suitable candidates.

Your watchlist should include:

• Fundamental Analysis Scores: Rate stocks based on financial health, industry leadership, and growth prospects. Don't just rely on gut feeling; develop a quantifiable scoring system.
• Volatility Metrics: Track Implied Volatility (IV) Rank, IV Percentile, and Historical Volatility (HV). This is where you identify opportunities for premium selling.
• Actionable Triggers: Use a dropdown menu to categorize stocks such as Monitor, Consider CSP, Consider CC, or Avoid.
• Notes: Keep tabs on earnings calls, ex-dividend dates, and your own analysis on the stock.

And to make things easier, the Company Name and Current Price can be dynamically populated using Google Finance based on the ticker you enter.

Sheet 2: The Trade Log - Your Source of Truth

This is the heart of your tracking system. Every single trade detail goes here, meticulously recorded. No exceptions. Think of it as your trading journal, where you document not just what happened, but why.

Key columns include:

• Date, Ticker, Option Type (CSP/CC), Action (Open/Close/Rollover/Assignment): The basics.
• Strike Price, Expiration Date, Contracts: Essential position data.
• Premium (per contract and total): Track both gross and net premium after commissions.
• Underlying Price (at Open and Close): Useful for analyzing trade timing and entry quality.
• Outcome: Categorize each trade, for example Win, Assigned, Rolled, or Closed at Loss.
• Notes: This is where your qualitative analysis goes. Why did you make the trade? What was your rationale? What did you learn?

And to make things easier, Total Premium and Net Premium can be auto-calculated.

Sheet 3: Performance Summary - Your Financial Dashboard

This sheet transforms your raw trade data into actionable insights. It's where you see the big picture, track progress, and identify areas for improvement.

A useful summary sheet should include total premium, total fees, win rate, average premium per trade, assignment count, and capital deployed by ticker. Weekly review is usually enough for most traders.

Sheet 4: Owned Shares - Managing Your Assignments

If you're actively running the Wheel Strategy, you will get assigned shares at some point. This sheet helps you manage those shares and track your cost basis, unrealized gains and losses, and your plan for those shares going forward.

And to make things easier, Total Cost Basis, Current Price, Current Value, and Unrealized P/L can all be auto-calculated.

Sheet 5: Key Performance Indicators (KPIs) Dashboard

And finally, your KPI dashboard. This should stay practical, not decorative. It is there to help you make decisions faster.

Metrics worth tracking include:

• Total Net Premium Earned: The bottom line.
• Total Commission Paid: The hidden cost of trading.
• Number of Trades, Winning Trades, and Losing Trades: Measures activity and success rate.
• Win Rate: A key measure of strategy effectiveness.
• Average Net Premium per Trade: Shows whether you rely on a few big wins or a consistent process.
• Return on Capital (RoC): A useful metric for comparing trade efficiency over time.

Common mistakes when using a wheel strategy spreadsheet

Not separating rolls from original trades

A roll is a new decision, not just a continuation. Log it clearly so you can review whether the adjustment helped or simply delayed a poor outcome.

Ignoring fees and slippage

Small costs add up quickly, especially if you use shorter-duration options. If your spreadsheet ignores them, your strategy may look better than it really is.

Failing to track adjusted basis after assignment

Once assignment happens, the wheel becomes more than premium collection. You need to know your real basis after collected premium, not just the assignment price in isolation.

Tracking what happened, but not why

Your spreadsheet should capture your reasoning, not just outcomes. Otherwise, review becomes mechanical and you miss the patterns that actually improve your process.

Advanced Considerations for the Serious Trader

• Time Decay Tracking: Add notes on how quickly theta is working in your favor, especially near expiration.
• Rolling Strategy: Document your rolling decisions and whether the adjustment actually improved the trade.
• Risk Management Parameters: Define position size and acceptable risk before entry.
• Paper Trading: Consider a field that marks whether a trade was real or simulated so you can compare process quality.

Putting it All Together: Free Wheel Strategy Options Tracker v1

To help you implement this workflow, I've created a detailed Google Sheet template you can access here: Free Wheel Strategy Options Tracker v1. Make sure you go through the Read Me FIRST tab.

To use the spreadsheet for yourself, follow these simple steps:

1. Open the link in your browser.
2. Sign in to your Google account.
3. If you do not have a Google account, you can download the file from the File menu as Microsoft Excel.
4. If you are signed into Google, click File and then Make a copy.
5. Start entering your data and building your own review process.

Fine-Tuning Your Approach: Continuous Improvement

Tracking your trades isn't a one-time setup. It is an ongoing process. Regularly review your Performance Summary. Look for patterns. Are you consistently making the same mistakes? Are certain stocks more profitable than others? Use this data to refine your strategy and improve your results. The goal is not just to track, but to learn.

Consider pairing this tracker with our wheel strategy screener. The screener helps you find trade candidates, while the spreadsheet helps you track execution, assignments, and performance over time.

FAQ: Wheel Strategy Spreadsheet and Google Sheets Options Tracker

What is a wheel strategy spreadsheet?

A wheel strategy spreadsheet is a trade-tracking sheet used to log cash-secured puts, covered calls, assignments, premium collected, cost basis, and rolling decisions. It helps traders review results and improve consistency over time.

What should a Google Sheets options tracker include?

A useful Google Sheets options tracker should include a watchlist, trade log, performance summary, assignment tracker, and KPI dashboard. It should also include notes so you can review why trades were opened, not just how they ended.

Can I track covered calls and cash-secured puts in the same spreadsheet?

Yes. In fact, a good wheel strategy spreadsheet should track both. The wheel strategy depends on moving between cash-secured puts and covered calls, so both trade types belong in the same workflow.

Why track assignments separately?

Assignments change the nature of the trade. Once shares are assigned, you need to track adjusted cost basis, unrealized P&L, and your covered call plan. Keeping assignments separate makes the spreadsheet much more useful.

Is a spreadsheet enough, or do I need a screener too?

A spreadsheet is excellent for tracking and review. A screener is helpful for sourcing new trades. Many traders use both: the screener to find candidates and the spreadsheet to track execution, assignments, and lessons learned.

Key Takeaways

• A wheel strategy spreadsheet helps you track cash-secured puts, covered calls, assignments, and adjusted basis in one place.
• A multi-sheet Google Sheets options tracker is easier to manage than a single overloaded tab.
• The most useful trackers record not only what happened, but why the trade was opened in the first place.
• Tracking assignments, fees, and rolls properly gives you a far more accurate picture of performance.
• A spreadsheet works best when paired with a repeatable review process and, ideally, a strong idea-sourcing workflow.

Tell us in the comments if you found this useful. We are open to suggestions for making this better.

This blog post is for informational purposes only and should not be considered financial advice. Trading options involves risk of loss. Conduct thorough research and consult with a qualified financial advisor before making any investment decisions.

Follow us on:

Threads | X (Twitter) | Reddit | Instagram