Course Module 103: Tracking Portfolio Performance
How to create spreadsheets to monitor investment performance
Summary
Subject matter: How to use a template to research common stocks for purchase consideration or monitor the performance of current portfolio holdings.
QVI Course Module 103 provides a common stock portfolio research template to copy and adapt to a portfolio or watchlist.
A basic understanding of Microsoft Excel or Google Sheets is necessary to master this module’s content.
The course includes key financial indicators and a user guide for template integration.
The module concludes with voluntary action items and suggested resources.
Please note that a basic understanding of Microsoft Excel or Google Sheets is necessary to master this course module’s content.
Quality Value Investing (QVI) Course Module 103 teaches users how to use a template to screen common stocks as part of their research for purchase consideration or monitor current portfolio holdings for longer-term ownership.
In other words, use a programmable template to check the quality and value of current common stock holdings or conduct due diligence on targeted companies and stocks already on—or to add to—a watchlist.
Premium subscribers are invited to copy the Microsoft Excel worksheet and use it to monitor their portfolios as the formulas are pre-programmed. In addition, premium subscribers can create a template with Module 103’s sample as a guide. However, it is recommended that users have a command of Excel or Google Sheets before making their template, as I cannot provide tutorials on spreadsheet creation.
Module 103 Syllabus
Subject matter objective: Discover how to create and use spreadsheets to monitor the performance of the key financial indicators of the stocks held in a self-managed portfolio or watchlist.
Although online brokerages and financial sites offer excellent portfolio-tracking software tools, they are often limited and biased in the key indicators provided. So instead, create a spreadsheet and take control of preferred metrics to determine quality plus value when stock picking or portfolio rebalancing.
Common Stock Portfolio Research Template
The research template’s main drivers are formulating a thesis or opinion by analyzing the publicly traded business and the underlying stock.
The QVI research modalities include the value proposition, shareholder yields, fundamentals, valuation, and downside risks.
The template concludes with weighted views on the company and the stock.
Suggested Performance Templates
Microsoft Excel and Google Sheets are standard end-user software tools for creating portfolio performance trackers.
This module uses Excel for the sample template along with Google Sheets for demonstrating the finished product.
Template User Guide
Key Financial Indicators
Manual Input for Excel
Formula Input for Excel
Company
Symbol
Summary
Shareholder Yields
Returns on Management
Valuation Multiples
Downside Risks
Portfolio Performance
Sentiment
Module 103 Action Items
Resources
Common Stock Portfolio Research Templates
Do-it-yourself or retail-level common stock investment research is best carried out within a model or outline driving a qualitative and quantitative unbiased conclusion of a bullish, neutral, or bearish call on the targeted company and the stock representing its ownership.
The research template’s main drivers are formulating a thesis or opinion by analyzing the publicly traded business and the underlying stock. The research modalities include:
The enterprise’s value proposition to its customers, including the products or services offered and the competitive landscape.
The average of the total shareholder yields measures how the stock compares to the prevailing 10-Year Treasury rate.
The fundamentals of the company, including the strength of senior management.
The valuation of the common shares or intrinsic value.
The downside risks of the company and the stock.
The template concludes with portfolio performance and independently weighted company and stock reviews or ratings.
Sample Performance Templates
Quality Value Investing uses Microsoft Excel to build portfolio tracking spreadsheets for inputting data along with Google Sheets to display the fixed result from the specified period.
Let’s dig further with direct links to the templates and step-by-step instructions after reading the necessary disclosures:
Disclosure: As of the date of this post, I/we had beneficial long positions in the shares of all the stocks represented in the QVI Concentrated Portfolio through direct stock ownership in our family portfolio. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it (other than from Substack paid subscriptions). I have no business relationship with any company whose stock is mentioned in this article.
Additional disclosure: Quality Value Investing by David J. Waldron’s course modules are for informational purposes only. The accuracy of the data cannot be guaranteed. Narrative and analytics are impersonal, i.e., not tailored to individual needs nor intended for portfolio construction beyond his family portfolio, which is presented solely for educational purposes. David is an individual investor and author, not an investment adviser. Readers should always engage in their own research or due diligence and consider (as appropriate) consulting a fee-only certified financial planner, licensed discount broker/dealer, flat fee registered investment adviser, certified public accountant, or specialized attorney before making any investment, income tax, or estate planning decisions.