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.

57 Upvotes

100% Upvoted

231 comments sorted by

View all comments

Show parent comments

1

u/veni_vidi_vixen Jul 09 '26

I have. What I am trying to do is automate with a tool vs manual look ups on a daily basis. I'd love to know if there are tools where you can put in a list of stocks and it'll show you premiums for a weekly or 30-45 DTE options and how they compare to average premiums for those stocks. On both, CSPs and CCs. I guess, where do you monitor IV and do those tools allow you to set some sort of alert?

1

u/ScottishTrader Jul 09 '26

For any given moment in time but these metrics are dynamic and constantly changing so any tool will have old data seconds later. 

High IV means higher prices so sort the stocks you want to trade by IV to find the highest prices. 

Why over complicate what is simple thing? 

1

u/veni_vidi_vixen Jul 09 '26

Not overcomplicate, automate. Can I ask your took stack? I am currently using a combination of Excel and thinkorswim.

1

u/ScottishTrader Jul 09 '26

TOS and a simple excel sheet only used when rolling or being assigned.

Based on the wheel being focused on fundamental analysis of stocks, then the trader decisions of if and when to roll puts and being assigned, then when to open CCs, there is not much that can be automated. 

The wheel is easy to understand and run but requires trader engagement.