Options Screener

I need a custom options screener that will quickly surface the best trade opportunities across both call and put contracts. The primary goal is simple: filter live market data so I can spot setups worth acting on, without wading through every strike and expiration by hand.

Here is what I have in mind:
• Pull current option chains for my chosen tickers (US equities to start).
• Apply configurable filters—strike proximity, days-to-expiration, volume/open-interest thresholds, implied volatility, or any other smart metric you suggest—to highlight trades with an attractive risk-reward profile.
• Present the shortlisted trades in an intuitive table or dashboard, sortable by key statistics and linked back to the underlying chart.

I am flexible on the tech stack; Python with pandas, yfinance, and Plotly works, but I’m open to Excel VBA, Google Sheets with API connectors, or another approach you recommend as long as it updates in near-real-time during market hours.

Deliverables
1. Working screener script or workbook with clear setup instructions.
2. Parameter panel where I can switch filters on/off and adjust values without touching code.
3. Brief documentation (or loom video) showing how to run, modify, and extend the tool.

Acceptance criteria: the screener must fetch the latest option chain for at least five tickers concurrently, apply my chosen filters in under 10 seconds, and output a list of no more than 50 potential trades with fields for symbol, strike, expiry, delta, IV, bid-ask spread, and open interest.

Let me know your proposed approach and any clarifying questions—eager to start refining this together.