[GNC] Advanced portfolio

[Fred Tydeman]

I am running Gnucash 5.9 on Fedora Linux 40
My home currency is USD
My Fidelity brokerage account has one stock on a Canada stock exchange.
I have run Reports: Assets&Liabilities: Advanced Portfolio.
In the options, I changed the date to yesterday (Oct 19).
The line in the report for that Canada stock was very wrong.
I left clicked on the blue highlighted Price.
The popup shows a date of last January.
I opened Tools: Price Database
There is a price for last January (but in USD, not CAD like the rest of the
prices).
There is a CAD price for Oct 18, yet it is not being used in the report.

I have removed the USD price entry from the Price Database and the report
is OK (after Reload).
Seems wrong to use a price from 9 months ago when there is a current price.

Also, not sure how USD prices are mixed in with CAD prices for a CAD stock.