Stock Tracker
- Google Sheets
- Apps Script
- HTTP
A custom Google Sheets-based portfolio tracker that pulls live stock data via HTTP requests and calculates the financial ratios that matter, P/E, market cap, dividend yield, and more.
It aggregates recent news, surfaces insider buying and selling activity, and presents everything in a clean spreadsheet interface for fast, at-a-glance decisions.
Highlights
- Real-time price and metric retrieval from the web
- Automatic financial ratio calculations (P/E, market cap, yield)
- Latest market and ticker-specific news updates
- Insider trading alerts in a clean spreadsheet UI
Gallery
