Neydran
NSE stock screener and trading journal
Solo: architecture, backend, frontend, infrastructure
A live screener for Indian equities that shows its working. Instead of a score, every result carries the rules, numbers, and failed breakouts behind it.
- Ingests 5 years of NSE market data (3.3M+ price rows, 140 indices) into PostgreSQL and screens the Nifty 500 against an 8-rule trend template, recording every rule per stock.
- Terraform-managed Cloud Run stack with keyless GitHub WIF deploys. CI gates on Trivy, pip-audit, and gitleaks before Alembic migrations and a health check.
- Mandatory TOTP 2FA enforced at three layers (Next.js routes, FastAPI aal2 checks, Postgres row-level security). Chart queries cut from 1.28s to 0.09s with a composite index verified via EXPLAIN ANALYZE.
- NSE's bot filter returns 403 to cloud IPs, so ingestion runs as a scheduled job on a home machine, watched by a Cloud Run watchdog that alerts on missed trading days.
- price rows ingested
- 3.3M+
- chart query
- 1.28s → 0.09s
- backend tests
- 116
Next.js · FastAPI · PostgreSQL · Terraform · Cloud Run · GitHub Actions