TradingView

Build a local-first market charting app called "deskchart". Single user, runs on my machine, no accounts, no telemetry, no cloud. Stack, not negotiable: - Vite + React + TypeScript for the UI - lightweight-charts (MIT, from TradingView) for rendering candles and overlays - A small Express + TypeScript server in the same repo as a data proxy and cache - SQLite via better-sqlite3 for candle cache, watchlists and alerts - pnpm workspaces, one command to run both: pnpm dev Data: - Crypto: Binance public REST klines endpoint, no key needed, treat this as the real-time path - Equities and ETFs: Stooq daily CSV as the default source, with an optional adapter interface so another provider can be dropped in via .env - Cache every fetched candle range in SQLite and only request the missing tail on reload - Put any API keys in .env, read via a single config module, ship .env.example. Never hardcode secrets - Print a visible "DELAYED" badge on any symbol whose source is not real time. Do not pretend otherwise Features in scope: - Symbol search over a locally seeded symbol list, watchlists stored in SQLite - Candlestick chart with timeframe switcher: 1m, 5m, 1h, 1d, 1w - Indicator overlays computed client side: SMA, EMA, VWAP, RSI and MACD in a lower pane - Persisted horizontal price lines and trendlines per symbol, saved to SQLite - Simple alerts: price crosses above or below a level. Server polls every 60s and fires a desktop notification via node-notifier plus a row in an alerts log - Dark theme, keyboard shortcuts for timeframe and symbol switching Explicitly out of scope, do not attempt: - Any scripting language or Pine Script compatibility - Broker connections or order entry - Social feed, published ideas, comments - Multi-user auth, hosted deployment, mobile apps - Scraping any paid or authenticated data feed Deliverables: working repo, README with setup and a blunt "data limitations" section, seed script for symbols, and vitest coverage on the indicator math and the cache-gap logic.