Stock Blueprint

Google Apps Script engine (Code.gs, bound to the Google Sheet "Copy of Stock Blueprint"), a Windows PC bridge for screener.in, and a research dashboard website (web/) built on the same rules.

Path	What
Code.gs	All Apps Script code (V8) - the authoritative engine
pcbridge/ScreenerBridge/	Python bridge + .bat helpers (runs on the Windows PC)
web/	Static dashboard: Overview, Watchlist, My Watchlists (your own lists, saved in the browser and - with your PIN - in the sheet, so every device shows the same lists), Daily Suggestions, Industries (official NSE 4-level explorer, docs/INDUSTRIES.md), Strategy Settings, Patterns & FVG, Excel Analysis, Results, Alerts & Trades, Backtesting, IPOs & Markets. Reads the sheet live through api/site (saved copy in web/data/ as fallback)
web/lib/	Engine modules (patterns, FVG, indicators, strategy, risk, backtest, classification, xlsx reader) - shared with the Node tests
api/	Vercel functions: live site feed (api/site, from the sheet's web app), My Watchlists sync (api/watchlists, PIN checked by the sheet) and market-data providers (Dhan / your sheet / none)
tools/	export_xlsx.py (sheet export → web/data), analyze_workbook.js, build.js
tests/	node --test suites, incl. parity with the sheet's own outputs
docs/	ARCHITECTURE.md, STRATEGY.md, MARKET_DATA.md, DEPLOY.md

Website: see docs/DEPLOY.md (live feed setup in 7 steps, localhost, Vercel, Firebase). Live: https://stock-blueprint-sandy.vercel.app/ - the Firebase copy uses the same API (web/config.js). Without the feed the pages show the saved copy with a "Showing a saved copy" banner. Checks: npm test && npm run lint && npm run typecheck && npm run build.

Apps Script deploy

./tools/check.sh
clasp push
clasp deployments                       # find the EXISTING web-app deployment ID
clasp deploy -i <EXISTING_ID> -d "note" # never create a new deployment

Time triggers use the pushed code at once. The web app (/exec, used by the PC bridge and the website feeds snapshot / site) only sees a change after clasp deploy -i.

PC bridge

Copy pcbridge/ScreenerBridge/ to the PC, run Setup.bat. config.json holds the URL + token and is git-ignored.