Spread Monitor

Overview

Spread Monitor is an internal trading tool built to eliminate the manual, time-consuming process of checking stock spreads across the marketplace. What used to take hours now takes minutes.

The platform pulls live market data, calculates spread formulas, and surfaces the most relevant stocks — all in a clean, fast dashboard. Users can save favorites, set alert conditions, and receive signal emails when their criteria are met.

---

Problem

Traders were manually checking spreads across dozens of stocks each session — a repetitive process that was:

• Time-consuming — hours spent per session on manual lookups
• Error-prone — formula recalculations done by hand
• Reactive — no way to get notified when a spread hit a target
• Unstructured — no way to save or track stocks of interest

---

Solution

A lightweight, automated monitoring platform connected to Google Sheets as the data layer — powered by App Script for automation and Next.js for the UI.

Key Features

• Live spread tracking — Automatically pulls and calculates spread data using custom formulas
• Favorites — Users can bookmark stocks they want to track closely
• Signal alerts — Configurable email notifications sent when a spread meets a target condition
• Authentication — Secure login so only authorized users can access the dashboard
• Fast & lightweight — Deployed on Vercel, no backend server to maintain

---

How It Works

1. Google Sheets stores the stock data and spread formulas — familiar and flexible for non-technical users to manage
2. App Script runs on a schedule to refresh data, evaluate conditions, and trigger email alerts
3. Next.js reads from Sheets via the Google API and renders the live dashboard
4. Vercel handles deployment and environment variables with zero-config CI/CD

---

Outcome

• ⏱️ Hours → minutes — spread checking time dramatically reduced per session
• 📬 Signal emails — traders get notified automatically instead of manually checking
• ⭐ Favorites — quick access to the stocks that matter most
• 🔐 Secure access — login-protected so data stays private
• 🚀 Zero maintenance deploys — Vercel + App Script handles everything automatically

---

Tech Stack

---

Conclusion

Spread Monitor is a great example of using the right tools for the job — Google Sheets as a familiar, maintainable data layer, App Script for automation, and Next.js on Vercel for a fast, polished UI. Together they deliver a production-grade tool without the overhead of a full backend.