Options Wheel Strategy Spreadsheet DEMO v2024 - Excel & Google Sheets
HTML-код
- Опубликовано: 16 сен 2024
- FREE Pdf : TOP 3 Key Option Strategies to Jumpstart your Options trading Journey : mailchi.mp/6b9...
Here is the link to the spreadsheet on our website: www.tradingopt...
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.
Read this dedicated article about the trading options wheel strategy on our website : www.tradingopt...
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
💰 Join our discord community of like minded option traders to discuss and learn about option trading: / discord
📈 Check out my Woocommerce shop on my website for usefull trading options and finance spreadsheets : www.tradingopt...
Or my Etsy shop for useful tools and resources (spreadsheets) : www.etsy.com/s....
You can buy the spreadsheet also in our Etsy Shop for less than the price of one positive option trade.
Our website : www.tradingopt...
Our Twitter : / l2tradeoptions
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.
Here is the link again to the spreadsheet Version March 2024 : www.tradingopt...
-------------------------------------------------------------
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
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
Great choice of name ! Don't forget to join our discord to chat with like-minded and share ideas.
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?
Hello, thank you for your interest in the spreadsheet. There is no automatic creation of a new row "buying shares" or selling shares when a put or a call is being assigned.
I have created a video (for the all in spreadsheet) about processing an assignment of shares in the spreadsheet. This will explain how the spreadsheet is intended to deal with assignment. : ruclips.net/video/7fBPjmgloz4/видео.html
The wheel strategy spreadsheet is receiving an update in that same sense and the updated version will be of course free for thos purchasing an earlier version.
If you have any more specific questions, do send me an email : tradingoptionscashgflow@gmail.com
Happy trading
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
Hello Kevin,
Basically I do exactly in the spreadsheet what I do with the trade : rolling is closing a position and opening a new one for a debit or a credit, where the new open position must be the sum of the credits received and debits paid. It is probably easier to show than to type so
I advise you to watch this video. It is the same system for both spreadsheets. ruclips.net/video/eVRHCyviLCQ/видео.html
Also read some of the comments Q/A of previous users about rolling.
If it is still not clear, let me know and we will explain it more.
Best regards.
Kurt
@@tradingoptionsforcashflow Thanks Kurt! The other video explained it beautifully. The key for me was adding the premium from the original position to that from executing the roll! Thanks again.
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
@@kevinjohnson8510 Hi Kevin, you should check if the status is set to closed. If you can not figure it out, send me an email and share the file and I will take a look.
Happy trading!
K
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?
Hi, this spreadsheet is indeed intended to copy a sheet for each stock I am wheeling. I allocate a portion of the cash in the account to each wheel. May I suggest to join our discord to chat there and exchange questions on specific things about it. Thanks
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?"
Hello Dan,
The download comes with a downloadable excel file.
Grtz