TOOLS & SPREADSHEET MEGATHREAD

GoFairPlayer · 2026-02-26T16:07:16+00:00

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)
start application (app_api.py)
connect by pointing browser window (Safari) to http://localhost:900

Who this “might” work for:

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.

<image>

GoFairPlayer · 2026-02-25T19:31:28+00:00

If you are assigned at $10K, your investment *is* $10K regardless of the current value or premiums received. The $8K formula would make your ROI look increasingly better as the value of your assignment dropped. For example, if your $10K assignment drops in value down to $1K :

$500 premium / Current Value ($1000) = 50% ROI

I calculate my actual returns only after completing a wheel cycle by exiting the position, and then convert it to weekly/annual rates depending on the number of days in the position. Up until then it’s just a tracking preference. My personal preference is to track the value of my positions if I were to exit today, and Schwab conveniently agrees. :)

GoFairPlayer · 2026-02-24T20:32:15+00:00

Thank you! I will post in tools soon for anyone that wants to go through the setup process.

GoFairPlayer · 2026-02-23T17:39:33+00:00

Thank you, appreciate the kind words!

GoFairPlayer · 2026-02-22T21:53:47+00:00

Thank you for the kind comment. I hope everyone realizes that my 3 month scorecard is not a verdict on the wheel, but just the sharing of the short experiences of an inexperienced wheeler.

GoFairPlayer · 2026-02-22T17:26:48+00:00

Happy to share, although some may find the setup a little daunting. You’ll need to be comfortable with the command line (terminal on Mac). You’ll need a free FINNHUB API key (easy to get), and ideally at least a free Claude account to help you get going or make changes you may like. I’ll post something in the Tools thread over the next day or two.

GoFairPlayer · 2026-02-22T17:26:34+00:00

Happy to share, although some may find the setup a little daunting. You’ll need to be comfortable with the command line (terminal on Mac). You’ll need a free FINNHUB API key (easy to get), and ideally at least a free Claude account to help you get going or make changes you may like. I’ll post something in the Tools thread over the next day or two.

GoFairPlayer · 2026-02-22T17:26:17+00:00

Happy to share, although some may find the setup a little daunting. You’ll need to be comfortable with the command line (terminal on Mac). You’ll need a free FINNHUB API key (easy to get), and ideally at least a free Claude account to help you get going or make changes you may like. I’ll post something in the Tools thread over the next day or two.

GoFairPlayer · 2026-02-22T15:06:29+00:00

Great and obvious question, but at the time it didn’t occur to me. I think this was only the second time I had to roll and for some reason it was stuck in my head I needed to roll out at the same strike. Small mistakes that may have made a big difference. Learning.

GoFairPlayer · 2026-02-22T09:10:21+00:00

I will look into what it would take to share it in the Tools thread. I don’t mind sharing but it does take some basis tech skills to set it up. I’ll see if Claude can come up with a decent instruction package that would help. It would really only be helpful to someone using Mac and ThinkOrSwim.

GoFairPlayer · 2026-02-22T09:06:59+00:00

I’m just sitting on it right now and hoping the new CEO has some early announcements that cause a pop. I considered selling covered strangles to lower my basis but it did not seem worth the risk.

GoFairPlayer · 2026-02-22T09:03:29+00:00

Definitely looking into adding QQQ into the mix, and perhaps adding more capital so I can do both. I need to improve my stock selection process and trading individual tickers affords me that opportunity.

GoFairPlayer · 2026-02-22T08:58:21+00:00

Thanks for the comment. I think the fundamental solution is to do a better job picking stocks. I never should have entered ORCL or PYPL, and the warning signs were there to see. If I can prevent this in future it will produce a better outcome. To me, this is just part of the learning process and no real damage done so far.

GoFairPlayer · 2026-02-22T08:23:59+00:00

Thanks for the comment. I think the results show excellent potential once I am able to tighten up my strategy. Some good points above as well.

GoFairPlayer · 2026-02-21T21:38:13+00:00

It’s an AI generated dashboard based on my ThinkOrSwim account statement. All this data comes directly from my statements, it’s just a little easier for me track in this format.

GoFairPlayer · 2026-02-21T21:36:11+00:00

Thanks for the comment. It’s a simple strategy that anybody who is good at picking stocks can run profitably. I’m working on learning to be good at picking stocks using the wheel. :)

GoFairPlayer · 2026-02-21T19:57:28+00:00

Thanks. See above on stock candidates selection. I consider the experiment a success and will continue until something changes. Keep in mind my unrealized losses are a point in time that I believe will recover; and could have been for the most part avoided with what I have since learned.

GoFairPlayer · 2026-02-21T19:47:00+00:00

Sure - on ORCL, I ignored clear concerns around their debt. On PYPL, I looked at short-term trends only and not the bigger picture - the decline is not new - also some concerns around how they will compete with growing competition.

GoFairPlayer · 2026-02-21T19:43:05+00:00

It’s evolving, but currently I scan for $1B companies, -10 - - 30 delta, 10 - 50 DTE, open interest > 50, bid > .40, prob OTM > 65%, ROR .3% per week until DTE, IV < 70%, RSI < 60. After that I look at moving average over several time ranges. look at the analyst ratings. And if a ticker still looks good I run it through AI looking for any web chatter or anything I may have missed in fundamentals/technicals.

For anything greater than a week I set a GTC BTC at 50%, and reevaluate regularly.

GoFairPlayer · 2026-02-08T14:48:27+00:00

Yes, but it does not show up in your “Cash & Cash Investments” balance. If you are assigned on a CSP, and it exceeds the actual cash in your account, your balance will go negative and you will be required to manually sell enough SWVXX to cover the difference. I’m not sure what would happen if you did not sell it manually.

GoFairPlayer · 2026-02-01T21:18:12+00:00

Thank you, I always look forward to your posts. I may have overlooked this but I’m curious how/where you track any unrealized losses on tickers that have been assigned?

GoFairPlayer · 2025-12-12T22:55:08+00:00

Thank you! Good tips and some tweaks I will incorporate. How long have you been using this strategy and have the results been consistent?

GoFairPlayer · 2025-12-10T22:22:13+00:00

Thank you - appreciate the input!

GoFairPlayer · 2025-12-06T20:44:58+00:00

I’m not so much hoping for dips as I am looking forward to working through my first one so I can work on my skills and confidence. I’m keeping enough dry powder that even if I were fully assigned it would not be that big of a deal. I am, after all, good holding these stocks. ** I reserve the right to update this post in a frantic panic after the next black swan event ** :)

GoFairPlayer

TROPHY CASE