Options & Stock Tracker Spreadsheet
Budget: $250 – $750 USD
I need a single spreadsheet—Excel or Google Sheets—that lets me stay on top of covered-call and naked-put activity across multiple brokerage accounts. Each day I’ll drop the raw trade CSVs straight from the brokerage download; the file should pull that data in automatically, recognise the account it belongs to, and slot every leg into an open-position log.
A dedicated summary page must always show, at a glance:
• an overview of every open position (underlying, expiry, strike, side, quantity)
• the current distance between market price and each strike
• my total capital deployed and remaining buying power
Because I frequently roll positions, the model has to detect and carry forward both rolling covered calls and rolling naked puts, linking each new leg to its originating trade so returns are aggregated correctly. I should be able to filter by account, symbol, or strategy and instantly see realised P/L, unrealised P/L, and overall ROI.
For reporting, I want clean dashboards and printable statements that summarise weekly and monthly performance plus an export feature if I ever need a standalone CSV of results.
If you’re comfortable using formulas, Power Query / Google Sheets queries, and (where helpful) light VBA or Apps Script for the automation pieces, you’ll know exactly how to build this. Once finished I’ll test it with live brokerage downloads; if every position reconciles, the roll tracking matches my notes, and the summary stays accurate after new imports, we’ll call it complete.
A dedicated summary page must always show, at a glance:
• an overview of every open position (underlying, expiry, strike, side, quantity)
• the current distance between market price and each strike
• my total capital deployed and remaining buying power
Because I frequently roll positions, the model has to detect and carry forward both rolling covered calls and rolling naked puts, linking each new leg to its originating trade so returns are aggregated correctly. I should be able to filter by account, symbol, or strategy and instantly see realised P/L, unrealised P/L, and overall ROI.
For reporting, I want clean dashboards and printable statements that summarise weekly and monthly performance plus an export feature if I ever need a standalone CSV of results.
If you’re comfortable using formulas, Power Query / Google Sheets queries, and (where helpful) light VBA or Apps Script for the automation pieces, you’ll know exactly how to build this. Once finished I’ll test it with live brokerage downloads; if every position reconciles, the roll tracking matches my notes, and the summary stays accurate after new imports, we’ll call it complete.