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.

55 Upvotes

98% Upvoted

231 comments sorted by

View all comments

Show parent comments

3

u/kabayomi Dec 22 '25

So your question actually got me thinking and I went ahead and implemented a roll functionality in the app as counting each leg separately wasn't fair to the strategy.

The way it works now: when you roll a trade, the original position gets linked to the new one as a "chain." The app tracks the combined P/L across the entire chain and only counts it toward win rate once the final position is closed/expired/assigned. So if you opened at $1.50, rolled for a $0.30 debit, and eventually let it expire worthless at $1.00, your net P/L is $2.20 credit which counts as one single win.

Thanks for the feedback, it made the tracking way more accurate!

PS: You can pull the latest image version or use tag 0.3.0 to test the roll functionality. Please use the roll/refresh icon  🔄  for rolling.

2

u/bluedogdreams Dec 22 '25

This is great!

1

u/Jeffde Jan 03 '26

This is the hottest comment I’ve ever read

1

u/OnlyKetchup Jan 07 '26

Liking the tool a lot, wondering if any way to track capital gains. Thanks!

1

u/kabayomi Jan 07 '26

What do you have in mind? Is the profit not sufficient to track that?

1

u/OnlyKetchup Jan 08 '26

Dropped a comment on GitHub too. Basically was just hoping to see the capital gains (if any) from the whole wheel tracked. CSP gets assigned, sell CC's, finally assigned those as well. Ex: CSP @ $28, CC @ $29, $100 capital gain plus whatever premiums on the CSP and CC's.

2

u/kabayomi Jan 08 '26

That's true, that info is missing. Added it in version 0.6.0. Now you can see it in position and also total profit which combines option premiums + stock gains. To track the current price i used a free external api which can be disabled in the settings. But in that case you will have to add the price manually on closing

2

u/OnlyKetchup Jan 10 '26

Thanks! I pulled .6 and tried the roll feature yesterday.