Options Wheel Strategy Spreadsheet DEMO v2024 - Excel & Google Sheets

In this video, I will explain and demonstrate how to use the customised spreadsheet I have created to track the options wheel strategy.
A good and correct tracker is paramount in options trading in general, because it will allow us to become more precise, correct and quicker in our decision-making when applying the option wheel strategy.
The spreadsheet provides at all times an up-to date overview of my realised net profit, my cash balance, my realised stock profit, my realised options profit, my unallocated cash, cost basis and many more parameters, to track my options wheel strategy for a specific stock I trade.

This spreadsheet, available for Microsoft Excel and for Google Sheets, can track selling cash secured puts, covered calls and the buying and selling of shares with complete tracking dashboard with net results cash balance, return on capital and more.

but here are basic steps to the wheel strategy:
1) Sell cash-secured puts
3) When assigned, buy the shares
4) While holding the shares, sell covered calls
5) When assigned, sell the shares
6) Rinse and repeat

You can buy the spreadsheet also in our Etsy Shop for less than the price of one positive option trade.

I hope this video will have helped you understand the options wheel strategy and the use of the customised spreadsheet. If you've got any questions, just comment it below and I'll be happy to help.

-------------------------------------------------------------
Disclaimer: I am not a financial planner and am not offering investment advice. This is an opinion channel only and should not be taken as any form of financial advice. There are financial risks involved in taking on any monetary transaction that I discuss in my videos.

#options #tradingstrategy #optionselling #optionstrading

[aattville]

I am going to purchase this week and start I will will have several positions to start with I typically just do one week out build my shares I call it the Wealth Wheel

[vnnn]

Hello Kurt, I am impressed by the clarity and simplicity of the sheet, but I have a question about further automation: how can I ensure that during assignment the shares with the purchase price (strike) and number (put number * 100) automatically end up in the designated line ? That should be able to happen at the moment when I switch from Open to Assigned?

[Kevin-tpse]

Curt, can you explain how to enter a ‘roll’ into the spreadsheet? Two legs need to be entered a buy and a sell but closing parameter cells do not turn red when roll is selected in the drop down. Thanks

[kevinjohnson]

Hi there. I have just downloaded the spreadsheet and yes its great. However I have a question as to why my account balance doesn't change in the quick stats when I have closed out my trades. Thanks

[DarkXagami]

How do we use this for multiple stocks? Do we create a new sheet for each? That is what I have been doing but how do you get it to calculate the Unallocated Cash and Cash Balance across multiple sheets?

[danmurray]

Title states "Excel & Google Sheets", but I only see a Google Sheets file. Is there a true/pure Excel version? I know from experience that Google Sheets has multiple financial functions that are not available in Excel. I've been able to mimic/replicate some of those (haven't tied to do all of them... not my thing), while others still elude me. for reasons way beyond the scope of this, I need to have a pure Excel solution that does not rely in any way on Google Sheets. So the simple question is " Is there a true/pure Excel version of this spreadsheet?"