Spreadsheet: 873522d1720015317-matching-then-summing-two-arrays-returns-portfolio-construciton
Sheet: Returns Data

 |  |  |  |  |  |  |  | Combined Fund Weightings |  |  |  | J6*B5:B64+J7*C5:C64+J8*D5:D64+J9*E5:E64+F5:F64*J10+J11*G5:G64
Date | Fund A | Fund B | Fund C | Fund D | Fund E | Fund F |  | Funds | Weights |  | Date | Combined Fund Return
2019-07-01 00:00:00 | 0.0723 | 0.0228 | -0.0555 |  | -0.0436 | -0.0441 |  | Total
2019-08-01 00:00:00 | -0.0458 | 0.0579 | 0.0799 |  | 0.096 | -0.0267 |  | Fund A | 0.4 |  | 2019-08-01 00:00:00 | 0.016935
2019-09-01 00:00:00 | 0.0322 | -0.0142 | 0.0236 |  | 0.0642 | 0.0364 |  | Fund B | 0.25 |  | 2019-09-01 00:00:00 | 0.01726
2019-10-01 00:00:00 | 0.0593 | 0.0852 | -0.0368 |  | -0.0417 | 0.0866 |  | Fund C | 0.2 |  | 2019-10-01 00:00:00 | 0.03557500000000001
2019-11-01 00:00:00 | -0.0685 | -0.0901 | -0.0622 |  | -0.0387 | 0.0883 |  | Fund D | 0.1 |  | 2019-11-01 00:00:00 | -0.06430000000000001
2019-12-01 00:00:00 | -0.0961 | -0.037 | 0.0947 |  | 0.0731 | 0.0561 |  | Fund E | 0.05 |  | 2019-12-01 00:00:00 | -0.025095
2020-01-01 00:00:00 | 0.0898 | -0.0328 | -0.0538 |  | -0.0012 | 0.0488 |  | Fund F | 0 |  | 2020-01-01 00:00:00 | 0.0169
2020-02-01 00:00:00 | -0.0319 | -0.0979 | -0.0373 |  | -0.0222 | 0.0831 |  |  |  |  | 2020-02-01 00:00:00 | -0.04580500000000001
2020-03-01 00:00:00 | -0.0753 | -0.0135 | 0.0651 |  | 0.0084 | -0.0829 |  |  |  |  | 2020-03-01 00:00:00 | -0.020055
2020-04-01 00:00:00 | -0.0893 | -0.0638 | -0.0876 |  | 0.0877 | -0.082 |  |  |  |  | 2020-04-01 00:00:00 | -0.064805
2020-05-01 00:00:00 | -0.0812 | -0.0232 | 0.0529 |  | -0.0856 | -0.0768 |  |  |  |  | 2020-05-01 00:00:00 | -0.03198
2020-06-01 00:00:00 | 0.0246 | 0.0587 | 0.0251 |  | -0.0064 | 0.0281 |  |  |  |  | 2020-06-01 00:00:00 | 0.029215
2020-07-01 00:00:00 | 0.0786 | -0.0278 | 0.0575 |  | -0.0136 | -0.039 |  |  |  |  | 2020-07-01 00:00:00 | 0.03531000000000001
2020-08-01 00:00:00 | 0.071 | -0.0371 | -0.0554 |  | -0.0675 | 0.0774 |  |  |  |  | 2020-08-01 00:00:00 | 0.004669999999999996
2020-09-01 00:00:00 | 0.0371 | -0.0537 | 0.093 |  | 0.0686 | -0.0409 |  |  |  |  | 2020-09-01 00:00:00 | 0.023445
2020-10-01 00:00:00 | 0.0773 | 0.0204 | 0.0394 |  | -0.0864 | 0.0049 |  |  |  |  | 2020-10-01 00:00:00 | 0.03958
2020-11-01 00:00:00 | 0.0414 | -0.0838 | -0.0107 | 0.0177 | 0.047 | 0.087 |  |  |  |  | 2020-11-01 00:00:00 | -0.002409999999999998
2020-12-01 00:00:00 | 0.0186 | 0.0224 | 0.0013 | 0.0365 | -0.0397 | -0.0594 |  |  |  |  | 2020-12-01 00:00:00 | 0.014965
2021-01-01 00:00:00 | 0.0829 | 0.0645 | 0.0259 | 0.0636 | 0.0473 | -0.0917 |  |  |  |  | 2021-01-01 00:00:00 | 0.06319000000000001
2021-02-01 00:00:00 | -0.0396 | -0.0108 | -0.0963 | 0.0579 | 0.0313 | 0.0374 |  |  |  |  | 2021-02-01 00:00:00 | -0.030445
2021-03-01 00:00:00 | -0.0366 | 0.0106 | -0.0832 | 0.0304 | -0.0742 | 0.0232 |  |  |  |  | 2021-03-01 00:00:00 | -0.0293
2021-04-01 00:00:00 | -0.0001 | -0.0024 | 0.0592 | -0.0215 | 0.0273 | 0.0929 |  |  |  |  | 2021-04-01 00:00:00 | 0.010415
2021-05-01 00:00:00 | 0.0735 | 0.0899 | 0.05 | -0.0814 | -0.0609 | 0.0486 |  |  |  |  | 2021-05-01 00:00:00 | 0.05069
2021-06-01 00:00:00 | -0.0425 | 0.067 | 0.0416 | -0.0771 | -0.0517 | -0.0945 |  |  |  |  | 2021-06-01 00:00:00 | -0.002225000000000002
2021-07-01 00:00:00 | 0.0076 | -0.0571 | 0.0228 | 0.01 | 0.0482 | 0.0107 |  |  |  |  | 2021-07-01 00:00:00 | -0.003264999999999998
2021-08-01 00:00:00 | 0.0468 | 0.0258 | 0.0605 | -0.0474 | 0.0801 | -0.0621 |  |  |  |  | 2021-08-01 00:00:00 | 0.036535
2021-09-01 00:00:00 | -0.0893 | 0.0057 | -0.0316 | -0.015 | 0.0338 | 0.0098 |  |  |  |  | 2021-09-01 00:00:00 | -0.040425
2021-10-01 00:00:00 | 0.0353 | 0.0428 | 0.0755 | -0.0694 | -0.0987 | 0.0819 |  |  |  |  | 2021-10-01 00:00:00 | 0.028045
2021-11-01 00:00:00 | 0.0959 | 0.0677 | -0.0713 | 0.093 | 0.0958 | 0.0516 |  |  |  |  | 2021-11-01 00:00:00 | 0.055115
2021-12-01 00:00:00 | 0.045 | -0.0837 | 0.0844 | 0.025 | 0.0405 | 0.0794 |  |  |  |  | 2021-12-01 00:00:00 | 0.01848
2022-01-01 00:00:00 | 0.0824 | 0.0478 | -0.0843 | -0.0922 | -0.0486 | -0.0312 |  |  |  |  | 2022-01-01 00:00:00 | 0.0164
2022-02-01 00:00:00 | 0.009 | 0.0323 | 0.0174 | -0.0793 | 0.0527 | -0.0549 |  |  |  |  | 2022-02-01 00:00:00 | 0.009860000000000002
2022-03-01 00:00:00 | -0.0535 | -0.0048 | 0.063 | 0.0577 | -0.0961 | -0.0795 |  |  |  |  | 2022-03-01 00:00:00 | -0.009035000000000001
2022-04-01 00:00:00 | -0.0183 | 0.0963 | 0.0743 | 0.0735 | 0.0833 | 0.0893 |  |  |  |  | 2022-04-01 00:00:00 | 0.04313000000000001
2022-05-01 00:00:00 | 0.0492 | -0.0221 | 0.0023 | 0.0449 | -0.002 | -0.042 |  |  |  |  | 2022-05-01 00:00:00 | 0.019005
2022-06-01 00:00:00 | -0.0424 | 0.0996 | 0.046 | -0.0401 | 0.0745 | -0.0732 |  |  |  |  | 2022-06-01 00:00:00 | 0.016855
2022-07-01 00:00:00 | -0.0365 | 0.0172 | -0.0768 | 0.0048 | -0.0797 | 0.0044 |  |  |  |  | 2022-07-01 00:00:00 | -0.029165
2022-08-01 00:00:00 | 0.0105 | 0.0155 | 0.0787 | 0.0369 | -0.0232 | -0.0233 |  |  |  |  | 2022-08-01 00:00:00 | 0.026345
2022-09-01 00:00:00 | -0.0399 | -0.0362 | -0.0993 | 0.0182 | -0.0555 | 0.0678 |  |  |  |  | 2022-09-01 00:00:00 | -0.045825
2022-10-01 00:00:00 | -0.065 | -0.0724 | 0.0707 | 0.0987 | -0.0057 | -0.0463 |  |  |  |  | 2022-10-01 00:00:00 | -0.020375
2022-11-01 00:00:00 | 0.0497 | -0.0896 | -0.0741 | -0.0999 | 0.052 | 0.0516 |  |  |  |  | 2022-11-01 00:00:00 | -0.02473
2022-12-01 00:00:00 | 0.0586 | -0.0776 | 0.0919 | -0.0211 | 0.0101 | 0.0808 |  |  |  |  | 2022-12-01 00:00:00 | 0.020815
2023-01-01 00:00:00 | 0.0684 | 0.0277 | -0.0592 | 0.0342 | 0.0028 | -0.0627 |  |  |  |  | 2023-01-01 00:00:00 | 0.026005
2023-02-01 00:00:00 | 0.0721 | 0.0773 | -0.0436 | 0.0714 | 0.0429 | -0.0008 |  |  |  |  | 2023-02-01 00:00:00 | 0.04873
2023-03-01 00:00:00 | -0.0981 | -0.0152 | -0.0757 | 0.0289 | 0.0724 | 0.0494 |  |  |  |  | 2023-03-01 00:00:00 | -0.05167000000000001
2023-04-01 00:00:00 | -0.0912 | -0.0743 | 0.0699 | 0.0919 | 0.089 | -0.0915 |  |  |  |  | 2023-04-01 00:00:00 | -0.02743500000000001
2023-05-01 00:00:00 | 0.08 | -0.0093 | 0.0145 | -0.0147 | -0.0769 | 0.0183 |  |  |  |  | 2023-05-01 00:00:00 | 0.02726
2023-06-01 00:00:00 | 0.0056 | 0.0911 | 0.0224 | -0.0041 | -0.0884 | 0.0454 |  |  |  |  | 2023-06-01 00:00:00 | 0.024665
2023-07-01 00:00:00 | 0.0064 | -0.0422 | -0.0759 | -0.0848 | -0.0825 | 0.0323 |  |  |  |  | 2023-07-01 00:00:00 | -0.035775
2023-08-01 00:00:00 | -0.0964 | 0.0007 | -0.0844 | 0.0519 | 0.0865 | -0.0477 |  |  |  |  | 2023-08-01 00:00:00 | -0.04575000000000001
2023-09-01 00:00:00 | 0.0211 | 0.0265 | 0.0867 | -0.063 | 0.073 | 0.0099 |  |  |  |  | 2023-09-01 00:00:00 | 0.029755
2023-10-01 00:00:00 | 0.0457 | 0.0199 | 0.0781 | -0.0297 | 0.0057 | -0.0336 |  |  |  |  | 2023-10-01 00:00:00 | 0.03619000000000001
2023-11-01 00:00:00 | 0.0366 | -0.0114 | -0.0739 | 0.0869 | 0.0365 | -0.0404 |  |  |  |  | 2023-11-01 00:00:00 | 0.007525000000000002
2023-12-01 00:00:00 | -0.0435 | 0.0944 | 0.0627 | 0.0036 | 0.02 | 0.0489 |  |  |  |  | 2023-12-01 00:00:00 | 0.0201
2024-01-01 00:00:00 | -0.0704 | -0.0062 | 0.0852 | -0.0444 | 0.0189 | -0.0588 |  |  |  |  | 2024-01-01 00:00:00 | -0.016165
2024-02-01 00:00:00 | -0.0026 | 0.0507 | -0.0784 | -0.0864 | -0.0809 | -0.0248 |  |  |  |  | 2024-02-01 00:00:00 | -0.01673
2024-03-01 00:00:00 | -0.0854 | -0.0449 | -0.0747 | 0.0447 | 0.0984 | 0.0034 |  |  |  |  | 2024-03-01 00:00:00 | -0.050935
2024-04-01 00:00:00 | -0.0308 | 0.0449 | 0.0043 | 0.0286 | 0.0639 | -0.0143 |  |  |  |  | 2024-04-01 00:00:00 | 0.00582
2024-05-01 00:00:00 | -0.0043 | 0.0732 | 0.0249 | 0.0051 |  |  |  |  |  |  | 2024-05-01 00:00:00 | 0.02207
2024-06-01 00:00:00 |  |  | -0.0653 | 0.0314 |  |  |  |  |  |  | 2024-06-01 00:00:00 | -0.00992