Portfolio Tracker
What it does
The Portfolio Tracker lets you record every Kenya Treasury Bond you hold, and automatically calculates your current portfolio value, accrued interest, weighted average yield, and upcoming coupon income — updated to today's date on every page load.
Each holding stores the bond, the face value you own, the purchase price you paid, and the date you bought. From those inputs the tracker computes:
- Accrued interest earned but not yet paid
- Current market value (using latest NSE yield)
- Unrealised gain or loss versus your purchase price
- Your next coupon date and projected coupon amount
- Portfolio totals: total face value, total market value, portfolio yield
When to use it
- Monitoring the total value of your bond holdings across multiple bonds.
- Planning cash flow — seeing all upcoming coupon dates in one place.
- Checking unrealised P&L if you are considering selling a holding on the secondary market.
- Preparing for tax season — the tracker feeds into the Tax Report for WHT calculations.
Three-bond portfolio — tracking KES 3M across different maturities
You hold three bonds purchased at auction over the past two years. You want to see your total portfolio value, how much interest you have earned so far, and when your next coupon payments arrive.
Example output — holdings table
| Bond | Face Value | Purchase Price | Purchase Date | Accrued Interest | Market Value | Unrealised P&L | Next Coupon |
|---|---|---|---|---|---|---|---|
| FXD1/2026/2 | KES 1,000,000 | KES 100.45 | 20 Sep 2024 | KES 14,027 | KES 1,001,200 | +KES 750 | 19 Aug 2025 |
| FXD1/2028/5 | KES 1,500,000 | KES 99.10 | 17 Mar 2024 | KES 31,178 | KES 1,480,650 | +KES 14,100 | 17 Sep 2025 |
| IFB1/2031/12 | KES 500,000 | KES 97.20 | 15 Dec 2023 | KES 10,890 | KES 472,000 | -KES 14,000 | 15 Jun 2025 |
| Portfolio Total | KES 3,000,000 | — | — | KES 56,095 | KES 2,953,850 | +KES 850 | — |
The IFB shows an unrealised loss of KES 14,000 because yields have risen since purchase, pushing the market price below your cost. However, since you plan to hold to maturity, that loss is only on paper — you will receive the full face value of KES 500,000 at maturity.
Column reference
| Column | Description |
|---|---|
| Face Value | The nominal amount you own of this bond. |
| Purchase Price | The dirty price per KES 100 you paid at the time of purchase. |
| Purchase Date | The settlement date of your original purchase. |
| Accrued Interest | Interest earned from your purchase date to today that has not yet been paid as a coupon. |
| Market Value | Current value of the holding using the latest NSE yield. If no recent trade, uses the last available yield. |
| Unrealised P&L | Market value minus cost (purchase price × face value / 100). Positive = gain, negative = loss. |
| Next Coupon | The next scheduled coupon payment date. Coupon amount = coupon rate / 2 × face value. |
Limitations
- Market value uses NSE secondary market data, which may be stale for thinly traded bonds. For illiquid bonds the unrealised P&L may not reflect true exit value.
- The tracker does not connect to your CDS account — holdings must be entered manually.
- Partial sales are not modelled. If you sell part of a holding, you need to edit the face value manually.
- WHT deductions are not subtracted from accrued interest — the figure shown is gross. Use the Tax Report for net-of-tax income projections.
- Portfolio PDF export requires the Family plan.
Add holdings as soon as your CDS account is credited — the accrued interest calculation starts from your purchase date. Adding a bond weeks later means you undercount the interest earned during the gap.