Finance & Investing ยท Deep Dive
Aidan Aniciete The Tracker.
Opened a Roth IRA at 19 with $500. Now managing $42k+ across a Roth IRA, 401(k), and HSA at 23. Every position tracked in a custom multi-tab Excel model โ cost basis, sector allocation, factor investing, and net worth trajectory.
Approach
Investment Philosophy
Growth
Net Worth Trajectory
Accounts
The Triple Stack
Opened Dec 2022 at age 19 with $500
Contributions: post-tax ยท grows tax-free forever
Started: July 2024
Strategy: target-date auto-rebalancing
Triple tax-advantaged: pre-tax in, tax-free growth, tax-free out
Strategy: invest HSA, pay medical costs out-of-pocket
Roth IRA
All Holdings
| Ticker | Company | Thesis | Overall Return |
|---|
| Ticker | Fund | Strategy | Overall Return |
|---|
Roth IRA
Sector Allocation
The Model
Inside the Spreadsheet
Built in Excel with live formula linking across all tabs โ change a value in Holdings and it cascades to Dashboard, Allocation, and Net Worth instantly. Every position has a documented investment thesis. Every account is tracked with cost basis and unrealized gain/loss. The goal: one source of truth for my entire financial picture.
Data Flow
cost basis + value
=SUM(Holdings)
auto-recalc
+ savings โ debt
Every value in the model is formula-driven โ no manual entry after the initial setup. Update a position in Holdings and the Dashboard total, sector allocation percentage, and net worth snapshot all recalculate instantly. This mirrors the single-source-of-truth principle used in relational database design.
// RRI returns annualized growth rate as a decimal // 3.5 = years ยท D4 = lifetime deposits ยท B4 = current net worth =RRI(3.5, D4, B4) โ 0.167 // Fetched live via Sheets API ยท rendered directly on this page const cagrRaw = await fetch("Dashboard!H4"); display(cagrRaw * 100 + "%"); โ "16.7%"