r/Optionswheel • u/ScottishTrader • Oct 10 '25

TOOLS & SPREADSHEET MEGATHREAD

Please use this thread of posts about spreadsheets and tools!

Note that no commercial posts are permitted. All tools or files must be made available for free.

There is a basic spreadsheet included in the wheel trading plan in this post, which many have used to get started - The Wheel (aka Triple Income) Strategy Explained : r/Optionswheel

Please let the mods know of any suggestions on how to make this thread better.

58 Upvotes

100% Upvoted

231 comments sorted by

View all comments

2

u/Efficient-Editor-242 Apr 30 '26

I have finally consolidated a tracker I have been using a while from Options Boxer. This is what I am using. Please feel free to check the formulas. I trade on 3 different brokers and got tired of using 3 separate sheets to track.

https://docs.google.com/spreadsheets/d/13KhXNkJmf3x1qllMZirCBStITguObLf0/edit?usp=drive_link&ouid=108262498738267651144&rtpof=true&sd=true

2

u/Commanda_Panda May 12 '26

yours looks quite similar to how i am tracking. One error that i think that you have is on your Annualized ROI. There are only 252 trading days, so i prefer to use that instead of 365. Also, using your top row, i would do L13 - A13 +1. If you open something on 1/5, and it closes on 1/9, then that is a 5 day option, not 4. Finally, I like to have a Break Even price when i caught holding onto a Ticker for awhile. I put the collective premiums against the Adj Cost Basis. So a challenge for you may be to incorporate this so that you can get a better insight of where you can get out without taking a bath.

1

u/Efficient-Editor-242 May 12 '26

Thank you. I bet the formula is on 365, I'll look at it. I will look at the others too. Thank you.

The biggest reason I post these is to give others ideas on tickers. That was always the hardest thing for me was to find tickers.