Canadian prices and FX rates?

Report a problem or error
1

Current prices for Canadian holdings are in USD, but cost is in CAD (in holdings of a live book).

Attached should be screenshot.

So, for example, ATZ:CAN is showing a cost price of 38.96 a current price of 29.17 and a return of -25%. In reality, the cost price was 38.96 CAD, while the current price is 37.30 CAD for a unrealized loss of -4%.

Something needs to be fixed here. My strong preference is to have all prices in native currency but NAV in USD.

Thanks!

Annotation 2022-05-30 124004.png
Annotation 2022-05-30 124004.png1213×661 40.8 KB

2

When manually entering or importing transactions in Research, the price used needs to be in the same currency as the strategy. Given the large number of transactions, I assume you imported them. Would it resolve your issue if the import page had a currency column added?

3

That would work, thanks Dan!

P.S. You made a good deduction :slight_smile: