Bringing a Sell Put Account to the Web: Designing the Portfolio System
The Night My Excel Collapsed
One Sunday night this April, I was updating my trading ledger.
A single Excel file, 17 columns: entry date, underlying, strike, expiration, premium, margin, closing price, P&L... I'd used it for two years and it had always worked. Until that night, when I found: 3 expired settlements I'd forgotten to log, 2 early closes with miscalculated premiums, and a margin column that hadn't been updated since March.
I spent an hour and a half reconciling. Then I stared at the screen and thought: I sell tools for a living, yet my own books live in a pile of Excel.
In that moment I decided: move the Sell Put account onto the web. That became "My Portfolio."
Three Things Excel Can't Do
1. Real-time data. Floating P&L, remaining OTM cushion, the expiration queue—everything changes minute by minute. The number in Excel is forever the moment you last typed it in.
2. Consistency. Premium in gross or net? Which trade absorbs the commission? In Excel it's all self-discipline; three months later you can't read your own conventions.
3. Linkage. When a position changes, risk metrics should change with it; when a trade fills, the dashboard and batch should update automatically. In Excel, that's called "add six more formulas."
The Module Map of the Portfolio System
The shipped system has five modules, mapped to my five daily routines:
| Module | What It Replaced | Core Functions |
|---|---|---|
| Summary Dashboard | Excel front page + broker screenshots | Net assets, return trend, portfolio distribution, Sell Put trade overview |
| Position Batches | The master ledger | Batch management for each entry—margin, alerts, settlement status |
| Trade Ledger | Manual statement entry | Filter, record, edit—auto-tracked commissions and realized P&L |
| Capital Management | Another sheet | Initial capital and every deposit/withdrawal, newest first |
| Risk Control Hub | The discipline in my head | Rules turned into thresholds, with email alerts on breach |
The Order Desk lives on this layer too—from opportunity to fill, fills flow into the ledger, the ledger flows into batches, batches flow into the dashboard. One pipeline, nothing touches the ground.
Trustworthy Data Is the Bottom Line
Building a portfolio tool is different from building an analysis tool. If an analysis tool's numbers are off, users grumble. If a portfolio tool's numbers are off, users lose money.
So every key number in the system carries two things:
- Data validation: multi-source cross-checking—when sources disagree, it's flagged, never glossed over
- Freshness indicators: every number shows its update time; stale data is called out, not dressed up as fresh
I'd rather tell you "this number is 15 minutes old" than let you believe it's live. I learned that from being burned by delayed data myself.
What Users Said
| User Feedback | My Response |
|---|---|
| "Can I review early closes separately?" | Added an early-close review module |
| "Expiration week is the scariest to forget—can there be a calendar?" | Added an expiration capital calendar and a position expiry queue |
| "Did my profit come from premium or price movement?" | Added a profit-source breakdown |
| "Can commissions be itemized?" | Entry/exit commissions tracked separately, with per-contract averages |
As the old saying goes around here: many features aren't planned—they're pushed out by users.
I'm vuca, founder of Hyperstock. Want to talk? service@hyperstock.net
