Investment Portfolio Tracker - Track your stocks dividends P&L in one beautiful spreadsheet

by
A beautiful Excel template to manage your stock portfolio. Enter ticker, buy price, quantity — auto-calculates P&L, allocation %, total returns. Includes live Dashboard, Holdings Tracker, Transaction Log, and Dividend Tracker with summaries. 180+ built-in formulas, color-coded profit/loss, dark professional theme. No macros, no subscriptions — one-time purchase. Works with Excel 2016+ and WPS Office.

Add a comment

Replies

Best
Maker
📌
Hey Product Hunt! 👋 I built this because I was tired of juggling between multiple apps and spreadsheets just to track my stock portfolio. Most tools are either too complex or require expensive subscriptions. This Excel template does everything I needed: real-time P&L tracking, dividend summaries, transaction history, and a clean dashboard — all with zero setup. It's a one-time purchase, no recurring fees. I'd love your feedback and feature suggestions! What would make this even more useful for you? 🙏

Love the dividend tracker. One idea that would make this way more useful for me: add a way to automatically pull in current stock prices so the P&L and allocation columns update on their own. Right now I have to manually look up prices each week, which kind of defeats the purpose of auto-calculations. Even if it required a simple copy-paste of price data into one tab, it would save a ton of time and keep the dashboard truly current.