Spreadsheet: 852789d1702737783-calculating-portfolio-returns-given-changes-to-holdings-portfolio-value
Sheet: Holdings

Date | Ticker | Account | Qty
2022-01-31 00:00:00 | AMD | US TFSA | 565
2022-01-31 00:00:00 | WKHS | US TSFA | 1880
2022-01-31 00:00:00 | QCOM | US TFSA | 55
2022-01-31 00:00:00 | AMD | US Cash | 62
2022-01-31 00:00:00 | UMC | US RSP | 20
2022-02-01 00:00:00 | AMD | US TFSA | 565
2022-02-01 00:00:00 | WKHS | US TSFA | 1880
2022-02-01 00:00:00 | QCOM | US TFSA | 55
2022-02-01 00:00:00 | AMD | US Cash | 62
2022-02-01 00:00:00 | UMC | US RSP | 20
2022-02-28 00:00:00 | AMD | US TFSA | 565
2022-02-28 00:00:00 | WKHS | US TSFA | 1880
2022-02-28 00:00:00 | QCOM | US TFSA | 55
2022-02-28 00:00:00 | AMD | US Cash | 62
2022-02-28 00:00:00 | UMC | US RSP | 20
2022-03-01 00:00:00 | AMD | US TFSA | 565
2022-03-01 00:00:00 | WKHS | US TSFA | 1880
2022-03-01 00:00:00 | QCOM | US TFSA | 55
2022-03-01 00:00:00 | AMD | US Cash | 62
2022-03-01 00:00:00 | UMC | US RSP | 20
2022-03-31 00:00:00 | AMD | US TFSA | 565
2022-03-31 00:00:00 | WKHS | US TSFA | 1880
2022-03-31 00:00:00 | QCOM | US TFSA | 55
2022-03-31 00:00:00 | AMD | US Cash | 62
2022-03-31 00:00:00 | UMC | US RSP | 20
2022-04-01 00:00:00 | AMD | US TFSA | 565
2022-04-01 00:00:00 | WKHS | US TSFA | 1880
2022-04-01 00:00:00 | QCOM | US TFSA | 55
2022-04-01 00:00:00 | AMD | US Cash | 62
2022-04-01 00:00:00 | UMC | US RSP | 20
2022-04-29 00:00:00 | AMD | US TFSA | 565
2022-04-29 00:00:00 | WKHS | US TSFA | 1880
2022-04-29 00:00:00 | QCOM | US TFSA | 55
2022-04-29 00:00:00 | AMD | US Cash | 62
2022-04-29 00:00:00 | UMC | US RSP | 20
2022-05-02 00:00:00 | AMD | US TFSA | 565
2022-05-02 00:00:00 | WKHS | US TSFA | 1880
2022-05-02 00:00:00 | QCOM | US TFSA | 55
2022-05-02 00:00:00 | AMD | US Cash | 62
2022-05-02 00:00:00 | UMC | US RSP | 20
2022-05-31 00:00:00 | AMD | US TFSA | 565
2022-05-31 00:00:00 | WKHS | US TSFA | 1880
2022-05-31 00:00:00 | QCOM | US TFSA | 55
2022-05-31 00:00:00 | AMD | US Cash | 62
2022-05-31 00:00:00 | UMC | US RSP | 20
2022-06-01 00:00:00 | AMD | US TFSA | 565
2022-06-01 00:00:00 | WKHS | US TSFA | 1880
2022-06-01 00:00:00 | QCOM | US TFSA | 55
2022-06-01 00:00:00 | AMD | US Cash | 62
2022-06-01 00:00:00 | UMC | US RSP | 20
2022-06-30 00:00:00 | AMD | US TFSA | 565
2022-06-30 00:00:00 | WKHS | US TSFA | 1880
2022-06-30 00:00:00 | QCOM | US TFSA | 55
2022-06-30 00:00:00 | AMD | US Cash | 62
2022-06-30 00:00:00 | UMC | US RSP | 20
2022-07-01 00:00:00 | AMD | US TFSA | 565
2022-07-01 00:00:00 | WKHS | US TSFA | 1880
2022-07-01 00:00:00 | QCOM | US TFSA | 55
2022-07-01 00:00:00 | AMD | US Cash | 62
2022-07-01 00:00:00 | UMC | US RSP | 20
2022-07-29 00:00:00 | AMD | US TFSA | 565
2022-07-29 00:00:00 | WKHS | US TSFA | 1880
2022-07-29 00:00:00 | QCOM | US TFSA | 55
2022-07-29 00:00:00 | AMD | US Cash | 62
2022-07-29 00:00:00 | UMC | US RSP | 20
2022-08-01 00:00:00 | AMD | US TFSA | 565
2022-08-01 00:00:00 | WKHS | US TSFA | 1880
2022-08-01 00:00:00 | QCOM | US TFSA | 55
2022-08-01 00:00:00 | AMD | US Cash | 62
2022-08-01 00:00:00 | UMC | US RSP | 20
2022-08-31 00:00:00 | AMD | US TFSA | 565
2022-08-31 00:00:00 | WKHS | US TSFA | 1880
2022-08-31 00:00:00 | QCOM | US TFSA | 55
2022-08-31 00:00:00 | AMD | US Cash | 62
2022-08-31 00:00:00 | UMC | US RSP | 20
2022-09-01 00:00:00 | AMD | US TFSA | 565
2022-09-01 00:00:00 | WKHS | US TSFA | 1880
2022-09-01 00:00:00 | QCOM | US TFSA | 55
2022-09-01 00:00:00 | AMD | US Cash | 62
2022-09-01 00:00:00 | UMC | US RSP | 20
2022-09-30 00:00:00 | AMD | US TFSA | 565
2022-09-30 00:00:00 | WKHS | US TSFA | 1880
2022-09-30 00:00:00 | QCOM | US TFSA | 55
2022-09-30 00:00:00 | AMD | US Cash | 62
2022-09-30 00:00:00 | UMC | US RSP | 20
2022-10-03 00:00:00 | AMD | US TFSA | 565
2022-10-03 00:00:00 | WKHS | US TSFA | 1880
2022-10-03 00:00:00 | QCOM | US TFSA | 55
2022-10-03 00:00:00 | AMD | US Cash | 62
2022-10-03 00:00:00 | UMC | US RSP | 20
2022-10-31 00:00:00 | AMD | US TFSA | 565
2022-10-31 00:00:00 | WKHS | US TSFA | 1880
2022-10-31 00:00:00 | QCOM | US TFSA | 55
2022-10-31 00:00:00 | AMD | US Cash | 62
2022-10-31 00:00:00 | UMC | US RSP | 20
2022-11-01 00:00:00 | AMD | US TFSA | 565
2022-11-01 00:00:00 | WKHS | US TSFA | 1880
2022-11-01 00:00:00 | QCOM | US TFSA | 55
2022-11-01 00:00:00 | AMD | US Cash | 62
2022-11-01 00:00:00 | UMC | US RSP | 20
2022-11-30 00:00:00 | AMD | US TFSA | 565
2022-11-30 00:00:00 | WKHS | US TSFA | 1880
2022-11-30 00:00:00 | QCOM | US TFSA | 55
2022-11-30 00:00:00 | AMD | US Cash | 62
2022-11-30 00:00:00 | UMC | US RSP | 20
2022-12-01 00:00:00 | AMD | US TFSA | 565
2022-12-01 00:00:00 | WKHS | US TSFA | 1880
2022-12-01 00:00:00 | QCOM | US TFSA | 55
2022-12-01 00:00:00 | AMD | US Cash | 62
2022-12-01 00:00:00 | UMC | US RSP | 20
2022-12-30 00:00:00 | AMD | US TFSA | 565
2022-12-30 00:00:00 | WKHS | US TSFA | 1880
2022-12-30 00:00:00 | QCOM | US TFSA | 55
2022-12-30 00:00:00 | AMD | US Cash | 62
2022-12-30 00:00:00 | UMC | US RSP | 20
2023-01-03 00:00:00 | AMD | US TFSA | 565
2023-01-03 00:00:00 | WKHS | US TSFA | 1880
2023-01-03 00:00:00 | QCOM | US TFSA | 55
2023-01-03 00:00:00 | AMD | US Cash | 62
2023-01-03 00:00:00 | UMC | US RSP | 20
2023-01-31 00:00:00 | AMD | US TFSA | 565
2023-01-31 00:00:00 | WKHS | US TSFA | 1880
2023-01-31 00:00:00 | QCOM | US TFSA | 55
2023-01-31 00:00:00 | AMD | US Cash | 62
2023-01-31 00:00:00 | UMC | US RSP | 20
2023-02-01 00:00:00 | AMD | US TFSA | 565
2023-02-01 00:00:00 | WKHS | US TSFA | 1880
2023-02-01 00:00:00 | QCOM | US TFSA | 55
2023-02-01 00:00:00 | AMD | US Cash | 62
2023-02-01 00:00:00 | UMC | US RSP | 20
2023-02-28 00:00:00 | AMD | US TFSA | 565
2023-02-28 00:00:00 | WKHS | US TSFA | 1880
2023-02-28 00:00:00 | QCOM | US TFSA | 55
2023-02-28 00:00:00 | AMD | US Cash | 62
2023-02-28 00:00:00 | UMC | US RSP | 20
2023-03-01 00:00:00 | AMD | US TFSA | 565
2023-03-01 00:00:00 | WKHS | US TSFA | 1880
2023-03-01 00:00:00 | QCOM | US TFSA | 55
2023-03-01 00:00:00 | AMD | US Cash | 62
2023-03-01 00:00:00 | UMC | US RSP | 20
2023-03-31 00:00:00 | AMD | US TFSA | 565
2023-03-31 00:00:00 | WKHS | US TSFA | 1880
2023-03-31 00:00:00 | QCOM | US TFSA | 55
2023-03-31 00:00:00 | AMD | US Cash | 62
2023-03-31 00:00:00 | UMC | US RSP | 20
2023-04-03 00:00:00 | AMD | US TFSA | 565
2023-04-03 00:00:00 | WKHS | US TSFA | 1880
2023-04-03 00:00:00 | QCOM | US TFSA | 55
2023-04-03 00:00:00 | AMD | US Cash | 62
2023-04-03 00:00:00 | UMC | US RSP | 20
2023-04-28 00:00:00 | AMD | US TFSA | 565
2023-04-28 00:00:00 | WKHS | US TSFA | 1880
2023-04-28 00:00:00 | QCOM | US TFSA | 55
2023-04-28 00:00:00 | AMD | US Cash | 62
2023-04-28 00:00:00 | UMC | US RSP | 20
2023-05-01 00:00:00 | AMD | US TFSA | 565
2023-05-01 00:00:00 | WKHS | US TSFA | 1880
2023-05-01 00:00:00 | QCOM | US TFSA | 55
2023-05-01 00:00:00 | AMD | US Cash | 62
2023-05-01 00:00:00 | UMC | US RSP | 20
2023-05-31 00:00:00 | AMD | US TFSA | 565
2023-05-31 00:00:00 | WKHS | US TSFA | 1880
2023-05-31 00:00:00 | QCOM | US TFSA | 55
2023-05-31 00:00:00 | AMD | US Cash | 62
2023-05-31 00:00:00 | UMC | US RSP | 20
2023-06-01 00:00:00 | AMD | US TFSA | 565
2023-06-01 00:00:00 | WKHS | US TSFA | 1880
2023-06-01 00:00:00 | QCOM | US TFSA | 55
2023-06-01 00:00:00 | AMD | US Cash | 62
2023-06-01 00:00:00 | UMC | US RSP | 20
2023-06-30 00:00:00 | AMD | US TFSA | 565
2023-06-30 00:00:00 | WKHS | US TSFA | 1880
2023-06-30 00:00:00 | QCOM | US TFSA | 55
2023-06-30 00:00:00 | AMD | US Cash | 62
2023-06-30 00:00:00 | UMC | US RSP | 20
2023-07-03 00:00:00 | AMD | US TFSA | 565
2023-07-03 00:00:00 | WKHS | US TSFA | 1880
2023-07-03 00:00:00 | QCOM | US TFSA | 55
2023-07-03 00:00:00 | AMD | US Cash | 62
2023-07-03 00:00:00 | UMC | US RSP | 20
2023-07-31 00:00:00 | AMD | US TFSA | 565
2023-07-31 00:00:00 | WKHS | US TSFA | 1880
2023-07-31 00:00:00 | QCOM | US TFSA | 55
2023-07-31 00:00:00 | AMD | US Cash | 62
2023-07-31 00:00:00 | UMC | US RSP | 20
2023-08-01 00:00:00 | AMD | US TFSA | 565
2023-08-01 00:00:00 | WKHS | US TSFA | 1880
2023-08-01 00:00:00 | QCOM | US TFSA | 55
2023-08-01 00:00:00 | AMD | US Cash | 62
2023-08-01 00:00:00 | UMC | US RSP | 20
2023-08-31 00:00:00 | AMD | US TFSA | 565
2023-08-31 00:00:00 | WKHS | US TSFA | 1880
2023-08-31 00:00:00 | QCOM | US TFSA | 55
2023-08-31 00:00:00 | AMD | US Cash | 62
2023-08-31 00:00:00 | UMC | US RSP | 20
2023-09-01 00:00:00 | AMD | US TFSA | 565
2023-09-01 00:00:00 | WKHS | US TSFA | 1880
2023-09-01 00:00:00 | QCOM | US TFSA | 55
2023-09-01 00:00:00 | AMD | US Cash | 62
2023-09-01 00:00:00 | UMC | US RSP | 20
2023-09-29 00:00:00 | AMD | US TFSA | 565
2023-09-29 00:00:00 | WKHS | US TSFA | 1880
2023-09-29 00:00:00 | QCOM | US TFSA | 55
2023-09-29 00:00:00 | AMD | US Cash | 62
2023-09-29 00:00:00 | UMC | US RSP | 20
2023-10-02 00:00:00 | AMD | US TFSA | 565
2023-10-02 00:00:00 | WKHS | US TSFA | 1880
2023-10-02 00:00:00 | QCOM | US TFSA | 55
2023-10-02 00:00:00 | AMD | US Cash | 62
2023-10-02 00:00:00 | UMC | US RSP | 20
2023-10-31 00:00:00 | AMD | US TFSA | 565
2023-10-31 00:00:00 | WKHS | US TSFA | 1880
2023-10-31 00:00:00 | QCOM | US TFSA | 55
2023-10-31 00:00:00 | AMD | US Cash | 62
2023-10-31 00:00:00 | UMC | US RSP | 20
2023-11-01 00:00:00 | AMD | US TFSA | 565
2023-11-01 00:00:00 | WKHS | US TSFA | 1880
2023-11-01 00:00:00 | QCOM | US TFSA | 55
2023-11-01 00:00:00 | AMD | US Cash | 62
2023-11-01 00:00:00 | UMC | US RSP | 20
2023-11-30 00:00:00 | AMD | US TFSA | 565
2023-11-30 00:00:00 | WKHS | US TSFA | 1880
2023-11-30 00:00:00 | QCOM | US TFSA | 55
2023-11-30 00:00:00 | AMD | US Cash | 62
2023-11-30 00:00:00 | UMC | US RSP | 20
2023-11-30 00:00:00 | SPTS | US RSP | 218
2023-11-30 00:00:00 | SPTI | US RSP | 104
2023-12-01 00:00:00 | AMD | US TFSA | 565
2023-12-01 00:00:00 | WKHS | US TSFA | 1880
2023-12-01 00:00:00 | QCOM | US TFSA | 55
2023-12-01 00:00:00 | AMD | US Cash | 62
2023-12-01 00:00:00 | UMC | US RSP | 20
2023-12-01 00:00:00 | SPTS | US RSP | 218
2023-12-01 00:00:00 | SPTI | US RSP | 104
2023-12-30 00:00:00 | AMD | US TFSA | 565
2023-12-30 00:00:00 | WKHS | US TSFA | 1880
2023-12-30 00:00:00 | QCOM | US TFSA | 55
2023-12-30 00:00:00 | AMD | US Cash | 62
2023-12-30 00:00:00 | UMC | US RSP | 20
2023-12-30 00:00:00 | SPTS | US RSP | 218
2023-12-30 00:00:00 | SPTI | US RSP | 104