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.
