Quick Start

Your download includes 4 files:

  • A fresh copy of the template in light theme

  • A fresh copy of the template in dark theme

  • A demo copy already populated with data

  • A setup guide

Let's get going!

Pick a colour theme and open a fresh copy in Numbers..

1. Set the account type.

Go to the sheet named "ACCOUNT 1" and set the Account Type in B1 using the pop-up menu (Crypto or Stocks).

Portfolio Tracker – Premium Templates for Apple Numbers.

2. Set your base currency

If you won't be using the US dollar as your primary currency, you can change the primary currency now, or you can change it later.

Portfolio Tracker – Premium Templates for Apple Numbers.

3. Enter your first trade

Scroll down to the Trade Log and enter your first trade! The first 7 columns (the lighter ones) are where you input your trade details. The "Account" and "Fees" columns are optional. The columns titled "Realized P&L" only display values when you sell an asset, so you won't see anything here just yet.

Portfolio Tracker – Premium Templates for Apple Numbers.

The Holdings table has now been automatically updated with live stats for your new asset. This table will automatically update each time you add a trade in your Trade Log.

4. Take your first snapshot

Finally, in the Snapshots table (right sidebar), copy the values displayed in blue under "Current Values" and paste them in row 5 (first row with the lighter cells) using ⇧ + ⌘ + V (Edit > Paste Formula Results). This sets the initial values of your portfolio and any further snapshots you make will add a new temporal data point in your account's history. These events will populate the Account's ROI chart on your account's sheet as well as those on the Dashboard Tab and the ROI Tab.

Portfolio Tracker – Premium Templates for Apple Numbers.

The Dashboard

Speaking of the of the Dashboard, go to that sheet. You will see 3 distinct accounts listed in the Portfolio Breakdown table. These correspond to the 3 accounts sheets. Your first holding (the asset you just bought on your first trade) should now be listed under ACCOUNT 1.

Like the Holdings Table, the Dashboard will automatically fill up with live stats and visualizations as you add more trades to your Trade Log.

Some of these charts may appear empty at first—they need more data to populate. But here’s an example of what you’ll see soon enough.

Portfolio Tracker – Premium Templates for Apple Numbers.

That's it! You're Portfolio Tracker is now set-up and ready to go!

Learn More:

Last updated

Was this helpful?