Every angel investor starts with a spreadsheet. One tab per company, a column for the check size, a column for the date, maybe a column for "notes." It's clean. It's satisfying. For about three companies, it's even accurate.
Then you make a fourth investment, and a fifth. The updates start arriving on different days, in different formats — one founder sends a Notion link, another sends a PDF, a third just texts you "doing well!" The spreadsheet stops being a record of your portfolio and starts being a record of how far behind you are on updating it. This is how most angel investors actually track their portfolio — not because they don't care, but because nothing forces the information into one shape.
The portfolio spreadsheet that starts clean and dies by company three
The spreadsheet isn't the problem. The problem is what it's missing: it only has the numbers you remembered to type in, on the day you remembered to type them.
Three months later, you're looking at a cell that says "Revenue: $40k" with no date, no context, and no idea if that's this month's number or the one from the last update you happened to open. Multiply that across five, eight, twelve companies, and the spreadsheet becomes a museum of partial information — accurate the week you built it, fiction by the second quarter.
What's actually happening: you don't have a portfolio tracker. You have a list of companies you've invested in, and a separate, scattered archive of the updates they've sent — living across email, Drive, WhatsApp, and whatever the founder's tool of choice was that quarter.
TVPI, DPI, and RVPI — the numbers most angels never calculate
Ask most angels how their portfolio is performing and you'll get a vibe, not a number. "A couple of these are doing really well." "I think I'm up overall." That's not a tracking problem — it's that the actual portfolio metrics never got calculated in the first place.
Professional funds report three numbers to their LPs every quarter:
- TVPI (Total Value to Paid-In) — your total value, realised plus unrealised, divided by what you've put in. The headline "is this working" number.
- DPI (Distributions to Paid-In) — what you've actually gotten back in cash. The "is this real yet" number.
- RVPI (Residual Value to Paid-In) — what's still on the table, unrealised. The "what's left to play out" number.
Angels rarely calculate these because doing it by hand means pulling the latest valuation for every company, normalising it, and doing the maths — and most angels are doing this from memory and a spreadsheet that's three months stale.
Portfolios of 15–25 companies have historically returned around 2.5–2.6x — but only 61% of angels running multiple positions hit even 1x (Angel Investor Statistics, coinlaw.io). The gap between those two groups isn't stock-picking. It's whether they could see, in real time, which positions needed attention.
What to do: these three numbers, even rough, tell you more about your portfolio in ten seconds than an hour of scrolling through old emails. If your tracking setup can't produce them on demand, it's not actually tracking your portfolio — it's archiving it.
Updates land in five formats, on five different days
Here's the part that doesn't show up in any portfolio-construction advice: the operational cost of just receiving updates.
One founder emails a deck every quarter. Another posts in a shared Slack channel you have to remember to check. A third sends a one-line WhatsApp message that says "all good, will send numbers soon" — and then doesn't. None of these arrive on the same day, in the same format, or with the same metrics, which means every portfolio review starts with twenty minutes of finding the updates before you can even read them.
The founders who send nothing are usually the ones worth worrying about most — and they're also the easiest to lose track of, because there's no missing-update alert. You only notice when you go looking, three months later, and realise you haven't heard from them since spring.
What to do: the goal isn't to chase harder. It's to remove the format problem entirely — every company reporting into the same structure, on the same cadence, in the same place, so a missing update is visible the moment it's missing.
Concentration risk hides until it's too late
Most angels can tell you their largest position by check size. Almost none can tell you their largest position by current value — which is the number that actually matters when something goes wrong.
A $10k check that's now worth $80k on paper might be 40% of your portfolio's total value, even though it was 10% of your capital deployed. If that company stumbles, it's not "one of twelve companies" — it's nearly half your portfolio. Most angels find this out the hard way, after the fact, instead of seeing it coming.
This is what professional funds call concentration risk, and they monitor it constantly — usually with an HHI (Herfindahl-Hirschman Index) score that grades how concentrated a portfolio is, from well-diversified to dangerously top-heavy. Angels almost never compute this, because it requires current valuations across the whole portfolio, recalculated continuously — exactly the thing the spreadsheet can't do.
What to do: concentration risk isn't something you check once a year. It shifts every time one company's valuation moves. If your tracking setup can't recompute it automatically, you'll only find out when it's already a problem.
What tracking a portfolio actually looks like
None of this is solved by a better spreadsheet template — there are dozens online, and they all have the same blind spot: they're only as current as the last time someone manually typed numbers in.
What actually works is the inverse: every portfolio company reports into one structured place, automatically, the same way every time. You're not collecting updates anymore — they're already there, already in the same format, the day they're sent. TVPI, DPI, and RVPI are calculated from current numbers, not whatever was last typed in. Concentration is recalculated every time a valuation changes, not once a year when someone remembers to check.
The shift isn't "track harder." It's "stop being the place where the tracking happens."
◆ ◆ ◆
That's the gap Quantro for investors is built to close — founders publish structured updates that land directly in your portfolio dashboard, with TVPI, DPI, and RVPI calculated per company and across your whole portfolio, plus an HHI concentration grade so you can see when one position has quietly become half your book. No spreadsheet, no chasing, nothing to type in by hand. If you're managing more than a couple of positions and you're tired of being the one doing the math, it's worth a look.
If you're also wondering what a good update from one of your founders should contain, we wrote about that from the other side — useful if you want to set expectations with your portfolio companies.
Frequently asked questions
How do angel investors track their portfolio?
Most start with a spreadsheet — one row or tab per company, manually updated whenever a founder sends new numbers. This works for two or three companies but breaks down past that, because updates arrive in different formats on different days and the spreadsheet only reflects whatever was last typed in. Tools built for portfolio tracking solve this by having companies report into one structured format automatically.
What is TVPI and DPI for angel investors?
TVPI (Total Value to Paid-In) is your total value — cash returned plus current value of what you still hold — divided by what you've invested. DPI (Distributions to Paid-In) is just the cash you've actually gotten back, divided by what you've invested. TVPI tells you if it's working on paper; DPI tells you if it's real yet.
What's the difference between TVPI, DPI, and RVPI?
TVPI is the total picture (realised + unrealised, divided by capital invested). DPI is the realised slice — actual cash back. RVPI is the unrealised slice — current value of what you still hold, divided by capital invested. TVPI = DPI + RVPI.
How do I calculate portfolio concentration risk?
The standard measure is the HHI (Herfindahl-Hirschman Index) — calculated from each holding's share of your portfolio's total current value, not its original check size. A portfolio where one company has grown to represent 40% of total value is highly concentrated, even if that position started as a small check. This needs to be recalculated whenever a company's valuation changes.
How often should angel investors review their portfolio?
Monthly, if your portfolio companies are sending monthly updates — which is the cadence that works best for both sides. The review itself should take minutes, not hours, if the updates are already structured and in one place. If a portfolio review takes an afternoon, the bottleneck is the tracking setup, not the review.
Can angel investors get automatic updates from portfolio companies?
Yes — if the founder is sending updates through a structured tool rather than ad-hoc email or Slack. When that's the case, the update arrives in your dashboard already formatted and comparable across your whole portfolio, instead of landing in an inbox you have to manually file.
