Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

USD and CAD in Same Account

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?


Sign In or Register to comment.