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
AgentBnB: A Multi-Agent System Built by a Non-Coder Using Claude Code
A real estate agent with no coding background built AgentBnB, a system where autonomous agents can find each other, hire each other, pay each other, and settle bills without manual intervention. The project currently has 29 GitHub stars and features identity, escrow, reputation, and relay network systems.
AI agent cost breakdown: $12 monthly with local models and cloud APIs
A developer ran an AI agent for a month using Mac Mini + Ollama for local models and cloud APIs, costing $12 total with 80% local usage at $0 and 20% cloud usage at ~$12. A single retry loop consumed $4.80 in 11 minutes, prompting circuit breaker implementation.
OpenClaw Architecture: Building a Persistent AI-Driven Distribution Engine
OpenClaw's architecture, featuring a daemon-driven approach with small composable tools, declarative recipes, and a memory layer, enables continuous and efficient automation workflows.
Practical Lessons from Building an E-commerce AI Agent with OpenClaw
A developer shares specific infrastructure, security, and workflow insights after spending 100+ hours building an e-commerce AI agent with OpenClaw, including VPS setup on Digital Ocean ($24/month), model cost management with Kimi K2.5 and Gemini Flash, and memory architecture recommendations.