Buying USD Stocks with CAD cash - PS AI Coach sanity check

Scrappy

I'm asking in this category as I want to see if the PS AI Coach gave me the correct answer and I can't find a similar question in the forum.

I have a bunch of money shown in * Cash in CAD. I have purchased a number of shares in a USD stock. According to the PS AI Coach I should show this as 3 transactions:

a. Sell * Cash at the CAD equivalent;
b. Buy * Cash at the USD rate, and show the ExchRate; and
c. Buy Stock with Price showing the USD value.



Secondly, even though my * Cash is setup in CAD, when my US stock provides Dividends (e.g. DivTA) , I should be entering the Price value in USD.

According to the PS AI Coach this allows PS to internally track USD and CAD values. Is this the right way to do this?

VidasMatelis

No, this is not correct.
Any price or fee you enter in Transactions table is in the currency of the transactions Account!
So critical information you should consider - what is the account for this transaction and what is the currency for that account.
Lets say you have account with currency CAD.
To buy USD stock in that account would require just one transactions
TransType: Buy
SymbolName:HD
Qty:2

Now there price here should be specified in the accounts currency (CAD) or you can specify in USD and the use ExchRate to convert to Account currrency.

If HD cost 380USD, you would specify:
Price: 380.13 AND ExchRate: 1.3658

If HD cost 380CAD, you would specify:
Price: 380.13

Scrappy

Thanks Vidas, I very much appreciate the effort you put in here.