Track holdings, cost basis, and current value. Auto-calculates gain/loss, return %, and total portfolio value.

About the Stock Portfolio Tracker

Brokerage apps are good at showing you a single blended number and a green or red arrow, but they are poor at answering the questions that actually drive decisions: which position is carrying the portfolio, which one is quietly underwater, and what your true return is once you account for what you originally paid. This tracker lays every holding side by side so you can see the whole picture on one screen.

You enter a row for each position with its ticker, share count, cost basis per share, and current price. From those four inputs the tool computes market value, total cost, dollar gain or loss, and percentage return for every holding, then rolls them up into portfolio totals. Because it is a flat table you can add as many positions as you own and delete ones you have sold.

The point is not to replace your broker's execution, but to give you a clear-eyed performance review. When you can rank positions by return and by dollar contribution at a glance, rebalancing decisions and tax-loss harvesting candidates become obvious instead of buried inside a mobile app.

How the Stock Portfolio Tracker works

For each row, market value equals shares multiplied by current price, and cost equals shares multiplied by cost basis per share. The gain or loss in dollars is simply market value minus cost, and the percentage return is that gain divided by cost. A position priced above its basis shows green; one below shows red.

Cost basis per share should reflect what you actually paid, ideally including commissions spread across the shares, and adjusted for any splits. If you bought the same stock in several lots at different prices, enter the blended average cost basis so the return percentage is accurate for the whole position.

At the portfolio level the tool sums market value and cost across all rows, then computes total gain as total value minus total cost and total return as total gain divided by total cost. This is a simple aggregate return on invested capital, not a time-weighted or annualized return, so it answers how much you are up in total rather than your yearly rate.

Worked example

Consider the four default holdings. AAPL: 10 shares at a $150 basis now worth $210 is $2,100 in value against $1,500 cost, a $600 gain. MSFT: 5 shares from $300 to $430 is $2,150 versus $1,500, up $650. GOOGL: 8 shares from $120 to $175 is $1,400 versus $960, up $440. VTI: 15 shares from $210 to $270 is $4,050 versus $3,150, up $900.

Summed up, total market value is $9,700 and total cost is $7,110, so the portfolio's total gain is $2,590 and the total return is $2,590 / $7,110 = 36.4%. VTI is the largest single dollar contributor at $900 even though MSFT has the highest percentage return.

That split between dollar contribution and percentage return is exactly what the table is built to reveal. A high-percentage winner on a tiny position moves your net worth far less than a moderate gain on a large one, which is why looking only at return percentages can mislead you about where your money is really being made.

Tips & common mistakes

Enter blended cost basis for positions built from multiple purchases. Averaging your lots gives a true position-level return; using only your first buy price will overstate or understate how the whole holding is doing.
Update current prices when you actually want a snapshot rather than obsessively. Daily price noise tempts people into trading; a weekly or monthly refresh keeps you focused on the trend that matters.
Use the dollar gain column, not just the percentage column, to decide what to trim. A 60% gain on a $500 position is worth far less than a 15% gain on a $10,000 position when you rebalance.
Remember this tracks unrealized gains. Nothing here is a tax event until you sell, but the red positions are worth flagging as potential tax-loss harvesting candidates near year-end.
Keep index funds and individual stocks in the same table so you can see your true diversification. If one ETF like VTI already dominates your value, adding more single stocks may be adding less diversification than you think.

Stock Portfolio Tracker: frequently asked questions

Does the total return figure include dividends?

No. This tracker measures price return only: the change between your cost basis and the current price. If you want total return including dividends, either add received dividends to reduce your effective cost basis, or track dividend income separately with a dedicated dividend tool. For growth stocks that pay little or nothing the difference is minor, but for high-yield holdings it can be substantial.

How do I handle a stock split?

Adjust both your share count and cost basis to the post-split figures. If you owned 10 shares at a $200 basis and the stock split two-for-one, enter 20 shares at a $100 basis. Your total cost stays the same and your return percentage remains correct; only the per-share numbers change.

Is the total return annualized?

No, it is a cumulative return on your invested capital. A total return of 36.4% could have been earned over one year or over five, and the tool does not know how long you have held each position. For an apples-to-apples comparison against benchmarks, you would need to annualize it based on your actual holding period.

What should I put for cost basis on shares I received or inherited?

For inherited shares, cost basis is generally the market value on the date of death (a stepped-up basis), so use that price. For shares from an employer or a gift, use the basis your plan or the giver reported. Getting basis right matters because it directly determines both your displayed return and your eventual taxable gain.

Can I track cash or bonds alongside stocks here?

The table is built around shares and per-share prices, so it fits stocks, ETFs, and mutual funds cleanly. You can approximate a bond or cash position by treating units as shares at a $1 price, but for anything with coupon payments or accrued interest a dedicated fixed-income record will be more accurate.

Ticker	Market Value	Cost	Gain/Loss	Return %
	$2,100.00	$1,500.00	$600.00	40.0%
	$2,150.00	$1,500.00	$650.00	43.3%
	$1,400.00	$960.00	$440.00	45.8%
	$4,050.00	$3,150.00	$900.00	28.6%
Total	$9,700.00	$7,110.00	$2,590.00	36.4%

Stock Portfolio Tracker