Hi YVR, JBOG already provided the reason why your calculated return is too high. Your spreadsheet mixes Canadian dollars with U.S. dollars. To be consistent, all amounts need to be in U.S. dollars. After conversion, I actually have you at number 11 with a 24.30% YTD gain.
Here are the numbers I used for your Canadian stocks:
(Remember, for conversion to US$, I’m using the 1/3/20 & 2/21/20 rates.)
AGN.CN: US$5,000 got you 100,043.02 shares at US$.049979 per share. At 2/21/20 close, AGN.CN price was US$.071840 for a total value of US$7,187.
LXG.V: US$15,000 got you 25,335.57 shares at US$.592053 per share. At 2/21/20 close, LXG.V price was US$.710840 for a total value of US$18,010.
MDNA.TO: US$15,000 got you 6,134.71 shares at US$2.445102 per share. At 2/21/20 close, MDNA.TO price was US$3.092908 for a total value of US$18,974.
Peace & good health,
Bulba |
