Spreadsheet: 669165d1585234491-multiple-entries-in-a-cell-help-better-fomat-of-data
Sheet: MM

TD CAD M (1) |  |  | TD USD M (2) |  |  | TD CAD TFSA M (3) | TD TFSA MARC | TD TFSA MARC | TD CAD A (4) | TD CAD Ania |  | TD CAD Ania | TD USD A (5) |  |  | TD CAD TFSA A (6) |  |  | TD USD TFSA A (7) | TD USD Ania | TD USD Ania | RBC CAD/USD (8) | TD TFSA Ania | RBC CAD | RBC TFSA CAD/USD (9) |  |  | RBC RRSP CAD/USD (10) |  |  | RBC RESP (11)
Total invested |  | 0 | Total invested |  | 0 | Total invested |  | 0 | Total invested |  |  | 0 | Total invested |  | 0 | Total invested |  | 0 | Total invested |  | 0 | Total invested |  | 0 | Total invested |  | 0 | Total invested |  | 2354 | Total invested |  | 2348
Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0 | Total proceeds |  | 0
Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  |  | 0 | Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  | 0 | Shares bought |  | 100 | Shares bought |  | 100
Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | #N/A | Average SP bought |  | 23.54 | Average SP bought |  | 23.48
Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0 | Shares sold |  | 0
Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A | Average SP sold |  | #N/A
Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0 | Total dividends |  | 0
Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A | Average ROI exc. [NAME] |  | #N/A
Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A | Average ROI incl. Divs |  | #N/A
Date | Transaction | Amount | Shares | Amount/Share | Fees | Capital gain (loss) | Share Balance | Change in ACB | New ACB | New ACB/shares | Date | ROI Per transaction | Account
2016-12-21 00:00:00 | buy | 2354 | 100 | 23.54 | 9.99 | 0 | 100 | 2354 | 2354 | 23.54 |  |  | 10
2016-12-21 00:00:00 | buy | 2348 | 100 | 23.48 | 9.99 | 0 | 200 | 2348 | 4702 | 23.51 |  | 0 | 11
2017-09-17 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2017-12-29 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2018-03-29 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2018-06-29 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2018-09-28 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2018-12-31 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2019-03-29 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2019-06-28 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2019-09-30 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2019-12-31 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 10
2017-09-17 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2017-12-29 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2018-03-29 00:00:00 | dividend | 22 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2018-06-29 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2018-09-28 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2018-12-31 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2019-03-29 00:00:00 | dividend | 23 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2019-06-28 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2019-09-30 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
2019-12-31 00:00:00 | dividend | 24.15 |  |  | 9.99 | 0 | 0 | 0 | 0 |  |  | 0 | 11
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0