Personal Finance Dashboard Built with Claude AI: Self-Hosted with Google Sheets Backend
A developer on r/ClaudeAI shared their personal finance dashboard project built with Claude AI. What started as a simple Python script evolved into a full-stack application that consolidates various investment types into a single interface.
Core Functionality
The dashboard brings together multiple investment categories including stocks, mutual funds, physical gold, and fixed deposits. It runs entirely on the developer's spare PC and is served via Cloudflare Tunnel.
Key Features
- Exposure Analysis: Shows not just what you own, but what you're actually exposed to. Before buying a stock, you can see if you're already overexposed to it through your funds.
- CAMS CAS Statement Parsing: Can parse CAMS CAS statements and provide detailed transaction insights.
- Data Storage: All data stays with the user - everything is stored in the user's own Google Sheets on their Google Drive. No databases are used.
- Holdings Sync: Supports syncing holdings via Zerodha or manual entry.
- Upcoming Features: NSDL/CDSL CAS support is coming soon.
Technical Implementation Notes
The developer noted that while AI was helpful in building the system, it still struggles with writing clean, modular code and designing scalable systems. Getting things right required significant iteration and careful prompting. The project was part of a personal learning journey to explore what it means to build a full system with AI, not just a toy application.
The application is accessible at https://metron.thecoducer.com/ and the developer is actively seeking feedback on what feels missing or broken.
📖 Read the full source: r/ClaudeAI
👀 See Also
How Fragile Test Scripts Caused Release Delays and What One Team Did About It
A team of about 15 engineers discovered their Appium test suite was consuming 50-60% of their QA engineer's time just for maintenance after a UI refresh broke locators, causing two releases to slip. They're now rebuilding tests using a tool that reads screens like a human and adapts to UI changes.
Production AI Coding Agent Failures: Real-World Patterns from Daily Use
A developer using Claude Code as their main dev tool for 2 months reports specific failure patterns from production use, including deploying client financial data to public URLs and 7 of 12 failures being caught manually rather than by automated systems.
How One Developer Fixed 16 Architectural Weak Points in Their AI Agent System
A developer documented 16 architectural problems in their OpenClaw AI agent system and implemented specific fixes including explicit layer definitions, gateway authorization, and evidence-based execution.
Practical Lessons from Building a 350K-Line Codebase Solo with AI Agents
A developer shares concrete engineering insights from building a 356K-line production codebase in 52 days using AI agents, including how codebase structure affects agent output and why strong typing is essential.