🚧 Coming soon
Coffee Can Terminal — a desk-mounted retro portfolio tracker
esp32gcpfirestorebigqueryclaude-apihardware
An ESP32 + OLED terminal, styled after a vintage CRT, showing a live personal-finance dashboard end to end — Cloud Scheduler, Cloud Functions, Firestore, BigQuery, and Claude for the daily narrative.
A desk-mounted, always-on terminal — green-on-black OLED, retro CRT aesthetic — showing a personal net-worth and portfolio dashboard, refreshed twice a day.
The pipeline, end to end:
- Cloud Scheduler triggers a Cloud Function twice daily, once before market open and once after close.
- The function computes portfolio metrics (XIRR vs. a benchmark, holding-age, allocation drift against targets) and asks the Claude API for a short daily narrative.
- Results land in Firestore as pre-formatted, display-ready strings — the ESP32 only reads and renders, it never calculates anything itself.
- Each day’s snapshot is also appended to BigQuery, building a historical archive.
- An ESP32 (WROOM-32) polls Firestore over WiFi and drives a small SH1106 OLED through a rotating set of terminal-style screens, with a passive buzzer for milestone alerts.
Status: hardware ordered, firmware not started yet — this is deliberately a from-fundamentals learning build (GPIO, I2C, PWM, Cloud Functions, Firestore), not a plug-and-play kit. The full build log, wiring diagrams, and firmware walkthrough land here once the breadboard prototype is working end to end.