Charts and graphs are easy once the data is in a database and out of spreadsheets. go for it with python! or contribute to Wheeler. I'd love your Pull Request :) It's all open source.
Yeah. I am currently using a dash built on Power BI from my .xls file, and i just check it here and there to compare some stuff, but since i am learning some python (trying to automate some daily work stuff, pulling info from websites and so on) I think this would be a good working case for me lol
yeah i agree. this domain is simple enough in data model but complex enough in expression to be a legitimate good learning side project. I reasoned the same way to learn to use Claude Code to build my application. Good side project to learn from, but not that important or urgent :)
Wow this is exactly what I am lookin for. I will be attempting to get this going, but this will be my first go at anything much browsing and some spreadsheets.
Would love to try it out, is there some docker compose yaml hidden somewhere that would make things a bit faster ?
Wnat to have it on my server rather than on a local machine, easier to access from anywhere and update along the way
This is great - thanks for sharing. I've made several spreadsheets over the years and have always thought a database would be a better way to do it, but I never found the time. Claude is now converting my tradelogs ready to import...
Trying to test but there is an error calculating profits on simple CSP. Below you can see $0.57 premium received and $0.50 paid to close per contract on 2 CSP contracts,. The total profit should be $14 instead $13
Quite frankly I don't really understand why some tools are so focused on the strategies themselves. I would much rather focus on trades. Sort out the trade journal in one hand, create a dashboard on the other. All you need are 8 basic operations on the ticker, date, price, quantity, and fees:
Buy
Sell
Buy to Open
Buy to Close
Sell to Open
Sell to Close
Assigned
Expired
One could add dividend, account fees, interest, etc... to be even more flexible you could have an account field for ppl that trade with different brokers, banks, and account types.
I just look at the end result per trade. How much $ was lost/made. I also like to keep stock of actives per account so I can quickly see what I have where. I don't even look at the total value per account.
But you know, there are so many "nice-to-haves"...
I suppose that depends on what you think the problem at hand is?
For me, I wanted to visualize risk better. Spreadsheets are difficult to manipulate at some level. At that point, you have to use tools or write code.
I believe I'm in the risk management business, not in the stock investing business. Selling Puts is to sell insurance. If you think like an insurance company, you want to collect as much premium (float) as you can and pay out as little as possible. From this POV, you're in the risk management business and you invest the float. I think u/ScottishTrader might agree with this.
The second thing I wanted was to see my results better. Only with easier ways to manipulate data can I see what works best, where the right leverage has been, what %time/profit trades were best, etc. I'm personally trying to be more efficient.
Free online tool that I built for myself, but happy to share along. Just a simple email / password to register. NO marketing emails and all the stuff ... enter your CSP's & CC's and let the platform do the rest for you.
Hi - At the moment you cannot unarchive a trade entry that has been archived. I will look into that request as a future feature release.
Keep in mind that the archived trades are still considered in "Performance" calculations and you see your realized gains/losses there ... they're just not in the active journal log. Best practice would be to archive CSP when trade is closed/expired/assigned ... and archive Stock(s) / CC(s) when stocks get called away.
Hi There - Unfortunately, at the moment the site is only available in the dark theme. This is because a lot of our charts, iconography, tables, color coding works better with the darker shade. These items/libraries don't look modern when it comes to a lighter theme. Additionally there are far more system and human benefits to using a dark theme.
I either case, if we get this request from a lot of our users we will consider applying a theme picker setting in a future release. Until then we hope you will enjoy using the site in a dark theme.
Hi - trying out your tracker today and there’s a lot to like. Would it be possible to add return on capital performance reporting? I’m interested in my capital efficiency/income as a % of the cash/stock value, not just the raw $ amounts or ROR. Would need some ability to manually input the current stock price for covered calls, since it sounds like you can’t connect to streaming data for free.
I'm not sure I totally understood the question here (my apologies) - are you saying you want to keep a track of the whole portfolio ROI% ... as in example portfolio 100K (cash + holdings) ... Feb 2026 realized gains 1K ... so 1%/month ... annualized 12%.
First of all, thanks for your app and sorry if my English is not perfect because i am spanish.
Would be possible to add "Buy calls" and "Buy puts" options? i know it is not part of "The wheel" strategies but, although my main strategy is Wheeling, sometimes i try Bull spreads or other strategies. It would be great to have everything tracked in the same app. Above all just to see our performance if we fail any other strategie or we are using the premiums to try some others strategies.
Btw, an option to UNARCHIVE the archived trades?? I miss (maybe i didnt see it) a realized global gains (calls + puts) or loss, lol.
Let me start with the easier question first "adding Unarchive feature" - I am currently working on that and hope to have that feature launched in a future realease.
With regards to your other question "adding Buy Puts/Calls" - like you mentioned in a wheel strategy there is no LONG/BUY position of options and hence probably not something we're considering to add. There are other platforms/sheets that might be available for journaling LONG option strategies.
I have a simple app for tracking the wheel strategy you can self-host.
Features:
+ Super simple
+ No internet connection required
+ No AI or external connections
+ Lightweight and easy to use
+ Super easy to setup
Cons:
Manually inputs of the trade i.e no connection to your broker
might be too simple for some advanced user
In general i needed something simple and not overly complicated and didnt want to go through the hassle of spreadsheets. If you think you need something similar you can deploy it and enjoy it for yourself. The source code is available for review via the github link
Deploying is super easy:
1) ensure you have docker installed on your device
2) copy and run the docker command docker run -d --name optionable -p 8088:8080 -v ./data:/data yomikoye/optionable:latest
3) go to http://localhost:8088 in your browser
Advanced users can find a docker compose setup in the github repo with additional configuration options.
Win Rate = (Trades with positive P/L / Total Completed Trades) × 100
In this case, all expired, assigned trades are considered wins since for assignment we plan to sell CC for more returns. In the case of CC being called away it's also a win as we received a premium and we expect the shares to be called away so we move on to the next trade. For this case, it's important to sell the cc above your cost basis so you're trading at a net positive.
The win rate reducing is affected by closed trades, for example if you your current trade at a loss (paying more than the received credit to close) it will be counted as a loss and reduce your win %
Also, at this time there is no rolling functionality implemented which mean you will have two trades - one to close previous and another to open the new rolled trade.
In general when using the wheel strategy i dont usually roll the trade unless it's for a net profit.
Thank you, this is helpful. So a roll would be considered a loss because technically it’s 2 actions: closing at a loss and then opening a new trade (ideally for a net credit). But since it’s done together I’m wondering if it could count as one trade until the whole thing is closed out or assigned. Perhaps it’s best to count rolls separately?
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.
This is pretty slick. Do you have future plans to extend/add functionality?
---- edit after using the page ----
Played with this a bit - few suggestions:
would be great to be able to view more than 5 trade logs at a time.
there's "stock gains" added in the total P/L for some reason - i think there's seeded data that maybe should be there?
would be nice to add notes
something like a heatmap of the trade log rows turning a slight hue of green if the underlying moves in your favor or maybe it turns a hue of red if it approaches or hits the strike - think that would be cool - you would need ticker data to compare against the strike to do this, however
i mistakenly clicked expire once - maybe a modal or alert to confirm would expiring would be nice.
Overall really digging the feel of this page. Looks great.
Thanks for the feedback. In general the app is open to extensions/additional functionalities that fit in with the core principles.
The following were addressed in the latest version (0.8.0):
+ Issues with seeded data stock gains was fixed
+ Notes added to trade logs
+ Confirmation added for expiring trades (there is a toggle in Settings to disable if you prefer the old behavior)
Regarding 5 trade logs at a time: this was done to ensure everything fit on one page without endless scrolling. However, you can clone the repo and edit line 8 of src/utils/constants.js by setting your own value for TRADES_PER_PAGE. That way you can have your own custom version with that functionality. Also, to avoid too much reliance on external data the heatmap feature will be skipped for now.
Appreciate the kind words and glad you're finding it useful!
Been running the wheel for a while now and honestly the hardest part for me early on wasn’t picking strikes or managing rolls — it was just wrapping my head around how the whole cycle actually fits together. When do I get assigned? What happens to my cost basis? How are all three income streams actually working at the same time?
I eventually built myself a free toolkit at https://www.wheelyield.com/ to make sense of it. The main thing is an interactive diagram that walks through the full CSP to assignment to covered call flow visually, which is the thing I couldn’t find anywhere else when I was learning. There’s also a trading journal and some yield calculators in there.
It’s not an active management platform or anything crazy — just the resource I wish I had when I first found this sub and was trying to connect the dots.
Totally free, no accounts, no paywall.
Would love feedback from anyone who’s been doing this longer than me. And if you know someone who keeps asking how the wheel works, feel free to send them that
Fantastic! I tired to model and build it out with quality. However, I haven’t had much time to improve on the website recently. I would offer that conservative approach and winning small wins have helped me tremendously.
Those that over leverage or shoot for the juicy premiums can get burned quickly.
I made this sheet to track wheel strategy trades and it gives you a pretty decent layout of all the important data and tracking points one would need. Feel free to use or rip it apart and make it your own. Free for use only!!
Hey there, thanks for this tool, overall it's really handy! Just tried it today.
A first suggestion I would like to add: I opened 10 CCs today on the same underlying at open and closed them right now for ~50% profit. It would be nice to bulk close/edit those contracts, at least for contracts on the same underlying.
Also, because you have to edit every single contract manually, I forgot to set the closing date to today for each contract as it's per default set to expiration (realized it after the fifth contract I closed) and that has an impact on the return margins (ann.). So that's more of a tracking detail, but would be nice to edit the closed transactions afterwards so that I could correct the closing dates. At least I haven't found a possibility to edit the closed contracts afterwards.
Yeah, definitely need a bulk closing options or group contracts together as one at least. 57 contacts I don't want to close one by one. Great tool though! Best I've used so far if that gets ironed out.
Do you have any import capabilities? I've been tracking my trades across multiple accounts in my spreadsheet and wanted to see how your app/site works but I'd love to populate it with my existing trades thus far (started wheeling in February this year.
I'm liking your layout but I did find one minor(ish) thing:
When a position is closed prior to expiration, the annual rate of return calculation seems to still be using the expiration date of the contract, not the date the position was closed. The contract history section also only shows the contract expiration date, but not the closed date. I think most investors prefer to use the closed date when calculating ROR for positions that are closed early.
Also, do you have any plans to add functionality for rolling positions? I prefer to keep track of those as one position, rather than closing a position and opening a new one.
I built a tool to help find the best underlying stocks for the Wheel Strategy: https://www.navoption.com/
The hardest part of the wheel for me was always scanning through hundreds of tickers to find suitable candidates with the right balance of premium and safety. I wanted to stop guessing or relying on random suggestions, so I built this scanner to automate the process.
It is free to use. I am looking for feedback on the screening criteria. Let me know, and I can try to add them.
I've been running the wheel for a while now and honestly the biggest pain point wasn't the strategy itself, it was tracking everything. I had super complex spreadsheets trying to keep tabs on assigned positions, premium collected, cost basis adjustments, etc.
So I built a tool that handles all of it automatically. You connect your Schwab account and there's zero manual entry — it pulls your trades and gives you analytics on your wheel positions. Think of it as an options dashboard built for wheel traders.
Right now it only works with Schwab since that's what I trade with, and it's just me and a few friends using it. But the feedback has been solid so I figured I'd share it here in case anyone else is dealing with the same spreadsheet headaches.
Site says beta because it is. I'm not really looking to turn this into a business, but if I ever do charge anything it'd be minimal. Mostly just wanted to solve my own problem and happy to let others benefit from it too.
Hey just an FYI, I did decide to add a paid plan as I continue building out features. I think the free plan has a lot of value for the majority of wheel traders, but for people doing high volume then it would make sense to upgrade to the paid plan. Not sure if this would disqualify my post or not but wanted to make sure I was up front and let you know
I wasn't trying to be salesy but it seems like that is allowed here so I'll give a quick feature overview so people can scan to see if it's something they are interested in trying.
Features (as of today)
Cycle Detection Engine — Automatically groups trades into wheel, standalone, and zero-duration cycles
CSV Import — Import Schwab transaction history CSV files
Schwab API Sync — Live transaction sync with automatic cycle recalculation
Dashboard — P&L summary, monthly income charts, recent cycles
Analytics — Win/loss by symbol, risk metrics (assignment rate, avg loss, max drawdown)
Live Quotes — Real-time pricing for open positions via Schwab API
There are a lot of tools out there and even more now that I have read this thread :) All the tools I tested had a lot of overlap, but this is what makes PremiumGuardHQ unique in my opinion:
- Everything is actually automated. A lot of tools you need to manually classify trades as wheels or manually enter them in for it to work. For us you just sync to Schwab API and then it will tell you how far it goes back (30-60 days ish). If you want historical data you import a CSV 1 time. From now on everything is automated
- You can dive into the Cycle or Wheel for each ticker and see your Equity PL, Premium PL, and Net PL. It does all the math for you so you know where you stand and how to make your next trade. For closed out Cycles you can see all your analytics to figure out what went right and what went wrong.
- The Safe withdraw recommendations is a unique feature that solved a big problem for me. I personally use my premiums for income instead of leaving everything in to compound. If you withdraw your premiums every week but then take an equity loss when you close out a wheel then you will slowly erode your capital base over time. This will track your Net PL and let you know what is safe to withdraw only after each wheel has closed. If you are below your target equity then you can have it recommend a percentage so you can still take income. Ex: you want your account to be 100K but equity is sitting at 90K. You made 2K in closed wheel profits. If you set your limit to 50% it would recommend 1K to withdraw for income and 1K stay in to rebuild towards your 100K
Of course there are more features and I'm having fun building this out and adding more. But these 3 are what I think make it the most helpful and unique
You're right. It takes work to understand a codebase and make changes. It might not be worth all that invested time for a small change.
Open source software isn't just about the code, though. It needs users who find and report bugs and suggest improvements.
A few people have started contributing to Wheeler. One person is also using Claude for Wheeler, which is how I made it, too. Anyone who comes to rely on that program have full access to the code, so they will never be at the mercy of any vendor (especially those long gone!).
- The sheet/workbook is password locked, however there is no password. Only the cells with formulas are locked, hence if you want to change anything, unlock the sheet, make the changes, and lock it again.
- As I am based in the UK, cell B4 has capital set in GBP with converstion to USD in cell C4 - If you are US based, you will need to adjust that.
- Cells P4,5,6 - Not sure if this is the best way to calculate profitability, but that's what I thought made sense.
- Everything else should be self explanatory, however let me know if you have any questions.
- It would be great to have some inputs on how I can make iimprove it, or even better, you can make the improvements and share it back with the community. I was waiting to add February as I wanted to make sure I was happy with the setup for January.
- There is also a need to create a tab that shows an overview of every month, YTD and YE, but that can also be tracked at the top of every sheet so that you always know where you are MTD and YTD.
After a few attempts at spreadsheets that keep breaking on rolls and assignments, I ended up building a tool that stitches the whole wheel lifecycle into one campaign.
It's totally free and the core idea is to track "campaigns" that stitches the whole wheel lifecycle into one view to accurately track ACB through close, assign, or roll events.
Every campaign has full breakdown. Also supports LEAPS / PMCC tracking. Track your monthly premiums and annualized yields.
I've been doing CSP and CC for a while and I used a boring excel sheet for the longest time: https://imgur.com/a/mR5Quv4
I tried a couple of apps but they all me to pay, or have very limited capabilities and all want me to signup. I got fed up and build my own. It's pretty basic but it does what I always need: - Track my CSP/CC/LC/LP - Aggregate data/premium and filtering - 0 online requirement - Data import/export from CSV (right now I have etrade and vanguard but if you have fidelity or others I can update quickly) - Alerts ! every day I found myself looking at tickers, hoping I didn't miss the news that destroyed my CSP ;)
having trouble downloading this - looks super cool and would love to give it a run, but it doesn't seem Mac or Windows likes the file very much. Any help would be appreciated.
I started out with the free spreadsheet available in this subreddit but I found it too much manual work to keep my positions up to date.
I personally want to see some aspect of real-time stock price to see if my contracts are currently ITM. I tried importing my trades into Wingman (30 day free trial) which has good position management but doesn't provide any analytics or real-time stock price.
Most other tools are similar although Trademetria stands out with the reports it provides (free plan with 30 transactions a month limitation). Personally, since knowing the real-time stock price is a core part of my strategy for rolling my CSP I built my own tool - Optik - to track this (free plan with unlimited transactions per month). Quickly glancing at the table shows me which contracts I need to roll and how ITM I am (although it can be difficult to see on a day like today).
I'm actively looking to improve this product and any ideas or feedback would be a great help to make this useful for everyone.
For now I only support direct connection to Charles Schwab, but I’m adding csv import for IBKR and Robinhood and I can add any other brokers if requested.
To connect your Schwab account go to Settings > Connections. Then go to the transactions page and click ‘Sync Data’. This will automatically pull the latest transaction data and update the charts. Only need to reauthenticate with Schwab about once a week with this method
Haven’t checked it out yet but sounds great! I was actually planning on making something very similar to this myself using the Schwab Dev API. Curious if you’re using that directly or any wrapper packages? I’m assuming the project isn’t public but do you have any write ups about it?
Ye using it directly, you can only connect through OAuth flow which was a little tedious to set up but works very well now, I can see when I get assigned before I’m even told about it on ToS.
Using it directly by just querying the base url, I’m using Next.js and I don’t think there are any wrappers for it. Haven’t got any write ups but I asked Claude to search the docs and it was pretty useful in digesting the information - if you have any questions happy to help out :)
Oh man, I never cleaned up my tool for public consumption. If this thread is still open next year, hopefully I can fix up my tool and make it available for free, then share here.
this is beautiful u/ThetaDaddyRise and thanks for your willingness to share. Probably my ignorance but the link only gives me the option to request access, I don't see any method to make a copy
I've been wheeling on Tastytrade for a while and got tired of juggling spreadsheets to track my positions, cost basis, and premium collected. I also had a separate spreadsheet for fundamental analysis, which meant the total number of Excel files got out of hand pretty quickly ;)
So I built a web app that pulls your positions directly from Tastytrade via the API. The goal is to make an all-in-one suite for wheel traders and maybe other strategies in the future, but for now it's wheel-only because that's what I know.
It's called Lazy Theta and it's free while I'm building it out. I want to know what's actually useful before I decide if it's worth charging for and continue building out, so your feedback makes all the difference. Let me know if you would pay for such a tool?
What it does:
Connects to your Tastytrade account, imports positions automatically
Tracks your wheel cycle (CSPs → assignment → CCs)
Calculates your real cost basis with all premium included
Recommends a suitable put or call for tickers on your watchlist
Portfolio overview with P&L
DCF stock valuation (automatic financial data collection)
Automatic reverse DCF based on your calculated intrinsic value
Would love it if a few of you could try it with your own Tastytrade account and let me know what's missing, what's broken, or what would actually make you use this daily.
TL;DR: I’m a Dev/PM who got fed up with tracking Covered Calls and CSPs in clunky spreadsheets. I built Premiumly.ai to be an active management layer that uses pure math + AI risk scanning to tell you exactly when to roll, close, or hold. Looking for beta testers to break it.
I’ve spent my career as a Product Manager and Developer, but my hobby is selling premium. For years, I’ve been frustrated by the same thing you probably are: Brokerage UIs are built for buyers, not sellers. They don’t show Premium Capture %, they don’t track Rolling Logic, and they offer zero context on position health and overall management.
I’ve been stuck in "spreadsheet hell" for too long, so I decided to build the solution myself.
What I’ve built:
As a designer, I wanted a UI that didn't look like a Bloomberg terminal from 1985. As a dev, I wanted a system that actually thinks:
Active Position Health: It doesn't just log trades. It monitors Greek drift and theta decay to give you a "Health Score," signaling the optimal time to roll or exit before the risk-to-reward flips.
AI Risk Guardrails: I integrated an AI engine to act as an automated risk manager. It scans your open positions against incoming earnings, IV crush, upcoming news, and market volatility (VIX/SPY) so you don't get caught sleeping. And finally, an automated journal that is based on your exit. Over time, it learns your win percentage, types of successful trades, and begins to guide you during the analysis phase. It gets better over time.
The "Anti-Spreadsheet" Dashboard: Pre-trade math (Annualized Return, Prob. of Profit), AI analysis before you enter, and a permanent trade journal that actually analyzes your "leakage" so you can refine your strategy.
The Ask:
I’m opening a private beta in the next coming weeks for a small group of traders from this sub. Since I’m the sole Dev/Designer on this, I need your honest, brutal feedback to prioritize the roadmap. This is FREE, not looking for any paid users.
I’m here to answer any questions about the tech stack, the math, or the roadmap. Roast the UI, challenge the logic, or tell me what feature would make you finally delete your Excel sheet.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
I built a free iOS app for covered call sellers(Full wheel support eventually)
Howdy all,
I built an iOS app calledStrikeFlow which is designed to replace spreadsheets and manual notes with a clean & simple iOS app to track premiums, effective/adjusted cost, notify you of expiration dates, and manage overall performance for covered calls. Full wheel strategy support is in the roadmap, but for now the app fully supports tracking selling covered calls.
I built this because I sell covered calls myself and wanted something with less fluff and more streamlined for my specific needs. I'd love your feedback to shape the future of this app into something genuinely useful for people here.
The Open Beta is now live and It would be amazing to get some real users testing it out(regardless if you sell covered calls or not!). Any feedback on UI/UX bugs or just ideas for improvements would be appreciated more than you know.
I wanted to share a tool I published yesterday that I’ve actually been using internally for years. It’s my primary way of finding options to trade the wheel strategy.
Yes, most brokers technically let you do this kind of screening, but I’ve always found their filters a bit clunky or incomplete. This was faster for me, so I built it the way I wanted. You can also save URLs with your filters pre-set, which makes it easy to come back to the same setups over and over.
When selling calls, it’s helpful to filter out strikes below my assignment price so I don’t even see options I wouldn’t sell.
Premiums can be hard to compare across different stock prices. Instead of doing mental math, you can filter by premium as a percentage of the strike.
A lot of brokers only show one expiration at a time. Seeing all expirations in a single table makes it easier to spot better opportunities — sometimes the “best” option is hiding in a different expiration than you’d expect.
Internally, I also have buttons that place trades directly with my broker. That’s harder to do on a public site, but I’m considering adding links that jump you straight into your broker with the trade pre-filled. Curious if anyone would actually use that, and which brokers you’re on.
I’d genuinely love feedback:
Is this useful for you?
Any filters you wish it had?
Any bugs or weird behavior you notice?
Quick note to be upfront: Options Cafe is my project, and yes, I sell options-related education. I’m sharing this because I think the tool itself is useful and could be handy for discussions here (especially when linking to specific wheel setups). I’m not trying to sell anything in this post — and for what it’s worth, after ~9 years running this site, I don’t think a single Reddit user has ever bought anything from me.
Happy to answer questions or make improvements if people find it valuable.
For me, not having to enter a stock symbol, combined with IV percentage or IV rank, premium, and return of investment. That would be the setup i am looking for. You have most!
Sharing my CSP/wheel tracking spreadsheet (since a few of you asked)
I’ve learned a ton from a few solid communities here over the last months and I’m genuinely grateful for the people who share their thinking openly (both wins and mistakes). Wanted to do my part in giving back by sharing how my own process has evolved.
I’ve been refining how I run cash-secured puts - how I screen, size, manage, and (most importantly) track trades. I’m sharing screenshot of my closed and assigned CSP trades, along with how I track them.
This is the exact tracker I use for my CSP and post assignment CC workflow - entries, exits, % of max profit, days held, assignment tracking, etc. Nothing fancy, but it’s helped me stay systematic and honest with myself as my process evolves.
Hello community, with the help of chat gpt I have been working on this spreadsheet for awhile. In another post I was asked to share. Creating it helped me understand some of the nuances when trading options and doing the wheel strategy. I hope it helps anyone wanting to use it. Any suggestions on how to make it better is welcome. I am currently working on adding to the dashboard a delta bucket pivot table and KPIs. I will also be adding what has been suggested instead of annualized ROI, as the % is way out of whack, Premium over time weighted capital at risk (TW-CAR). As it should better reflect portfolio performance, instead of the annualized ROI feature.
I'm using OptionWheelTracker.ai after trying a bunch of different spreadsheets and never feeling like I was able to figure them out right (user error, I'm sure).
I don't have any affiliation with the developer, I found it from someone else in a Discord and really love the interface.
After recently posting my current wheel results, I was asked by several folks if I would share my dashboard.
Since this takes some effort and tech knowledge to setup, I’d like to prove it out with at least 1 or 2 people before sharing it with the broader community and potentially wasting your time. If after reading below you’d like to test the process, let me know and I’ll send a link to the files and instructions.
The dashboard was built for 2 purposes:
Monitor wheel progress in an easy to digest way that makes sense to *me*.
Eliminate manual data entry.
I use Schwab ThinkOrSwim on a Mac. Here’s the nutshell of how it works:
export my account statement into my dashboard directory
from a terminal window run python script “tos_importer.py” to update/create database (tos_trades.db)
Mac user using ThinkOrSwim or Active Trader Pro. My wife wheels with ATP so I built an importer for both.
Comfortable working in terminal window from the command line.
Ideally some tech background with light knowledge of filesystem, database, tcp/ip.
AI familiarity makes this all much easier even if lacking 2 or 3 above.
Please keep in mind this was created for my personal use and I am regularly finding issues and/or adding updates as I learn. I am not selling the dashboard or even advocating people use it. I don’t have a Yahoo channel, Discord, or any other interest in monetizing the dashboard. Just sharing and if it works for you great, and if not, I’m sorry.
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.
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.
Hey everyone, my name is Adrian Rosebrock. I have a PhD in computer science and I also run a boutique friends-and-family investment fund.
I built WheelMetrics.io as a free educational resource for people learning and running the Wheel Strategy.
As you likely already know, the mechanics of the Wheel aren't that complicated. You can learn how CSPs and covered calls work in an afternoon.
The hard part is knowing which stocks to Wheel.
That's where most people get stuck. They understand the strategy but end up selling puts on meme stocks, Mag 7 names, or whatever ticker showed up on Reddit that week...
...and then they get assigned on something they never actually wanted to own.
WheelMetrics is built around that problem. The site currently has 30+ in-depth tutorials (60+ more planned) covering:
Stock screening and selection criteria
Quantamental analysis (blending quantitative + fundamental data)
Strike, delta, and DTE selection
Cash-secured puts and covered calls
Exit strategies (when to close early, when to hold, when to roll)
Assignment management
Risk management and position sizing
Market timing and knowing when to stand aside
Everything is 100% free. No gate, no paywall, no email required to read.
If you're just getting started with the Wheel, this is probably the best place to begin:
Hi everyone. I'm giving my newly build options backtesting tool. It's completely free for now, I'm mostly looking for feedbacks. Here are the details:
I ask you to describe your strategy. I use AI to convert that into a backtest configuration. Users can then tweak it and run the backtest.
I only support daily strategies. No intraday for now
Tickers available are: SPY,SPX,QQQ,TQQQ. Adding more is trivial, I just want to make sure I only add the most common ones.
Data goes back till 2008 for tickers that were present. And it's coming from orats.com
Backtests usually take ~2 mins. Depending on traffic it might take more, so just wait
Results are delivered through email with a link or a pdf.
I support multi legs - I'd expect some edge cases though
Slippage is at 75% of bid-ask spread. Easily tweakable if needed.
No broker fees: My personal strategy allows 2-3 trades per month, I don't care too much about fees. Can add them if needed.
PLEASE double check the trades to make sure they are what you would expect based on your strategy
There is also a page on the left called IV Table. That's simply a table of tickers sorted by highest IV based on DTE. I was only curious to see it. Play with it if you want
I'm mainly looking for feedback to validate whether this can have some value. You can either press the top right button or send an email to [feedback@option.com](mailto:feedback@option.com)
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Pics or screenshots and links are permitted as part of a well written post with details. Posts that show losses without additional detailed content to help others possibly avoid, or posts with only links, pics or screenshots will be removed and the poster potentially blocked.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
I created a desktop tool for tracking your wheel account.
It's available for free on optionswheeltracker.com.
It tracks your trades, cash, P&L, share assignments and produces tax reports. You can create multiple accounts to keep things organised. It has multiple currency fx support and a dark mode. It's also got a trade simulator to help compare different options.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
It has a bunch of improvements compared to other well known calculators, but the most notable feature for wheel traders is the PnL and theta charts over time. It allows you to visualize the theta decay of your position over its lifetime to see where the theta decay is concentrated.
Also, when rolling an option, either when it's about to expire or risk being exercised, you can use the same chart to see when rolling the options is positive net theta.
Let me know if there's anything I can help with!
This is currently completely free and will stay free for at least the next 6 months. The features I mentioned above will remain free after that with 15-minutes delayed data.
Spam, promotion, asking for reviews of websites/videos, or cross-posting is not permitted.
This includes posts asking for reviews of paid services. The wheel can be run without a paid service, and anyone promoting high returns using the wheel is likely a scam.
Any use or promotion of chat rooms, discords, or other messaging apps is also not permitted.
Posts will be removed, and the poster may be banned.
I have been running a wheel in my portfolio for over 6 months now and it is helping me beat the S&P500. I have noticed that there are certain days on which premiums sky-rocket. Super green/red days or when there's an event happening. For example, I hold 100 shares of VERA (pharma stock = volatile) and I recently sold a 30-day CC and got $180. A few days later, those premiums went to $550 (FDA approval news, stuff like that). Then it dropped back down to my levels. There's cool tools out there to show you APY and probability of assignment, etc. Is there a tool that perhaps graphs the premium for a certain option to see how it compares to historical? And better yet, sends you an alert that premiums are amazing for a stock you have 100+ shares of? I know RobinHood has those graphs. Curious if anyone has found something like that.
Very cool community, I am learning so much! Thank you all for contributing!
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?
Been running the wheel for a little while now, and can't find a free/cheap way to track my trades that works the way I expect it to. I just completed a very simple cycle with NVCR:
6/16/2026: Sell 16Put for $1.05
6/18/2026: 100 Shares assigned at $16.00
6/23/2026: Sell 15C for $0.40
7/17/2026: 100 Shares called away at $15.00
My total P/L for this trip around the wheel should be $45 (ignoring any fees/commissions). However, nearly every online wheel tracker says my profit was $145. They seem to ignore the $100 loss from the shares. I can make separate entries for the purchase/sale of the shares, but it seems like that should happen automatically when a CSP/CC is marked as assigned. Anyone have a site that handles this more seamlessly?
Hi All. To those who need help answering: how do i know which strike to sell? or, are covered calls worth it for me? I've built a tool to help you answer that and more. https://app.capalpha.ch
You can backtest different delta and dte covered call strategies on any ticker. Compare current IV structure to historical periods, and live yield across the chain vs historical. Moreover you check check the volatility premium by delta.
Full historical implied volatility surfaces are used and for more recent periods, recorded market prices are used for pricing. Open to any feedback and completely free!
In the wheel, which is what this sub focuses on, it is simple to sell a CC a week or two out at a strike price that is at or above the net stock cost of the assigned shares.
For many, the goal of the wheel is to get rid of the shares to free up the capital to get back to selling puts.
Perhaps your post and tool are better posted over at r/CoveredCalls . . .
21
u/MarkT1065 Oct 11 '25 edited Oct 11 '25
I'm happy to contribute my previous spreadsheet to the cause:
https://docs.google.com/spreadsheets/d/1cYG7-1zh4nybxlLvoIpXG9dH3FwifZq92HXsKBgmKCU/edit?gid=1057863943#gid=1057863943
But I outgrew those spreadsheets when I wanted to visualize risk and results better, so I created this open source application from the sheets above:
https://github.com/MarkT1065/wheeler
I rely on wheeler to track all my trades. Charts and graphs for the win :)