Build a Screener With $0 of Tooling
Not financial advice. Verify claims independently.
Free data + open-source charting + a spreadsheet brain. Full parts manifest inside.
You do not need a Bloomberg to screen. Below is a surplus parts manifest that costs $0 and still produces a usable daily shortlist.
Parts manifest
- Data — Polygon free or FMP free for fundamentals; EDGAR for filings.
- Indicators —
pandas-taor TA-Lib (BSD/MIT). - Charts — TradingView free layouts, or a local Plotly notebook.
- Brain — a Google Sheet / LibreOffice sheet with named ranges for thresholds.
- Rehearsal — Stock Picks paper account for the names that pass.
Assembly
Pull EOD closes into a DataFrame. Compute RSI, SMA-50/200, and average dollar volume. Flag names where RSI < 30, price > SMA-200, and ADV > $5M. Dump the CSV into the sheet. Review before the open. Paper-trade the top three.
Why paper first
Screener output is a hypothesis, not a signal. Size it like it can go to zero. Practice exits until they are automatic — then decide if real capital belongs in the kit.
Put it into practice
Rehearse this strategy risk-free on Stock Picks — the reference free paper-trading tool listed in the Mkts/Apps field manual.
Open Stock Picks →