Days to Expiry — Options Portfolio Tracker logo
Days to Expiry
Options Portfolio Clarity

The Wheel Strategy Spreadsheet Alternative That Syncs Your Broker Automatically

A wheel spreadsheet is only as good as your last manual update. Days to Expiry replaces the Sunday data-entry ritual with automatic broker sync (IBKR Flex + SnapTrade 32+), roll-adjusted cost basis through assignments, and a weekly execution plan.

The wheel strategy spreadsheet is a rite of passage: cash-secured puts, assignments, covered calls — all logged by hand in Google Sheets or Excel. Public DIY templates are free, but they are downloads, not connections: every fill is typed in, one broken formula silently corrupts your cost basis, and the weekly reconciliation eats the evening before market open. Days to Expiry is the wheel strategy spreadsheet alternative that keeps the simplicity and drops the data entry. Connect Interactive Brokers via Flex Query or 32+ brokers via SnapTrade, and every CSP, roll, assignment, and covered call flows in automatically — normalized for commissions, splits, and corporate actions. You get roll-adjusted true cost basis per wheel cycle, per-leg P&L, coverage views, and a weekly execution plan for what to sell next. Start with the free screener and demo portfolio — no credit card.

DaysToExpiry income dashboard

Tap to view full size

Problem

Your Wheel Spreadsheet Is Only As Good As Your Last Manual Update.

Manual Entry on Every Trade — Every CSP, covered call, roll, and assignment is typed in by hand before you can analyze anything

Silent Formula Errors — One broken cell and your cost basis is wrong for the rest of the wheel cycle, and nothing flags it

No Broker Sync — Public DIY wheel trackers are file downloads with walkthrough videos, not live broker connections (austinsnerdythings.com, verified 2026-09-23)

Sunday Reconciliation Ritual — Rebuilding weekly P&L from broker statements instead of planning next week's trades

Solution

Days to Expiry: The Same Wheel Discipline, Minus the Spreadsheet

Automatic Broker Sync

IBKR Flex first-class; SnapTrade for 32+ brokers; trades, rolls, and assignments flow in without typing

True Cost Basis After Rolls

Wheel cycles re-priced through every roll, assignment, and covered call — automatically

Per-Leg P&L

See which legs of a cycle drive profit and which drag, without rebuilding formulas

Coverage & Income Dashboard

What's covered, what's naked, and how premiums stack into weekly and monthly income

Weekly Execution Plan

A bounded action list from your live book — rolls, closes, and new CSP/CC candidates

CSV Fallback Import

Upload a broker CSV statement when API sync isn't an option

DaysToExpiry portfolio view

Tap to view full size

How it works

Get started in 3 simple steps

1

Connect Your Broker

Link Interactive Brokers via Flex Query or connect 32+ brokers through SnapTrade. The connection is read-focused; Days to Expiry never places trades. Historical positions and fills import so the wheel cycles you already ran are in the book.

2

Watch Wheel Cycles Rebuild Themselves

CSPs, assignments, and covered calls chain into cycles with roll-adjusted cost basis and per-leg P&L — no formulas to maintain. Commissions, stock splits, and corporate actions are normalized automatically.

3

Plan the Week From the Live Book

The weekly execution plan turns your actual holdings and cash into a bounded list of what to sell, roll, or close — with model assignment probability and premium context. Run dedicated wheel backtests when you want historical rates behind a setup.

Key Metrics

Trial card

Not required

Manual Entry

None

Brokers via SnapTrade

32+

Free Trial

14 days

Key Specs

SpecValueSource
PricingFree — public DIY wheel trackers are distributed at no cost (one example: an Excel-based wheel tracker published with a download link and a walkthrough video).Verified 2026-09-23
Broker syncNot offered / not stated on the cited template — DIY spreadsheets are manual-entry files; there is no IBKR Flex or SnapTrade connection to sync fills automatically.Verified 2026-09-23
Cost basisManual only — cost basis depends on the trader's own sheet formulas; roll and assignment adjustments must be modeled by hand.Verified 2026-09-23
MaintenanceManual per-trade entry and upkeep; community trackers ship with video walkthroughs precisely because maintaining them is hands-on.Verified 2026-09-23
PlatformGoogle Sheets / Excel files — local or cloud documents, no app, no sync layer.Verified 2026-09-23
Weekly planNot offered / not stated — spreadsheets record trades; they don't generate an execution plan from live holdings.Verified 2026-09-23
Best forTraders starting out who want a free, hands-on way to log wheel trades and learn the mechanics.Verified 2026-09-23
Days to Expiry Pro pricePro $50/mo ($500/yr). Amounts from live Stripe prices API backing /pricing.Verified 2026-08-13
Days to Expiry free tier / trialDemo portfolio free; live portfolio via SnapTrade on Starter; backtests on Pro. No credit card to start, cancel anytime.Verified 2026-09-23
Days to Expiry syncSnapTrade for 32+ brokers, first-class IBKR Flex Query auto-sync, or CSV upload — with commissions, splits, and corporate actions normalized.Verified 2026-09-23

Frequently Asked Questions

Everything you need to know about getting started

Why switch from a free wheel spreadsheet at all?

Because free buys the file, not the workflow. Public wheel trackers are manual-entry spreadsheets — every trade typed by hand, cost basis maintained through your own formulas, and no live broker connection (verified against a widely shared Excel wheel tracker, 2026-09-23). The spreadsheet doesn't fail loudly: a single broken cell quietly corrupts your basis for the whole cycle. Automation removes the typing and the silent errors — you keep the wheel discipline and get your Sunday evening back.

Will my wheel history carry over?

Yes. Connect via SnapTrade or IBKR Flex and historical positions and transactions import; for anything older or unusual, upload your broker's CSV statement as a fallback. The system normalizes commissions, splits, and corporate actions, then chains CSPs, assignments, and covered calls into cycles with roll-adjusted cost basis.

Can I keep my spreadsheet alongside Days to Expiry?

Of course. You can run both for a few weeks: the sheet as a scratchpad, Days to Expiry as the source of truth, until the weekly plan and synced P&L replace the manual reconciliation.

How is roll-adjusted cost basis different from my sheet's average cost?

A typical sheet averages premiums collected against the share position. Roll-adjusted basis treats every event — put premium, assignment, covered call premium, rolls up and out — as part of one cycle, so your true break-even reflects the whole wheel, not just the last leg. That is the number that decides whether a cycle is actually profitable.

What does the weekly execution plan give me that a tracker doesn't?

A tracker tells you where you are; the plan tells you what to do next. Each week it reviews your live book — cash, covered shares, open CSPs and calls nearing expiration — and produces a bounded list of rolls, closes, and new candidates with model assignment probability and premium context. That's the judgment call you'd otherwise rebuild in a spreadsheet every weekend.

What does Days to Expiry cost after the trial?

Pro is $50/mo ($500/yr) from the live Stripe prices backing /pricing, with Starter below it for live sync and Alpha above for power users. The demo portfolio and covered call screener stay free — no credit card to start, cancel anytime.

Ready to Get Started?

Join traders who are already using our tools to make better decisions.