Changing the Primary Currency
Last updated
Was this helpful?
Last updated
Was this helpful?
The Portfolio Tracker’s default currency is set to USD, but you can change the primary currency if you’re using a different base currency. For example, if you’re in Canada and trading in Canadian dollars, you can change the primary currency to CAD. Here’s how:
Open a new instance of the Tracker, go to any of the Account tabs and click in cell C2 in the Top Line Stats.
In the menu, go to View > Inspector > Format to reveal the Sidebar.
At the top of the sidebar, click on the Cell tab. The Data Format, should be set to "Smol Currency". Click on "Edit Custom Format"
In the modal that opens up, you'll see a number of rules, each starting with a $ sign. Click on that sign and select the currency you want to use instead.
Do this for each rule, then click OK.
You'll notice that the currency of the Tracker has now been changed to display CA$ everywhere.
if you change the primary currency you'll want to enter trades for assets denominated in your newly chosen primary currency.
For example, if I want to enter trades for Bitcoin denominated in CAD, I'll specify in the Special Assignations table that the ticker "BTC" refers to the asset code "BTC-CAD". Doing so will ensure that the current price of Bitcoin is quoted in CAD. If I don't do this, the current value of my holdings will be denominated in USD, while your cost basis will be in CAD, which will produce an erroneous P&L.
Similarly, if you are trading stocks of the Onex Corporation listed on a Canadian stock market, you'll want to enter its asset code next to the ticker you wish to use for it (in this case, ONEX). The Tracker will then remember that the ticker ONEX refers to stocks of the Onex Corporation denominated in Canadian dollars.
We recommend makingfor each non-usd-denominated asset you trade.
