smol compute
Premium Templates for Apple Numbers smolcompute.xyz
  • User Guides
  • ㅤ
    • Portfolio Tracker Pro
      • Quick Start
      • Accounts
      • The Dashboard
      • ROI Charts
      • Watchlists
      • Changing the Primary Currency
      • Optional Secondary Currency
      • Troubleshooting
      • Changelog
    • Portfolio Tracker Lite
      • Quick Start
      • Dashboard
      • Trade Log
      • Holdings
      • Changing the Primary Currency
      • Optional Secondary Currency
      • Troubleshooting
    • Formatter
      • Quick Start
      • Video Guides
      • Troubleshooting
    • General Guides
      • Tips and Tricks
      • Fixing an Erroneous Asset Match
      • Stocks Listed on Non-US Exchanges
      • Data Migration
      • Adding Accounts
      • Getting Updates
      • What devices can I use smol compute on?
      • Turning on End-to-End Encryption
      • Modifying your smol Tools
      • Sharing & Collaboration
      • Supported Non-US Stock Exchanges
      • Scripts
      • Brand Assets
  • ㅤ
    • smolcompute.xyz
    • X (Twitter)
    • Threads
    • YouTube
Powered by GitBook
  1. ㅤ
  2. Portfolio Tracker Pro

Quick Start

Last updated 28 days ago

Was this helpful?

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).

2. Set your base currency

3. Enter your first trade

4. Take your first snapshot

The Dashboard

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.

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

Learn More:

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

Scroll down to the 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.

The 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.

Finally, in the 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 on your account's sheet as well as those on the and the .

Speaking of the of the go to that sheet. You will see 3 distinct accounts listed in the 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.

Optional: If you’re using USD as your primary currency but would like your P&L to be tracked in a (in addition to the USD), you can do so.select a currency in the pop-up menu in D1 at the very top of your Dashboard (The cell marked "Alt Currency Picker"). Once selected, you will see additional stats show up across your Portfolio Tracker.

change the primary currency
secondary currency
Tips and Tricks
How to change the primary currency.
How to set a secondary currency.
Learn more about the Accounts.
Learn more about the Dashboard.
Learn more about the ROI Charts.
Learn how to create Watchlists.
Lean how to make a Special Assignation.
Sync using end-to-end encryption.
Where can I use smol compute?
Dashboard Tab
ROI Tab
Dashboard,
Portfolio Breakdown
Trade Log
Holdings
Snapshots
Account's ROI chart
Portfolio Tracker – Premium Templates for Apple Numbers.
Portfolio Tracker – Premium Templates for Apple Numbers.
Portfolio Tracker – Premium Templates for Apple Numbers.
Portfolio Tracker – Premium Templates for Apple Numbers.
Portfolio Tracker – Premium Templates for Apple Numbers.