New user here, past couple months. Loving this tool so far, but struggling to properly account for currency.
I am able to hold both USD and CAD (cash & equities) in my brokerage account. I can only set the account currency in PS to one or the other. I set it to CAD. If I understand correctly, I then need to add USD equity Buys with the price per share converted to CAD in the Transactions section.
When I do this, the following results in Holdings:
Original = Cost Basis shows as CAD, but Market Value shows as USD throwing the returns off.
CAD = Shows correct Cost Basis and Market Value, but seems to show a huge Exchange Rate impact
USD = Seems to show somewhat correctly, but then changes all the holdings in the account to USD
Further complicating this is having done Norbert's Gambit previously on a large sum at a certain FX rate. So the exchange rate on the date I bought won't match the actual exchange rate from when I exchanged the funds.
Someone simplify this for a dummy?