Books with Canadian stocks are not working correctly

I have just started to use books; they have some neat features, but there is an issue.

All numbers are treated as if they are in U.S. Dollars. Therefore, the target allocations are off and performance figures are affected.

Details
I made this public book to illustrate this issue.

In this book, each Canadian stock is targeted to be 10% weight. The total portfolio value is $100,000 (USD). That means that each position should be $10,000 (in USD). But the book is not doing it correctly. Each Canadian stock in this book is calculated as if it trades in USD.

For example, one holding in this book in MX:CN. It’s last close was 77.33 CAD.

It should target 160 shares. [size=1](Because 160 shares * 77.33 CAD = 12,373 $CAD. That’s $9,984 USD, which is close to 10% of $100,000 USD)[/size]. Instead, this book targeted 129 shares [size=1](because 129 * 77.33 = 9.976)[/size].

A heads up
I realize that treating currency conversions properly is a big project and the ROI is limited because few people use CN stocks in books. But there should be asterisk on the portfolio rebalance page and/or the book current holdings page noting this limitation. Instead, I wasted hours figuring this out on my own.

A simple workaround
A simple workaround would be to add a ‘currency’ column to the ‘current holdings’ and the ‘get recommendations’ pages.

For most users this would probably be good enough. We would be able to adjust our target share allocations on our end using the USD/CAD exchange rate.

(BTW, not all Canadian stocks trade in Canadian dollars, so we can’t just assume that the currency is CAD for CN stocks.)

Thank you!

I just made some live trades in a dual currency book and noticed that the Canadian portion is underweighted because of this issue.

We don’t support different currencies on Portfolio123. We are considering adding it at some point in the future, but for the moment we would recommend not combining U.S. and Canadian portfolios in a single book.

I’ll make a note of this for the project when it happens, though. Thanks for letting us know.