← Back to Portfolio

Stocks App Analytics Pipeline

A batched analytics pipeline that screens roughly 12,000 US tickers per cycle, turning raw market data into actionable buy/sell/hold signals through scheduled processing across historical, daily, and hourly timeframes.

Screening at Scale

Screens ~12,000 US tickers per cycle across five batched Google Sheets feeds, with staging tables, validation, and failure logging.

Technical Indicator Suite

Computes 10 indicators per ticker - RSI, MACD, Bollinger Bands, ATR, Beta, Stochastic, Williams %R, OBV, Ease of Movement, and standard deviation.

Automated Signal Engine

Generates buy/sell/hold signals and a 52-week-high screener, emailing only threshold-matching tickers to a private client base.

Pipeline Health & Reporting

Per-batch error reporting, auto-cleanup, and a health dashboard tracking ingestion across each processing timeframe.