Options
Options
As of 2026-05-10
Open positions
Open short contracts
Open unrealized P&L
Closed realized P&L
Expiry calendar (open positions)
Open positions — short
Currently held short contracts with a future expiration. Premium received was booked at open; unrealized = (premium received − current MV). Realized = any partial-close P&L already locked in.
Open positions — long
Closed positions
All option contracts the walker has fully or partially closed. Total realized P&L per contract. Acid test: a fully-closed contract should have qty=0 and the realized number is the lifetime P&L for that lot.
Expiring soon (next 30 days)
Open options with ≤30 days to expiration — the rolling/closing decisions you'd want to flag.
Data quality: stuck positions (post-expiry, qty ≠ 0)
These would be expire/assign events the walker missed. Today's snapshot is sourced from SnapTrade's live feed, which only returns currently-held positions, so stuck contracts are pruned automatically — empty here = clean.
Dataset is empty - query ran successfully, but no data was returned from the database
