Stock Portfolio in Excel, the 5 live metrics most investors never track

About this tutorial

Stock Portfolio in Excel is one of the most searched personal finance tasks, yet most spreadsheets people build are static, manually updated, and missing the signals that actually drive buy and sell decisions. This live session shows you how to build a fully automated, real-time portfolio tracker inside Excel using MarketXLS, so your data refreshes itself and your decisions are grounded in current numbers, not yesterday's close. What you'll see: - Pulling live price, daily change, and volume for every ticker in your portfolio using MarketXLS functions like =mxs_last() and =mxs_change_percent(), all updating in real time inside a single Excel sheet - Building a position-level P&L column that calculates unrealized gain or loss automatically as prices move, using your cost basis entered once in a dedicated input column - Adding a portfolio weight column that recalculates each holding as a percentage of total market value the moment any price shifts, so concentration risk is always visible - Pulling dividend yield and next ex-dividend date per ticker so income investors can see at a glance which positions are contributing yield and which are not - Constructing a sector breakdown summary table using a grouping formula tied to a MarketXLS sector field, giving you instant diversification visibility without a pivot table rebuild every session - Setting up a conditional formatting layer that flags any position down more than 5 percent on the day in red and any position hitting a 52-week high in green, directly on the dashboard Why this matters: a stock portfolio in Excel that updates live changes how you interact with your holdings. Instead of logging into a brokerage app and mentally stitching together numbers across accounts, you have one authoritative view that reflects the market as it moves. That single view makes it faster to spot a position growing too large, catch a dividend cut before reinvesting, or decide whether a down day in one sector is isolated or broad. For anyone managing their own investments, a live spreadsheet replaces guesswork with data and reduces the lag between market movement and your awareness of it. This session is useful for self-directed investors who already use Excel for budgeting or analysis and want to extend that comfort into portfolio management. No advanced Excel skills are required. If you can enter a ticker symbol and copy a formula down a column, you can follow along and leave with a working tracker. Built live in Excel with MarketXLS real-time data during this broadcast. A link to the template used in the demo is in the description below so you can download it and drop in your own tickers immediately after watching.