Build a Portfolio Company Holdings Table
Answering “What do we own?” often requires piecing together data from spreadsheets, fund administrators, and company records. With the Standard Metrics MCP, firms can generate a detailed holdings table showing each investment and its underlying activity, including cost basis, shares, ownership, proceeds, and gains or losses. Teams get a clear view of their positions for faster portfolio reviews, analysis, and reporting.
The above video uses synthetic data for illustrative purposes*
How to set this up
Tools
- Claude
- Standard Metrics MCP. See here for set up details.
- Excel
Prompt used in the video:
Using Standard Metrics, create an Excel report for [portfolio company] with three separate tables and no nested rows:
- Financings: round name, date, amount raised, post-money valuation, FDSO, and liquidation preferences.
- Investments: fund, security type, investment date, original investment, current cost, shares purchased, net shares, proceeds and proceeds date, ownership at investment, and current ownership.
- Fair value: current fair value by fund.
Tips:
- Customize your report with additional fields such as investment status, round stage, change in cost, net cost basis, realized shares, original and realized price per share, and realized or unrealized gain/loss.
