50.1K
Verified Solution
Link Copied!
calculate portfolio value of each week by taking average of 7 days,week by week (monday to friday)
the data below is of the trading history so we have to find and calculate from this data only
Week r(P) weekly r(M) weekly r(f) weekly r(P) monthly r(M) monthly r(f) monthly R(P) monthly R(M) monthly ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Portfolio(Value) ASX 200 ("AXJO) Risk-free rate (%) 0 500000 ? 1 ? ? ? 2 ? ? ? 3 ? ? ? 4 ? ? ? 5 ? ? ? 6 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 7 ? ? ? ? ? ? ? ? ? ? ? 8 ? ? ? ? ? ? ? ? ? Average Stdev Variance Geomatric average B C D E F G 1 ticker 2 CQE-AU 3 CQE-AU 4 5 6 DIS-US 7 DIS-US 8 IQV-US 9 IQV-US 10 SBUX-US 11 SBUX-US 12 UNH-US 13 UNH-US 14 15 16 CQE-AU 17 CQE-AU 18 MTS-AU 19 MTS-AU 20 BHP-ASX 21 BHP-ASX 22 23 24 25 26 27 28 29 30 31 32 SBUX-US 33 SBUX-US 34 DIS-US 35 DIS-US 36 IQV-US 37 IQV-US 38 39 40 41 volume price -1000.0000 3.8300 -1000.0000 0.0010 496347.8549 1.0000 -2619.7603 0.6833 -400.0000 114.7400 - 400.0000 0.0010 -100.0000 221.3200 -100.0000 0.0010 -20.0000 80.4250 -20.0000 0.0010 -25.0000 507.2100 -25.0000 0.0010 496334.25671.0000 -84852.6050 0.6833 1000.0000 3.9100 1000.0000 0.0010 -1000.0000 4.6600 -1000.0000 0.0010 -300.0000 47.5900 -300.0000 0.0010 481316.9169 1.0000 -84851.0165 0.6833 481303.73051.0000 -84849.4281 0.6833 481290.5445 1.0000 -84847.8397 0.6833 481277.3588 1.0000 -84846.2513 0.6833 481264.1735 1.0000 -84844.66306.6833 -200.0000 76.0200 -200.0000 0.0010 400.0000 115.2000 400.0000 0.0010 100.0000 222.3200 100.0000 0.0010 481250.98851.0000 -31652.5544 0.6833 481237.80391.0000 -31651.9619 0.6833 type Stock Stock Other Other Stock Stock Stock Stock Stock Stock Stock Stock Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other subtype net currency 3830.0000 AUD Commission -3.8300 AUD Interest 13.5986 AUD Interest -0.0490 USD 45896.0000 USD Commission -45.8960 USD 22132.0000 USD Commission -22.1320 USD 1608.5000 USD Commission - 1.6085 USD 12680.2500 USD Commission -12.6803 USD Interest 13.5982 AUD Interest -1.5885 USD -3910.0000 AUD Commission -3.9100 AUD 4660.0000 AUD Commission -4.6600 AUD 14277.0000 AUD Commission -14.2770 AUD Interest 13.1868 AUD Interest -1.5885 USD Interest 13.1864 AUD Interest -1.5884 USD Interest 13.1860 AUD Interest -1.5884 USD Interest 13.1857 AUD Interest -1.5884 USD Interest 13.1853 AUD Interest -1.5883 USD 15204.0000 USD Commission -15.2040 USD - 46080.0000 USD Commission - 46.0800 USD -22232.0000 USD Commission -22.2320 USD Interest 13.1850 AUD Interest -0.5926 USD Interest 13.1846 AUD Interest -0.5925 USD country timestamp Australia 2022-05-06 12:26:17 AM Australia 2022-05-06 12:26:17 AM AU 2022-05-05 11:00:01 PM US 2022-05-05 11:00:01 PM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM AU 2022-05-04 11:00:03 PM US 2022-05-04 11:00:03 PM Australia 2022-05-04 10:23:09 PM Australia 2022-05-04 10:23:09 PM Australia 2022-05-04 10:08:40 PM Australia 2022-05-04 10:08:40 PM Australia 2022-05-04 10:07:25 PM Australia 2022-05-04 10:07:25 PM AU 2022-05-03 11:00:04 PM US 2022-05-03 11:00:04 PM AU 2022-05-02 11:00:03 PM US 2022-05-02 11:00:03 PM AU 2022-05-01 11:00:04 PM US 2022-05-01 11:00:04 PM AU 2022-04-30 11:00:01 PM US 2022-04-30 11:00:01 PM AU 2022-04-29 11:00:04 PM US 2022-04-29 11:00:04 PM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM AU 2022-04-28 11:00:02 PM US 2022-04-28 11:00:02 PM AU 2022-04-27 11:00:04 PM US 2022-04-27 11:00:04 PM Other Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other A D E F G H AU US AUD USD AUD USD AU US AUD AU US AU US 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 AU US AU US AU US AU US AU US AU US B 481224.61971.0000 -31651.3694 0.6833 481211.4358 1.0000 -31650.7769 0.6833 481198.2523'1.0000 -31650.1844 0.6833 481185.0691 1.0000 -31649.5919 0.6833 481171.88631.0000 -31648.99946.6833 481158.7039 1.0000 -31648.4069 0.6833 481145.52181.0000 -31647.8144 0.6833 481132.3401 1.0000 -31647.2219 0.6833 481119.1588 1.0000 -31646.62956.6833 481105.97781.0000 -31646.0371 0.6833 481092.79721.0000 -31645.4447 0.6833 481079.6169 1.0000 -31644.85236.6833 481066.4370 1.0000 -31644.2599 0.6833 481053.2575 1.0000 -31643.6675 0.6833 481040.0783 1.0000 -31643.07516.6833 481026.89951.0000 -31642.48276.6833 481013.7210 1.0000 -31641.8903 0.6833 481000.5429 1.0000 -31641.2980 0.6833 480987.3652 1.0000 -31640.7057 0.6833 480974.1878 1.0000 -31640.1134 0.6833 480961.0108 1.0000 Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest 13.1842 -0.5925 13.1839 -0.5925 13.1835 -0.5925 13.1832 -0.5925 13.1828 -0.5925 13.1824 -0.5925 13.1821 -0.5925 13.1817 -0.5925 13.1813 -0.5924 13.1810 -0.5924 13.1806 -0.5924 13.1803 -0.5924 13.1799 -0.5924 13.1795 -0.5924 13.1792 -0.5924 13.1788 -0.5924 13.1785 -0.5924 13.1781 -0.5923 13.1777 -0.5923 13.1774 -0.5923 13.1770 USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AU US AU US 2022-04-26 11:00:04 PM 2022-04-26 11:00:04 PM 2022-04-25 11:00:02 PM 2022-04-25 11:00:02 PM 2022-04-24 11:00:02 PM 2022-04-24 11:00:02 PM 2022-04-23 11:00:00 PM 2022-04-23 11:00:00 PM 2022-04-22 11:00:03 PM 2022-04-22 11:00:03 PM 2022-04-21 11:00:02 PM 2022-04-21 11:00:02 PM 2022-04-20 11:00:01 PM 2022-04-20 11:00:01 PM 2022-04-19 11:00:01 PM 2022-04-19 11:00:01 PM 2022-04-18 11:00:04 PM 2022-04-18 11:00:04 PM 2022-04-17 11:00:04 PM 2022-04-17 11:00:04 PM 2022-04-16 11:00:00 PM 2022-04-16 11:00:00 PM 2022-04-15 11:00:00 PM 2022-04-15 11:00:00 PM 2022-04-14 11:00:01 PM 2022-04-14 11:00:01 PM 2022-04-13 11:00:03 PM 2022-04-13 11:00:03 PM 2022-04-12 11:00:04 PM 2022-04-12 11:00:04 PM 2022-04-11 11:00:02 PM 2022-04-11 11:00:02 PM 2022-04-10 11:00:01 PM 2022-04-10 11:00:01 PM 2022-04-09 11:00:01 PM 2022-04-09 11:00:01 PM 2022-04-08 11:00:00 PM 2022-04-08 11:00:00 PM 2022-04-07 11:00:04 PM 2022-04-07 11:00:04 PM 2022-04-06 11:00:04 PM 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 AU US AU US AU US AU US AU US AU AUD USD AUD USD AUD US AU US AU US 82 AU J23 x fx A H I J 82 83 84 85 86 87 88 89 90 91 92 USD USD USD 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 B C 480961.0108 1.0000 -31639.5211 0.6833 480947.83411.0000 -31638.9288 0.6833 480934.65781.0000 -31638.3365 0.6833 480921.48191.0000 -31637.7442 0.6833 480908.30631.0000 -31637.1519 6.6833 480895.13111.0000 -31636.5596 0.6833 480881.95631.0000 -31635.9674 0.6833 480868.7818 1.0000 -31635.3752 6.6833 480855.6077 1.0000 -31634.78306.6833 480842.4339 1.0000 -31634.1908 6.6833 480829.26051.0000 -31633.5986 0.6833 480816.0875 1.0000 -31633.0064 0.6833 480802.9148 1.0000 -31632.4142 0.6833 480789.7425 1.0000 -31631.82200.6833 220.0000 86.8300 220.0000 300.0000 49.4300 300.0000 0.0010 1000.0000 4.5400 1000.0000 6.0010 500164.40841.0000 -12509.88526.6833 500150.70561.0000 -12509.6510 0.6833 500137.0032 1.0000 -12509.4168 0.6833 500123.3012 1.0000 D Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other E F G Interest 13.1770 AUD Interest -0.5923 USD Interest 13.1767 AUD Interest -0.5923 USD Interest 13.1763 AUD Interest -0.5923 USD Interest 13.1759 AUD Interest -0.5923 USD Interest 13.1756 AUD Interest -0.5923 Interest 13.1752 AUD Interest -0.5923 USD Interest 13.1748 AUD Interest -0.5922 Interest 13.1745 AUD Interest -0.5922 USD Interest 13.1741 AUD Interest -0.5922 Interest 13.1738 AUD Interest -0.5922 USD Interest 13.1734 AUD Interest -0.5922 USD Interest 13.1730 AUD Interest -0.5922 USD Interest 13.1727 AUD Interest -0.5922 USD Interest 13.1723 Interest -0.5922 USD -19102.6000 USD Commission 19.1026 USD -14829.0000 AUD Commission - 14.8290 AUD -4540.0000 AUD Commission -4.5400 AUD Interest 13.7031 Interest -0.2342 USD Interest 13.7028 AUD Interest -0.2342 USD Interest 13.7024 AUD Interest -0.2342 USD Interest 13.7020 AUD AU 2022-04-06 11:00:04 PM US 2022-04-06 11:00:04 PM AU 2022-04-05 11:00:00 PM US 2022-04-05 11:00:00 PM AU 2022-04-04 11:00:01 PM US 2022-04-04 11:00:01 PM AU 2022-04-03 11:00:04 PM US 2022-04-03 11:00:04 PM AU 2022-04-02 11:00:01 PM US 2022-04-02 11:00:01 PM AU 2022-04-01 11:00:01 PM US 2022-04-01 11:00:01 PM AU 2022-03-31 11:00:00 PM US 2022-03-31 11:00:00 PM AU 2022-03-30 11:00:03 PM US 2022-03-30 11:00:03 PM AU 2022-03-29 11:00:02 PM US 2022-03-29 11:00:02 PM AU 2022-03-28 11:00:03 PM US 2022-03-28 11:00:03 PM AU 2022-03-27 11:00:04 PM US 2022-03-27 11:00:04 PM AU 2022-03-26 11:00:00 PM US 2022-03-26 11:00:00 PM AU 2022-03-25 11:00:00 PM US 2022-03-25 11:00:00 PM AU 2022-03-24 11:00:00 PM US 2022-03-24 11:00:00 PM United State 2022-03-24 9:30:06 AM United State 2022-03-24 9:30:06 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:06:47 AM Australia 2022-03-24 12:06:47 AM AU 2022-03-23 11:00:03 PM US 2022-03-23 11:00:03 PM AU 2022-03-22 11:00:03 PM US 2022-03-22 11:00:03 PM AU 2022-03-21 11:00:00 PM US 2022-03-21 11:00:00 PM AU 2022-03-20 11:00:01 PM 108 AUD 109 0.0010 110 SBUX-US 111 SBUX-US 112 BHP-ASX 113 BHP-ASX 114 MTS-AU 115 MTS-AU 116 AUD 117 118 119 120 121 122 D 109 110 SBUX-US 111 SBUX-US 112 BHP-ASX 113 BHP-ASX 114 MTS-AU 115 MTS-AU 116 117 118 119 120 121 122 123 124 B -31631.8220 0.6833 220.0000 86.8300 220.0000 0.0010 300.0000 49.4300 300.0000 0.0010 1000.0000 4.5400 1000.0000 0.0010 500164.4084 1.0000 -12509.88526.6833 500150.70561.0000 -12509.65100.6833 500137.0032 1.0000 -12509.4168 0.6833 500123.30121.0000 12509.1826 0.6833 500109.59961.0000 -12508.9484 0.6833 500095.8983 1.0000 12508.7142 0.6833 500082.1974 1.0000 -12508.4800 0.6833 500068.49691.0000 12508.2458 0.6833 25.0000 499.8300 25.0000 0.0010 500054.7968 1.0000 500041.09701.0000 500027.39761.0000 500013.6986 1.0000 500000.0000 1.0000 Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Stock Stock Other Other Other Other Other E F G Interest -0.5922 USD -19102.6000 USD Commission -19.1026 USD -14829.0000 AUD Commission -14.8290 AUD -4540.0000 AUD Commission - 4.5400 AUD Interest 13.7031 AUD Interest -0.2342 USD Interest 13.7028 AUD Interest -0.2342 USD Interest 13.7024 AUD Interest -0.2342 USD Interest 13.7020 AUD Interest -0.2342 USD Interest 13.7016 AUD Interest -0.2342 USD Interest 13.7013 AUD Interest -0.2342 USD Interest 13.7009 AUD Interest -0.2342 USD Interest 13.7005 AUD Interest -0.2342 USD -12495.7500 USD Commission -12.4958 USD Interest 13.7001 AUD Interest 13.6998 AUD Interest 13.6994 AUD Interest 13.6990 AUD Interest 13.6986 AUD H US 2022-03-24 11:00:00 PM United State 2022-03-24 9:30:06 AM United State 2022-03-24 9:30:06 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:06:47 AM Australia 2022-03-24 12:06:47 AM AU 2022-03-23 11:00:03 PM US 2022-03-23 11:00:03 PM AU 2022-03-22 11:00:03 PM US 2022-03-22 11:00:03 PM AU 2022-03-21 11:00:00 PM US 2022-03-21 11:00:00 PM AU 2022-03-20 11:00:01 PM US 2022-03-20 11:00:01 PM AU 2022-03-19 11:00:04 PM US 2022-03-19 11:00:04 PM AU 2022-03-18 11:00:03 PM US 2022-03-18 11:00:03 PM AU 2022-03-17 11:00:00 PM US 2022-03-17 11:00:00 PM AU 2022-03-16 11:00:02 PM US 2022-03-16 11:00:02 PM United State 2022-03-16 9:30:25 AM United State 2022-03-16 9:30:25 AM AU 2022-03-15 11:00:03 PM AU 2022-03-14 11:00:04 PM AU 2022-03-13 11:00:04 PM 2022-03-12 11:00:04 PM 2022-03-11 11:00:00 PM 125 126 127 128 129 130 131 132 UNH-US 133 UNH-US 134 135 136 137 138 22 22 25 139 140 141 142 143 144 145 Week r(P) weekly r(M) weekly r(f) weekly r(P) monthly r(M) monthly r(f) monthly R(P) monthly R(M) monthly ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Portfolio(Value) ASX 200 ("AXJO) Risk-free rate (%) 0 500000 ? 1 ? ? ? 2 ? ? ? 3 ? ? ? 4 ? ? ? 5 ? ? ? 6 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 7 ? ? ? ? ? ? ? ? ? ? ? 8 ? ? ? ? ? ? ? ? ? Average Stdev Variance Geomatric average B C D E F G 1 ticker 2 CQE-AU 3 CQE-AU 4 5 6 DIS-US 7 DIS-US 8 IQV-US 9 IQV-US 10 SBUX-US 11 SBUX-US 12 UNH-US 13 UNH-US 14 15 16 CQE-AU 17 CQE-AU 18 MTS-AU 19 MTS-AU 20 BHP-ASX 21 BHP-ASX 22 23 24 25 26 27 28 29 30 31 32 SBUX-US 33 SBUX-US 34 DIS-US 35 DIS-US 36 IQV-US 37 IQV-US 38 39 40 41 volume price -1000.0000 3.8300 -1000.0000 0.0010 496347.8549 1.0000 -2619.7603 0.6833 -400.0000 114.7400 - 400.0000 0.0010 -100.0000 221.3200 -100.0000 0.0010 -20.0000 80.4250 -20.0000 0.0010 -25.0000 507.2100 -25.0000 0.0010 496334.25671.0000 -84852.6050 0.6833 1000.0000 3.9100 1000.0000 0.0010 -1000.0000 4.6600 -1000.0000 0.0010 -300.0000 47.5900 -300.0000 0.0010 481316.9169 1.0000 -84851.0165 0.6833 481303.73051.0000 -84849.4281 0.6833 481290.5445 1.0000 -84847.8397 0.6833 481277.3588 1.0000 -84846.2513 0.6833 481264.1735 1.0000 -84844.66306.6833 -200.0000 76.0200 -200.0000 0.0010 400.0000 115.2000 400.0000 0.0010 100.0000 222.3200 100.0000 0.0010 481250.98851.0000 -31652.5544 0.6833 481237.80391.0000 -31651.9619 0.6833 type Stock Stock Other Other Stock Stock Stock Stock Stock Stock Stock Stock Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other subtype net currency 3830.0000 AUD Commission -3.8300 AUD Interest 13.5986 AUD Interest -0.0490 USD 45896.0000 USD Commission -45.8960 USD 22132.0000 USD Commission -22.1320 USD 1608.5000 USD Commission - 1.6085 USD 12680.2500 USD Commission -12.6803 USD Interest 13.5982 AUD Interest -1.5885 USD -3910.0000 AUD Commission -3.9100 AUD 4660.0000 AUD Commission -4.6600 AUD 14277.0000 AUD Commission -14.2770 AUD Interest 13.1868 AUD Interest -1.5885 USD Interest 13.1864 AUD Interest -1.5884 USD Interest 13.1860 AUD Interest -1.5884 USD Interest 13.1857 AUD Interest -1.5884 USD Interest 13.1853 AUD Interest -1.5883 USD 15204.0000 USD Commission -15.2040 USD - 46080.0000 USD Commission - 46.0800 USD -22232.0000 USD Commission -22.2320 USD Interest 13.1850 AUD Interest -0.5926 USD Interest 13.1846 AUD Interest -0.5925 USD country timestamp Australia 2022-05-06 12:26:17 AM Australia 2022-05-06 12:26:17 AM AU 2022-05-05 11:00:01 PM US 2022-05-05 11:00:01 PM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM United State 2022-05-05 9:30:15 AM AU 2022-05-04 11:00:03 PM US 2022-05-04 11:00:03 PM Australia 2022-05-04 10:23:09 PM Australia 2022-05-04 10:23:09 PM Australia 2022-05-04 10:08:40 PM Australia 2022-05-04 10:08:40 PM Australia 2022-05-04 10:07:25 PM Australia 2022-05-04 10:07:25 PM AU 2022-05-03 11:00:04 PM US 2022-05-03 11:00:04 PM AU 2022-05-02 11:00:03 PM US 2022-05-02 11:00:03 PM AU 2022-05-01 11:00:04 PM US 2022-05-01 11:00:04 PM AU 2022-04-30 11:00:01 PM US 2022-04-30 11:00:01 PM AU 2022-04-29 11:00:04 PM US 2022-04-29 11:00:04 PM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM United State 2022-04-29 9:30:05 AM AU 2022-04-28 11:00:02 PM US 2022-04-28 11:00:02 PM AU 2022-04-27 11:00:04 PM US 2022-04-27 11:00:04 PM Other Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other A D E F G H AU US AUD USD AUD USD AU US AUD AU US AU US 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 AU US AU US AU US AU US AU US AU US B 481224.61971.0000 -31651.3694 0.6833 481211.4358 1.0000 -31650.7769 0.6833 481198.2523'1.0000 -31650.1844 0.6833 481185.0691 1.0000 -31649.5919 0.6833 481171.88631.0000 -31648.99946.6833 481158.7039 1.0000 -31648.4069 0.6833 481145.52181.0000 -31647.8144 0.6833 481132.3401 1.0000 -31647.2219 0.6833 481119.1588 1.0000 -31646.62956.6833 481105.97781.0000 -31646.0371 0.6833 481092.79721.0000 -31645.4447 0.6833 481079.6169 1.0000 -31644.85236.6833 481066.4370 1.0000 -31644.2599 0.6833 481053.2575 1.0000 -31643.6675 0.6833 481040.0783 1.0000 -31643.07516.6833 481026.89951.0000 -31642.48276.6833 481013.7210 1.0000 -31641.8903 0.6833 481000.5429 1.0000 -31641.2980 0.6833 480987.3652 1.0000 -31640.7057 0.6833 480974.1878 1.0000 -31640.1134 0.6833 480961.0108 1.0000 Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest Interest 13.1842 -0.5925 13.1839 -0.5925 13.1835 -0.5925 13.1832 -0.5925 13.1828 -0.5925 13.1824 -0.5925 13.1821 -0.5925 13.1817 -0.5925 13.1813 -0.5924 13.1810 -0.5924 13.1806 -0.5924 13.1803 -0.5924 13.1799 -0.5924 13.1795 -0.5924 13.1792 -0.5924 13.1788 -0.5924 13.1785 -0.5924 13.1781 -0.5923 13.1777 -0.5923 13.1774 -0.5923 13.1770 USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AUD USD AU US AU US 2022-04-26 11:00:04 PM 2022-04-26 11:00:04 PM 2022-04-25 11:00:02 PM 2022-04-25 11:00:02 PM 2022-04-24 11:00:02 PM 2022-04-24 11:00:02 PM 2022-04-23 11:00:00 PM 2022-04-23 11:00:00 PM 2022-04-22 11:00:03 PM 2022-04-22 11:00:03 PM 2022-04-21 11:00:02 PM 2022-04-21 11:00:02 PM 2022-04-20 11:00:01 PM 2022-04-20 11:00:01 PM 2022-04-19 11:00:01 PM 2022-04-19 11:00:01 PM 2022-04-18 11:00:04 PM 2022-04-18 11:00:04 PM 2022-04-17 11:00:04 PM 2022-04-17 11:00:04 PM 2022-04-16 11:00:00 PM 2022-04-16 11:00:00 PM 2022-04-15 11:00:00 PM 2022-04-15 11:00:00 PM 2022-04-14 11:00:01 PM 2022-04-14 11:00:01 PM 2022-04-13 11:00:03 PM 2022-04-13 11:00:03 PM 2022-04-12 11:00:04 PM 2022-04-12 11:00:04 PM 2022-04-11 11:00:02 PM 2022-04-11 11:00:02 PM 2022-04-10 11:00:01 PM 2022-04-10 11:00:01 PM 2022-04-09 11:00:01 PM 2022-04-09 11:00:01 PM 2022-04-08 11:00:00 PM 2022-04-08 11:00:00 PM 2022-04-07 11:00:04 PM 2022-04-07 11:00:04 PM 2022-04-06 11:00:04 PM 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 AU US AU US AU US AU US AU US AU AUD USD AUD USD AUD US AU US AU US 82 AU J23 x fx A H I J 82 83 84 85 86 87 88 89 90 91 92 USD USD USD 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 B C 480961.0108 1.0000 -31639.5211 0.6833 480947.83411.0000 -31638.9288 0.6833 480934.65781.0000 -31638.3365 0.6833 480921.48191.0000 -31637.7442 0.6833 480908.30631.0000 -31637.1519 6.6833 480895.13111.0000 -31636.5596 0.6833 480881.95631.0000 -31635.9674 0.6833 480868.7818 1.0000 -31635.3752 6.6833 480855.6077 1.0000 -31634.78306.6833 480842.4339 1.0000 -31634.1908 6.6833 480829.26051.0000 -31633.5986 0.6833 480816.0875 1.0000 -31633.0064 0.6833 480802.9148 1.0000 -31632.4142 0.6833 480789.7425 1.0000 -31631.82200.6833 220.0000 86.8300 220.0000 300.0000 49.4300 300.0000 0.0010 1000.0000 4.5400 1000.0000 6.0010 500164.40841.0000 -12509.88526.6833 500150.70561.0000 -12509.6510 0.6833 500137.0032 1.0000 -12509.4168 0.6833 500123.3012 1.0000 D Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other E F G Interest 13.1770 AUD Interest -0.5923 USD Interest 13.1767 AUD Interest -0.5923 USD Interest 13.1763 AUD Interest -0.5923 USD Interest 13.1759 AUD Interest -0.5923 USD Interest 13.1756 AUD Interest -0.5923 Interest 13.1752 AUD Interest -0.5923 USD Interest 13.1748 AUD Interest -0.5922 Interest 13.1745 AUD Interest -0.5922 USD Interest 13.1741 AUD Interest -0.5922 Interest 13.1738 AUD Interest -0.5922 USD Interest 13.1734 AUD Interest -0.5922 USD Interest 13.1730 AUD Interest -0.5922 USD Interest 13.1727 AUD Interest -0.5922 USD Interest 13.1723 Interest -0.5922 USD -19102.6000 USD Commission 19.1026 USD -14829.0000 AUD Commission - 14.8290 AUD -4540.0000 AUD Commission -4.5400 AUD Interest 13.7031 Interest -0.2342 USD Interest 13.7028 AUD Interest -0.2342 USD Interest 13.7024 AUD Interest -0.2342 USD Interest 13.7020 AUD AU 2022-04-06 11:00:04 PM US 2022-04-06 11:00:04 PM AU 2022-04-05 11:00:00 PM US 2022-04-05 11:00:00 PM AU 2022-04-04 11:00:01 PM US 2022-04-04 11:00:01 PM AU 2022-04-03 11:00:04 PM US 2022-04-03 11:00:04 PM AU 2022-04-02 11:00:01 PM US 2022-04-02 11:00:01 PM AU 2022-04-01 11:00:01 PM US 2022-04-01 11:00:01 PM AU 2022-03-31 11:00:00 PM US 2022-03-31 11:00:00 PM AU 2022-03-30 11:00:03 PM US 2022-03-30 11:00:03 PM AU 2022-03-29 11:00:02 PM US 2022-03-29 11:00:02 PM AU 2022-03-28 11:00:03 PM US 2022-03-28 11:00:03 PM AU 2022-03-27 11:00:04 PM US 2022-03-27 11:00:04 PM AU 2022-03-26 11:00:00 PM US 2022-03-26 11:00:00 PM AU 2022-03-25 11:00:00 PM US 2022-03-25 11:00:00 PM AU 2022-03-24 11:00:00 PM US 2022-03-24 11:00:00 PM United State 2022-03-24 9:30:06 AM United State 2022-03-24 9:30:06 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:06:47 AM Australia 2022-03-24 12:06:47 AM AU 2022-03-23 11:00:03 PM US 2022-03-23 11:00:03 PM AU 2022-03-22 11:00:03 PM US 2022-03-22 11:00:03 PM AU 2022-03-21 11:00:00 PM US 2022-03-21 11:00:00 PM AU 2022-03-20 11:00:01 PM 108 AUD 109 0.0010 110 SBUX-US 111 SBUX-US 112 BHP-ASX 113 BHP-ASX 114 MTS-AU 115 MTS-AU 116 AUD 117 118 119 120 121 122 D 109 110 SBUX-US 111 SBUX-US 112 BHP-ASX 113 BHP-ASX 114 MTS-AU 115 MTS-AU 116 117 118 119 120 121 122 123 124 B -31631.8220 0.6833 220.0000 86.8300 220.0000 0.0010 300.0000 49.4300 300.0000 0.0010 1000.0000 4.5400 1000.0000 0.0010 500164.4084 1.0000 -12509.88526.6833 500150.70561.0000 -12509.65100.6833 500137.0032 1.0000 -12509.4168 0.6833 500123.30121.0000 12509.1826 0.6833 500109.59961.0000 -12508.9484 0.6833 500095.8983 1.0000 12508.7142 0.6833 500082.1974 1.0000 -12508.4800 0.6833 500068.49691.0000 12508.2458 0.6833 25.0000 499.8300 25.0000 0.0010 500054.7968 1.0000 500041.09701.0000 500027.39761.0000 500013.6986 1.0000 500000.0000 1.0000 Other Stock Stock Stock Stock Stock Stock Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Stock Stock Other Other Other Other Other E F G Interest -0.5922 USD -19102.6000 USD Commission -19.1026 USD -14829.0000 AUD Commission -14.8290 AUD -4540.0000 AUD Commission - 4.5400 AUD Interest 13.7031 AUD Interest -0.2342 USD Interest 13.7028 AUD Interest -0.2342 USD Interest 13.7024 AUD Interest -0.2342 USD Interest 13.7020 AUD Interest -0.2342 USD Interest 13.7016 AUD Interest -0.2342 USD Interest 13.7013 AUD Interest -0.2342 USD Interest 13.7009 AUD Interest -0.2342 USD Interest 13.7005 AUD Interest -0.2342 USD -12495.7500 USD Commission -12.4958 USD Interest 13.7001 AUD Interest 13.6998 AUD Interest 13.6994 AUD Interest 13.6990 AUD Interest 13.6986 AUD H US 2022-03-24 11:00:00 PM United State 2022-03-24 9:30:06 AM United State 2022-03-24 9:30:06 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:41:14 AM Australia 2022-03-24 12:06:47 AM Australia 2022-03-24 12:06:47 AM AU 2022-03-23 11:00:03 PM US 2022-03-23 11:00:03 PM AU 2022-03-22 11:00:03 PM US 2022-03-22 11:00:03 PM AU 2022-03-21 11:00:00 PM US 2022-03-21 11:00:00 PM AU 2022-03-20 11:00:01 PM US 2022-03-20 11:00:01 PM AU 2022-03-19 11:00:04 PM US 2022-03-19 11:00:04 PM AU 2022-03-18 11:00:03 PM US 2022-03-18 11:00:03 PM AU 2022-03-17 11:00:00 PM US 2022-03-17 11:00:00 PM AU 2022-03-16 11:00:02 PM US 2022-03-16 11:00:02 PM United State 2022-03-16 9:30:25 AM United State 2022-03-16 9:30:25 AM AU 2022-03-15 11:00:03 PM AU 2022-03-14 11:00:04 PM AU 2022-03-13 11:00:04 PM 2022-03-12 11:00:04 PM 2022-03-11 11:00:00 PM 125 126 127 128 129 130 131 132 UNH-US 133 UNH-US 134 135 136 137 138 22 22 25 139 140 141 142 143 144 145
Answer & Explanation
Solved by verified expert
