Spreadsheet: 852756d1702680605-calculating-portfolio-returns-given-changes-to-holdings-portfolio-value
Sheet: Cash Balance

Date | Year | Month | Quarter | Chequing | Savings | US TFSA_CAD | US Cash_CAD | US RSP_CAD | US TFSA_US | US Cash_US | US RSP_US | Total Cash
2022-01-31 00:00:00 |  |  |  |  | 31.5 | 1006.1813581088 | 214.4427893664 | 187.3642080224009 | 787.802504 | 167.900712 | 146.6991920000007 |  |  | Chequing | Savings | US TFSA_US | US Cash_US | US RSP_US
2022-02-01 00:00:00 |  |  |  |  | 31.5 | 1006.1813581088 | 214.4427893664 | 187.3642080224009 | 787.802504 | 167.900712 | 146.6991920000007
2022-02-28 00:00:00 |  |  |  |  | 32.5 | 996.9067600658002 | 212.4661370874001 | 185.6371558334016 | 784.1632660000001 | 167.125098 | 146.0215180000013
2022-03-01 00:00:00 |  |  |  |  | 32.5 | 996.9067600658002 | 212.4661370874001 | 185.6371558334016 | 784.1632660000001 | 167.125098 | 146.0215180000013
2022-03-31 00:00:00 |  |  |  | 5881.38 | 33.5 | 964.3195611504 | 205.5209777712 | 179.5689906192015 | 770.284816 | 164.167248 | 143.4371680000012
2022-04-01 00:00:00 |  |  |  | 5881.38 | 33.5 | 964.3195611504 | 205.5209777712 | 179.5689906192015 | 770.284816 | 164.167248 | 143.4371680000012
2022-04-30 00:00:00 |  |  |  | 5223.2 | 35.5 | 1017.3992475618 | 216.8336063754 | 189.4531266414017 | 792.1819260000001 | 168.834078 | 147.5146980000013
2022-05-01 00:00:00 |  |  |  | 5223.2 | 35.5 | 1017.3992475618 | 216.8336063754 | 189.4531266414017 | 792.1819260000001 | 168.834078 | 147.5146980000013
2022-05-31 00:00:00 |  |  |  | 10689.53 | 37.01 | 998.3187535688 | 212.7670687464 | 185.9000876024016 | 784.7184040000001 | 167.243412 | 146.1248920000013
2022-06-01 00:00:00 |  |  |  | 10689.53 | 37.01 | 998.3187535688 | 212.7670687464 | 185.9000876024016 | 784.7184040000001 | 167.243412 | 146.1248920000013
2022-06-30 00:00:00 |  |  |  | 10894.11 | 37.01 | 1025.1774402848 | 218.4913366944 | 190.9015284704016 | 795.204344 | 169.478232 | 148.0775120000013
2022-07-01 00:00:00 |  |  |  | 10894.11 | 37.01 | 1025.1774402848 | 218.4913366944 | 190.9015284704016 | 795.204344 | 169.478232 | 148.0775120000013
2022-07-31 00:00:00 |  |  |  | 13384.39 | 37.01 | 1012.0195409042 | 215.6870543226 | 15092.4169639394 | 790.084738 | 168.387114 | 11782.666066
2022-08-01 00:00:00 |  |  |  | 13384.39 | 37.01 | 1012.0195409042 | 215.6870543226 | 15092.4169639394 | 790.084738 | 168.387114 | 11782.666066
2022-08-30 00:00:00 |  |  |  | 12734.75 | 37.01 | 1048.2072291872 | 223.3995693216 | 15632.0900220704 | 804.0865520000001 | 171.371256 | 11991.477464
2022-09-01 00:00:00 |  |  |  | 12734.75 | 37.01 | 1048.2072291872 | 223.3995693216 | 15632.0900220704 | 804.0865520000001 | 171.371256 | 11991.477464
2022-09-30 00:00:00 |  |  |  | 11695.76 | 37.01 | 1180.2967217298 | 251.5511932794 | 17601.9627541986 | 853.247106 | 181.848618 | 12724.617042
2022-10-01 00:00:00 |  |  |  | 11695.76 | 37.01 | 1180.2967217298 | 251.5511932794 | 17601.9627541986 | 853.247106 | 181.848618 | 12724.617042
2022-10-31 00:00:00 |  |  |  | 6446.2 | 37.01 | 1145.991851824 | 244.239954672 | 17090.368481968 | 839.862112 | 178.995936 | 12525.004384
2022-11-01 00:00:00 |  |  |  | 6446.2 | 37.01 | 1145.991851824 | 244.239954672 | 17090.368481968 | 839.862112 | 178.995936 | 12525.004384
2022-11-30 00:00:00 |  |  |  | 4007.1 | 37.01 | 1108.8019605732 | 236.3138447796 | 16535.7494030724 | 827.340666 | 176.327298 | 12338.269962
2022-12-01 00:00:00 |  |  |  | 4007.1 | 37.01 | 1108.8019605732 | 236.3138447796 | 16535.7494030724 | 827.340666 | 176.327298 | 12338.269962
2022-12-31 00:00:00 |  |  |  | 4945.11 | 37.01 | 1135.84257218 | 242.07688554 | 16939.01057426 | 837.0247400000001 | 178.39122 | 12482.69018
2023-01-01 00:00:00 |  |  |  | 4945.11 | 37.01 | 1135.84257218 | 242.07688554 | 16939.01057426 | 837.0247400000001 | 178.39122 | 12482.69018
2023-01-31 00:00:00 |  |  |  | 8653.57 | 37.01 | 1094.703731439 | 233.309154267 | 16325.500150023 | 820.6790100000001 | 174.90753 | 12238.92357
2023-02-01 00:00:00 |  |  |  | 8653.57 | 37.01 | 1094.703731439 | 233.309154267 | 16325.500150023 | 820.6790100000001 | 174.90753 | 12238.92357
2023-02-28 00:00:00 |  |  |  | 8135.88 | 38.01 | 1147.5908404782 | 244.5807397446 | 17114.2144676574 | 841.774254 | 179.403462 | 12553.520478
2023-03-01 00:00:00 |  |  |  | 8135.88 | 38.01 | 1147.5908404782 | 244.5807397446 | 17114.2144676574 | 841.774254 | 179.403462 | 12553.520478
2023-03-31 00:00:00 |  |  |  | 7989.88 | 39.01 | 1128.6555644178 | 240.5451517434 | 16831.8295234146 | 834.372414 | 177.825942 | 12443.135598
2023-04-01 00:00:00 |  |  |  | 7989.88 | 39.01 | 1128.6555644178 | 240.5451517434 | 16831.8295234146 | 834.372414 | 177.825942 | 12443.135598
2023-04-30 00:00:00 |  |  |  | 11267.57 | 40.01 | 1141.947733176 | 243.378050328 | 17030.057863032 | 836.4079200000001 | 178.25976 | 12473.49144
2023-05-01 00:00:00 |  |  |  | 11267.57 | 40.01 | 1141.947733176 | 243.378050328 | 17030.057863032 | 836.4079200000001 | 178.25976 | 12473.49144
2023-05-31 00:00:00 |  |  |  |  | 40.01 | 1139.4409273504 | 242.8437863712 | 16992.6734477728 | 836.8396940000001 | 178.351782 | 12479.930558
2023-06-01 00:00:00 |  |  |  |  | 40.01 | 1139.4409273504 | 242.8437863712 | 16992.6734477728 | 836.8396940000001 | 178.351782 | 12479.930558
2023-06-30 00:00:00 |  |  |  |  | 40.01 | 1082.2508819912 | 230.6551359336 | 16139.7887198984 | 817.0397720000001 | 174.131916 | 12184.651004
2023-07-01 00:00:00 |  |  |  |  | 40.01 | 1082.2508819912 | 230.6551359336 | 16139.7887198984 | 817.0397720000001 | 174.131916 | 12184.651004
2023-07-31 00:00:00 |  |  |  |  | 6040.01 | 1078.4091913308 | 229.8363741324 | 16082.4969434556 | 813.832308 | 173.448324 | 12136.817556
2023-08-01 00:00:00 |  |  |  |  | 6040.01 | 1078.4091913308 | 229.8363741324 | 16082.4969434556 | 813.832308 | 173.448324 | 12136.817556
2023-08-30 00:00:00 |  |  |  |  | 6242.61 | 1130.903756122 | 241.024298466 | 16865.357182954 | 833.3238200000001 | 177.60246 | 12427.49774
2023-09-01 00:00:00 |  |  |  |  | 6242.61 | 1130.903756122 | 241.024298466 | 16865.357182954 | 833.3238200000001 | 177.60246 | 12427.49774
2023-09-30 00:00:00 |  |  |  |  | 5046.13 | 889.7392000000001 | 178.7856 | 12510.2864 | 654.22 | 131.46 | 9198.74
2023-10-01 00:00:00 |  |  |  |  | 5046.13 | 889.7392000000001 | 178.7856 | 12510.2864 | 654.22 | 131.46 | 9198.74
2023-10-31 00:00:00 |  |  |  | 4519.49 | 4539.95 | 902.8235999999999 | 181.4148 | 12694.2612 | 654.22 | 131.46 | 9198.74
2023-11-01 00:00:00 |  |  |  | 4519.49 | 4539.95 | 902.8235999999999 | 181.4148 | 12694.2612 | 654.22 | 131.46 | 9198.74
2023-11-30 00:00:00 |  |  |  | 4202.22 | 4540.99 | 889.08498 | 178.65414 | 261.09108 | 654.22 | 131.46 | 192.12
2023-12-01 00:00:00 |  |  |  | 4202.22 | 4540.99 | 886.860632 | 178.207176 | 260.437872 | 654.22 | 131.46 | 192.12
2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjust for 149.50 that was sitting in CAD TFSA