Introduction
Welcome to the final lesson of your course on investing in the Sri Lankan stock market! This is a significant milestone. In our last session, you learned how to construct a model portfolio by combining your risk profile, asset allocation strategy, and individual stock analyses. You now have a blueprint for what to buy.
Today, we complete the picture by focusing on what happens after you buy. Successful investing is a long-term discipline, not a one-time event. This final lesson will equip you with the tools and mindset to manage your portfolio effectively over time.
Our learning outcome is to develop a personal plan for monitoring your holdings and create pre-defined rules for selling an investment. We will cover two critical aspects of disciplined investing:
- Monitoring: How to systematically track your investments to stay informed and in control.
- Selling: Establishing a rational, pre-planned framework for when to sell a stock, removing emotion from the decision.
By the end of this lesson, you will have a complete, end-to-end process for building and managing your investment portfolio.
1. Monitoring Your Holdings: The Investor's Dashboard
Once you've invested, you need a system to keep track of your portfolio's performance and health. This isn't about nervously watching daily price flickers; it's about periodic, structured reviews to ensure your investments remain aligned with your goals and your original investment theses hold true.
The Official Record: Broker and CDS Documents
For any Sri Lankan investor, the primary source of truth for your transactions and holdings comes from official documents provided by your stockbroker and the Central Depository System (CDS).
CSE - Basic Guide in Investing in Shares
The 'Basic Guide in Investing in Shares' from the Colombo Stock Exchange clearly explains the key documents you will receive. Understanding these is fundamental to tracking your activity.
Please read the following three short sections in the guide: 'What are Bought Notes and Sold Notes?': These are your official receipts for every trade. 'About the CDS statement': This is like your bank statement for stocks, showing all your holdings. 'Important' (the section immediately following the CDS statement description): This section gives crucial advice on what to do with these documents, such as cross-checking them for accuracy and reporting any discrepancies. \nThis is your primary audit trail. Always review these documents carefully.
Building Your Personal Dashboard
While official statements are essential for verification, a personal portfolio tracker gives you the power to analyze your investments in real time. Given your background in IT and data analysis, creating a dynamic tracker in Google Sheets will be a natural and powerful extension of your skills. It will serve as your central dashboard for monitoring.
The following tutorial will walk you through building a comprehensive stock tracker from scratch.
Create Your Own Stock Tracker: Beginner Google Sheets Tutorial
This video by Michael Jay provides a clear, step-by-step guide to creating a portfolio tracker in Google Sheets. We will use it to build a tool tailored for your CSE investments.
Follow the video to build your tracker. The concepts are universal, but you'll need one small adjustment for the CSE. Watch 01:24 - 03:33 (Setup): Start by setting up your input columns: Ticker, Shares, and Average Cost. Watch 03:33 - 06:45 (Live Prices): This is the key step. The video uses the GOOGLEFINANCE function. For CSE stocks, you must prefix the ticker with CSE:. For example, to get the price for John Keells Holdings, you would use the formula =GOOGLEFINANCE("CSE:JKH"). Watch 06:45 - 13:11 (Metrics & Allocation): Follow the guide to calculate essential metrics like Total Gain/Loss, Percentage Gain, Total Equity, and Portfolio Percentage. These calculations allow you to see not just how one stock is doing, but how it fits into your overall portfolio. Watch 19:34 - 25:23 (Visualization): As someone familiar with Tableau and Power BI, you'll find this section on creating pie and bar charts intuitive. Visualizing your portfolio allocation and performance can provide instant insights.
Pro Tip: Once you've set up your tracker, you can easily add new positions by inserting a row and copying the formulas down, as shown in the video from 18:15 - 19:34. The entire sheet will update automatically.
The Periodic Review Checklist
Your tracker gives you the data. A periodic review process gives you the structure to act on that data. Aim to conduct a formal review of your portfolio once every quarter or six months.
During your review, you should ask:
- Is my asset allocation still in line with my targets (e.g., 80% stocks, 20% bonds)?
- Has any single stock grown to become too large a part of my portfolio?
- Is the original investment thesis for each company still valid?
- How is my portfolio performing against its benchmark (e.g., the ASPI)?
2. Developing Your Selling Plan: When to Let Go
Deciding when to sell is often harder and more emotional than deciding when to buy. Greed might tempt you to hold a winner for too long, while fear might cause you to panic-sell during a downturn. A pre-defined selling plan is your defense against these destructive emotions.
As Warren Buffett says, "the stock does not know that you own it." Your emotional attachment is irrelevant to its value. Let's establish a rational framework for selling.
Framework 1: Fundamental Reasons to Sell
This framework, inspired by value investing principles, focuses on the underlying business. The decision to sell is tied directly to your original reason for buying.
Warren Buffett: The 3 Times When You Should Sell a Stock
The Swedish Investor channel provides an excellent summary of Warren Buffett's three main reasons for selling a stock. These are fundamental, business-focused reasons that form the strategic basis of a selling decision.
Watch from 02:02 to 08:59. Pay close attention to the three core scenarios for selling: When something better shows up (Opportunity Cost): Your capital could be generating a better return elsewhere. When the business fundamentals change for the worse: Your original investment thesis is now broken. The company is no longer the great business you thought you bought. When a single holding gets too big (Rebalancing): The position has grown so large that it exposes your portfolio to excessive concentration risk.
To put this into practice, for every stock you own, you should be able to answer the question posed in the video: "If I didn't already own this stock, would I buy it today at its current price?" If the answer is a clear "no," it is a strong candidate for selling.
Framework 2: Rule-Based Selling
This framework provides specific, pre-determined triggers for selling. These rules are not based on fundamentals but on price action and portfolio management principles. They are designed to enforce discipline.
When To Sell Stocks To Take Profits And Avoid Big Losses
This article from Investor's Business Daily outlines some of the most time-tested selling rules in investing. They are designed to protect your capital and lock in profits systematically.
Read the following three sections to understand the core rules: 'The No. 1 Rule For When To Sell Stocks': This covers the cardinal rule of cutting losses: selling a stock if it falls 7%-8% below your purchase price. This is your primary risk management tool. 'When To Sell Stocks To Take Profits': This explains the strategy of taking profits after a stock has gained 20%-25%. This helps you systematically lock in gains. 'When Not To Sell Stocks: 8-Week Hold Rule': This provides a crucial exception to the profit-taking rule for exceptionally strong stocks, helping you ride a big winner. \nThink of these as algorithms for your selling decisions, designed to execute automatically when a condition is met.
The CSE's guide reinforces many of these same points, including rebalancing, reinvestment opportunities, and selling when a stock becomes overvalued, confirming the universality of these principles.
Your Personal Plan
You now have the building blocks for your personal plan. It should combine both monitoring and selling rules.
-
Monitoring Plan:
- Daily/Weekly: Glance at your Google Sheets tracker to stay aware of overall portfolio value and major movements. (5 minutes)
- Monthly: Review your official CDS statement against your broker's notes and your tracker to ensure accuracy. (15 minutes)
- Quarterly/Semi-Annually: Conduct a full portfolio review using your checklist. Re-evaluate your investment theses and check your asset allocation. (1-2 hours)
-
Selling Plan (Your "Sell-Sheet"):
For each stock you buy, write down your sell conditions in advance. Your sheet for one stock might look like this:- Stock: JKH.N0000
- Investment Thesis: "A stable, diversified conglomerate that acts as a proxy for the Sri Lankan economy's growth."
- Fundamental Sell Condition: Sell if the company announces a major strategic shift away from its core, profitable businesses, or if management's integrity comes into question.
- Rule-Based Sell Conditions:
- Stop-Loss: Sell if the price drops 8% below my purchase price of X LKR.
- Profit-Taking: Sell a portion of the holding if the price rises 25% from my purchase price.
- Rebalancing: Trim the position if it grows to exceed 40% of my total stock portfolio.
Conclusion and Course Wrap-Up
Congratulations! You have reached the end of the course and have successfully developed a comprehensive framework for investing on the Colombo Stock Exchange. From understanding macroeconomics to analyzing financial statements, valuing companies, building a portfolio, and now, managing it with discipline—you have the complete toolkit.
Key Takeaways from Today's Lesson:
- Effective portfolio management requires continuous, structured monitoring, using both official documents and a personal tracker.
- A pre-defined selling plan is your greatest defense against emotional investing decisions like greed and fear.
- Your selling strategy should be a blend of fundamental reasons (when your thesis is broken) and hard rules (like stop-losses and profit-taking targets).
You began this journey with a goal to learn everything required to be an independent investor. You now possess that knowledge. The path forward is to apply it. Start small, stay disciplined, and never stop learning. Your journey as an investor has just begun. Well done, and best of luck.