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
Operational Memory Over Automation: Why Small Business Agents Need to Remember
The real value for small business AI agents isn't automation — it's operational memory. A white paper from McPhersonAI argues agents should behave like disciplined operators: remember standards, notice drift, preserve context, and surface what matters.
OpenClaw Agent Structure: 5 Core Files and 3 Practical Use Cases
An OpenClaw user found that all agents are built from five core files: User, Soul, Agent, Tools, and Identity. They shared three working agents including a daily AI briefing aggregator, a math coach for children, and a YouTube Shorts generator.
Using Claude Code to Build a Drupal Site with Custom Twig Templates
A developer used Claude Code to create a Drupal website with custom Twig templates and raw HTML, bypassing traditional Drupal theming. They employed ddev for local development and specific commands to configure content types, views, and taxonomies.
Developer shares token cost challenge with Claude-built ERP system
A freight forwarding business owner built a 3,000+ line ERP system with Claude, but now faces 60,000-80,000 token costs per message due to loading the entire single HTML file. They're considering modularization or Firebase migration to reduce costs.