Stock Portfolio Tracker (with Dividends)

What you get

A single Excel workbook built for monthly manual updates — no add-ins, no live data feeds, no API keys required. Enter current prices and dividend payments once a month and the workbook recalculates unrealized gains, sector weights, and yield on cost across every position automatically.

Who it's for

DIY investors who manage their own brokerage account and want a clear, low-maintenance record of where their money sits, how much it has grown, and how much passive income it is generating year over year. It is the right tool at the point when a spreadsheet cobbled together from scratch stops being good enough.

What's inside

• Holdings Sheet — logs each position by ticker, number of shares, average cost basis, and current price, with unrealized gain and gain percentage calculated automatically.
• Sector Allocation View — breaks your portfolio into sector weights so you can see concentration at a glance without running a separate analysis.
• Dividend History Sheet — records every dividend payment chronologically by ticker, date, and amount, building a permanent payment log over time.
• Yield on Cost Calculator — shows the effective dividend yield against your original cost basis for each position, not just the current market yield.
• Passive Income Tracker — aggregates annual dividend income and places it side by side across years so income growth is immediately visible.
• Realized Gains Sheet — logs every closed position with entry and exit data, tagged Short Term or Long Term for straightforward tax-season reconciliation.
• Monthly Update Flow — a single input area for current prices and new dividend entries keeps the monthly maintenance to under ten minutes.

How to use it

Download the file and open it in Microsoft Excel 2016 or later, or in Google Sheets via File, Import. Start by entering your existing positions — ticker, share count, and cost basis — into the Holdings Sheet. From there, update current prices and log any dividend payments at the end of each month. All calculated fields refresh immediately without any additional steps.