Home Back
Verity Architecture — Book One

Financially Trapped: Engineering of Persistence

Excel Portfolio Tracker — Interactive Demo

See What Comes With the Architect’s Bundle

Every portfolio in the Verity system has its own pre-built Excel tracker. Four purpose-built sheets, zero setup required. Drop in your holdings and the formulas handle the rest — market value, unrealized gain, return %, and a running monthly chart.

4 Sheets Per File 10 Portfolio Trackers Auto-Calculating Formulas Built-In Monthly Chart Traffic-Light Purchase Guide CSV Import Sheet Works Offline
X FT_Starter_Portfolio.xlsx — Excel
Home Insert Page Layout Formulas Data View
Verity Architecture — Financially Trapped Starter Portfolio  •  TFSA  •  Wealthsimple  •  CAD  •  Reset May 14 2026
#TickerExchangeCompanyClassCCY QtyPriceMkt ValueBook Value UnrealizedReturn %Div/ShareFreq
1AMHETSXHarvest Amazon EHI ETFCA ETFCAD 0.2029$15.50 $3.14$3.00 +$0.14+4.7% $0.08Monthly
2APLETSXHarvest Apple EHI ETFCA ETFCAD 0.1677$17.20 $2.88$2.75 +$0.13+4.7% $0.08Monthly
3BANKTSXEvolve Cdn Banks & Lifecos ETFCA ETFCAD 0.2817$23.80 $6.70$6.50 +$0.20+3.1% $0.14Monthly
4BCEETSXHarvest BCE EHI ETFCA ETFCAD 0.2803$9.15 $2.56$2.45 +$0.11+4.5% $0.09Monthly
5BNTSXBrookfield Corp.CA StockCAD 0.0158$68.50 $1.08$0.95 +$0.13+13.7%
6CHP.UNTSXChoice Properties REITCA REITCAD 0.1950$14.20 $2.77$2.60 +$0.17+6.5% $0.07Monthly
7ENSTSXE Split Corp.CA SplitCAD 0.1589$8.45 $1.34$1.25 +$0.09+7.2% $0.10Monthly
8ETSXTSXEvolve S&P/TSX 60 Enhanced YieldCA ETFCAD 0.1232$18.90 $2.33$2.20 +$0.13+5.9% $0.12Monthly
9QMAXTSXHamilton Tech Yield Maximizer ETFCA ETFCAD 0.1196$7.85 $0.94$0.88 +$0.06+6.8% $0.15Monthly
10SGR.UNTSXSlate Grocery REITCA REITCAD 0.1867$8.90 $1.66$1.55 +$0.11+7.1% $0.10Monthly
11SRU.UNTSXSmartCentres REITCA REITCAD 0.1048$24.10 $2.53$2.40 +$0.13+5.4% $0.15Monthly
12VEETSXVanguard FTSE EM All Cap ETFCA ETFCAD 0.3736$39.50 $14.76$13.80 +$0.96+7.0%
PORTFOLIO TOTAL — 12 Positions $42.69 $39.83 +$2.86 +7.2%
Blue cells = formulas:   Mkt Value =G7*H7  •  Unrealized =J7-K7  •  Return % =L7/K7  •  Totals =SUM(J7:J36)
Update the Price column (col H) each month from your broker and all values recalculate instantly.
Monthly Tracker — Record a snapshot on the last day of each month. Chart updates automatically.
#MonthDatePortfolio Value (CAD)Book ValueUnrealizedReturn %
1May 20262026-05-31 $31.51$31.41 +$0.10+0.3%
2 ← Row 2 will auto-populate the chart when you add Jun 2026
3...
4...

Portfolio Value Over Time — Auto-updates as monthly snapshots are added

The line chart is embedded directly in the sheet — no plugins required. It grows with your data as each month is recorded.
Purchase Plan — Current weight vs. target allocation. Traffic-light status guides your next buy.
#TickerCompanyMkt ValueCurrent WtTarget WtDeltaStatus
1AMHEHarvest Amazon EHI ETF $3.147.4%8.3% -0.9%▲ Add
2APLEHarvest Apple EHI ETF $2.886.7%8.3% -1.6%▲ Add
3BANKEvolve Cdn Banks ETF $6.7015.7%8.3% +7.4%▼ Overweight
4BNBrookfield Corp. $1.082.5%8.3% -5.8%▲▲ Underweight
5CHP.UNChoice Properties REIT $2.776.5%8.3% -1.8%▲ Add
6ENSE Split Corp. $1.343.1%8.3% -5.2%▲▲ Underweight
7SGR.UNSlate Grocery REIT $1.663.9%8.3% -4.4%▲▲ Underweight
8VEEVanguard FTSE EM All Cap ETF $14.7634.6%8.3% +26.3%▼ Overweight
PORTFOLIO TOTAL $42.69 100% 100% Auto-calculated
Traffic-light logic:   Current Wt =J7/SUM($J$7:$J$36)  •  Delta =F7-E7  •  Status uses IF() with conditional formatting — Green / Amber / Red auto-applied
Green = within 1% of target. Amber = 1%–3% below target. Red = overweight or more than 3% underweight. Your $1/day buys focus red and amber positions first.
CSV Import — Paste your Wealthsimple activity export starting at row 10. Summary block auto-calculates from the pasted data.
ABC (Qty)D (Price)E (Amount)
Rows 1–9: Instructions & column headers — protected, do not edit

Paste Wealthsimple CSV export below — transactions auto-populate the summary:

Symbol,Description,Quantity,Price,Amount,Type,Date
VEE,"Buy 0.3736 shares of VEE",0.3736,39.50,-14.76,Buy,2026-05-14
BANK,"Buy 0.2817 shares of BANK",0.2817,23.80,-6.70,Buy,2026-05-16
AMHE,"Buy 0.2029 shares of AMHE",0.2029,15.50,-3.14,Buy,2026-05-15
BCEE,"Buy 0.2803 shares of BCEE",0.2803,9.15,-2.56,Buy,2026-05-17
← Continue pasting rows here (up to row 60)…
Auto-Summary Block (rows 63–68) — Do not edit
FieldFormula Result
Total Market Value$42.69
Total Book Value$39.83
Total Unrealized+$2.86
Position Count12
Snapshot Date2026-05-31
Export your activity from Wealthsimple → paste here → copy the summary block values into the Dashboard. No manual entry needed.
📈 Dashboard
📊 Monthly Tracker
☰ Purchase Plan
🗂 CSV Import

Get All 10 Portfolio Trackers

Every portfolio in the Verity Architecture system has its own pre-built tracker in exactly this format. Pre-populated with tickers, classes, dividend schedules, and historical data. Blank versions included so you can adapt them to your own holdings.

FT Starter Centurion — 100 Positions Fortress 200 USD Quiet Titan TFSA Rebate Portfolio Tactical Tax Free REITs Portfolio Developer Portfolio WhiteSwan 10 ETF RRSP
Architect’s Bundle — $29.99 CAD Back to Home