Best Spreadsheet for Tracking Options Trades (NEW VERSION) | Free Download

Just in time for the new year, I have a new way for you to track your options trades! Version 2 of my Ultimate Options Tracking Spreadsheet is greatly improved. I've implemented feedback from viewers and you can now use the spreadsheet to track your option selling AND option buying. So, take a tour and download the ultimate options tracking spreadsheet using the link below. You can use this tracker for all kinds of options trading strategies, including the wheel strategy. You can also track dividends, stocks, interest, and more.

🔗 Links:
Here's a link to the spreadsheet. Be sure to SAVE A COPY to edit it.
The spreadsheet is free, but if you use it, consider buying a "Super Thanks," which directly supports my efforts. The Super Thanks button is located under the video. Thanks for your support!

📌Timestamps:
0:00 Start Here + Intro
01:53 Tour and Features
12:38 Tracking Assignments
15:53 Tracking Rolls
18:15 Customization Tips & Tricks
20:22 How to Download + Outro

#optionstrading #optiontrading #wheelstrategy

⚠️Disclaimer:
The content in this video is not financial advice. It is for informational and entertainment purposes only.

[dukeofearlyretirement]

This spreadsheet is available for free. There is no need to request access. When you open the spreadsheet, it will be in View Only mode. Please select File > Make a Copy to edit and use the spreadsheet for your own trades. Thanks!

[laszlosoltesz]

Thank you for this spreadsheet. I have been using a paid one that has so many bells and whistles including graphs and charts, that at the end of the day I find it too glitchy and complicated for my needs. Your's covers everything I do, including the wheel. I think it wil be exactly perfect for me. Thanks again.

[albo]

I’ve been using v.1 of the spreadsheet and it has been the best one out of a ton of other ones I tried. Im really excited to start using V2. Thanks so much for your generosity! This sheet is a gem!

[alishadec]

Thank you for the spreadsheet and the break down. Why is the trike price labeled "K(s) is that suppose to be significant for something

[tomstraub]

Thanks! This spreadsheet will greatly assist me in my new found pastime! (I am already seeing the benefits of observing the better outcomes.)

[CincyJAD]

This is awesome my guy! Thank you for sharing.

[dznyc]

Thank you so much! Just started options trading and I'm starting to lose track. I will use your spreadsheet.

[mindchi]

Hi - I don't know if you are currently tracking the comments. I wanted to know if it would be possible to add Adjusted Cost Basis for stocks based on Covered Calls written against them. As you keep writing covered calls, your cost basis for the stock goes down. I have many stocks that I am writing covered calls against. It's very difficult to keep track over a long period of time. This would be an excellent option if possible. I expect that this would be difficult to implement, but was just wondering.

[RaimundoHoward]

This is exactly what I needed! Thanks!

[nationalnotes]

good stuff. Love to see a way to track your cost basis too.

[gilB_]

I just found you! Thank you for your content and the spreadsheet!

[shekyboy]

Nice work on the sheet. Can we add a better to track rolls? The current solution jams it in the original trade and the overall fidelity is lost if you rolled multiple times.

Wondering if simply closing the prior trade and opening a new one (on new row) with the credit difference would be sufficient?

[pgroan]

It would be quite useful to include a column denoting the strategy, ie, iron condor, calendar, pcs etc.

[anthonyjackson]

Thank you for this wonderful spreadsheet. Feedback for Version 3, perhaps a way to to have beginning balances. I have a couple of trading accounts to deal with the PDT rule, so it would be helpful if this sheet would calculate my P/L as a whole as my trading accts have different balances.

[lucauau]

Super nice spreadsheet.
I’ve created a similar one according to my needs.
I would implement a couple of useful adjustments (ides I got from this video).
The data (I’m interested in) that is missing in your report is the amount of money (by currency) I have in my account (used for matching purposes) 😊

Ps. what about the collateral (and p&l) using a margin account?

[Jovush]

Great spreadsheet and thanks. I do have a question, when you rolled in example, how did you account for the closing cost? Thanks again for your dynamic sheet.

[darylbonds]

Very nice, but what happened to the stats tab?

[GARLANDTHOMAS-cdol]

HOW DO U SAVE THE SHEET WHEN YOU ARE FINISED WORKING

[tomstraub]

Any help you could give for my question a week ago about how to handle the NVIDIA split would be so appreciated! 🙏

[kenmoreholdings]

Very helpful video and resource. How did you get the oval colored dropdown buttons in the “type” column list?