Financial Modelling - Assigment
Financial Modelling - Assigment
Food
Start Date 1/1/2014
End Date 1/1/2019
VARCOVAR Σ = XTX/(n-1)
VARCOVAR AMD TSLA
AMD 0.03088342823917 0.00058062852684
TSLA 0.00058062852684 0.01371334735513
AAPL 0.00330269369074 0.00105633473995
MSFT 0.00323368611877 0.00070147311904
TTWO 0.00263713241327 0.00104359551552
MA 0.00362747581727 0.00073412305041
PM 0.00167348355163 0.00120577883522
MCD 0.0008012054827 0.00043777439862
MCD
1.154% Expected Return Ortlaama aylık getiri
4.081%
0.00166543304146 Risk
28.2894094%
MCD
0.0008012054827
0.00043777439862 Variance
0.00034393001899 Covariance
0.00094376787377 Covariance
0.00067999574423
0.00032935284111
0.00078625890416
0.00166543304146
CORREL (∑/(σTσ))1/2
MCD (Squareroot) AMD TSLA AAPL
0.111717 AMD 1 0.1679700841 0.5113673156
0.091604 TSLA 0.1679700841 1 0.3542787519
0.117265 AAPL 0.5113673156 0.3542787519 1
0.384292 MSFT 0.5529650244 0.3155002842 0.6319939227
0.197006 TTWO 0.4212140346 0.3245999687 0.7176737585
0.158044 MA 0.6357858889 0.3503793952 0.7122399624
0.295722 PM 0.3823142234 0.3975475364 0.5497732052
1 MCD 0.3342402798 0.3026617346 0.3424391745
MCD Total
0.00% 100.00%
MCD Total
56.24% 100.00%
MCD Total
35.40% 100.00%
MCD Total
12.50% 100.00%
MCD Total
0.90621863280855 3.42783915
26.44% 100.00%
MSFT TTWO MA PM MCD
0.5529650244 0.4212140346 0.6357858889 0.3823142234 0.3342402798
0.3155002842 0.3245999687 0.3503793952 0.3975475364 0.3026617346
0.6319939227 0.7176737585 0.7122399624 0.5497732052 0.3424391745
1 0.5504603532 0.7562159395 0.5899304441 0.6199132343
0.5504603532 1 0.609713048 0.3648964469 0.4438533927
0.7562159395 0.609713048 1 0.5584004777 0.3975473936
0.5899304441 0.3648964469 0.5584004777 1 0.5438036291
0.6199132343 0.4438533927 0.3975473936 0.5438036291 1
Maximum Return Minimize Standart Deviation Maximize Modified Sharpe - E(rp)/σp
σp 0.1757368152641 0.0334030118047516 0.0414279407424258
Expected Return 0.7569815948941 0.173802179947162 0.283364091554813
0.2
0.756981594894051
0.18
0.16 0.175736815264103
0.14
Standart Deviation (σp )
0.12
0.1
0.283364091554813
0.08
0.06 0.173802179947162
0.04
0.0334030118047516 0.0414279407424258
0.02
0
Maximum Return Minimize Standart Deviation Maximize Modified Sharpe
E(rp)/σp
σp Expected Return
Equally Weighted
0.0483547598099
0.2739856587366
0.8
0.7
0.6
0.5
Expected Return
0.4
0.283364091554813
0.3
0.273985658736643
7162
0.2
0.0483547598098738
0.0414279407424258 0.1
0
n Maximize Modified Sharpe - Equally Weighted
E(rp)/σp
Expected Return
Start Date 1/2/2019
End Date 12/20/2019
Monthly Returns
AMD TSLA AAPL MSFT TTWO MA PM MCD
-9.453% -3.147% -9.961% -3.679% -4.673% -4.511% -1.293% -0.659%
11.437% 5.770% 4.269% 4.651% 2.572% 4.736% 4.681% 1.933%
8.263% 5.436% -0.223% 0.128% 2.665% 0.769% -3.063% 1.088%
0.875% 0.116% 1.906% 0.725% 3.362% 0.554% 0.667% 0.211%
-2.699% 0.948% 1.698% 1.430% -0.426% 1.815% 0.059% -0.172%
-2.229% 1.903% 0.320% -0.643% 2.364% 0.603% 0.353% 0.699%
2.685% 0.664% -0.982% -0.772% -0.882% -0.533% 1.981% 0.452%
-0.197% -3.703% -1.504% -0.730% -3.715% -0.240% 0.173% -0.631%
0.741% 3.000% 2.047% 2.901% 1.438% 0.558% 1.264% -0.110%
-3.189% 0.470% 1.222% 0.352% -0.526% 0.636% 0.355% -0.923%
2.636% 0.364% 0.594% 0.702% -0.529% 0.779% 2.502% 0.981%
2.568% -12.971% 0.616% 1.498% 2.743% 1.350% 1.751% 0.806%
-4.863% -1.105% -2.245% -1.885% -0.859% -1.257% -1.328% 1.095%
0.202% -3.790% 0.404% 0.975% -7.006% -0.557% 1.634% 0.824%
5.303% 1.363% -0.793% -0.478% 1.683% 0.726% -3.311% 0.688%
5.180% 1.897% 3.314% 0.913% 2.178% 1.577% 1.649% -1.799%
-7.980% -0.222% -0.925% -1.950% -1.263% -1.370% 2.227% -0.217%
-4.609% 0.364% -1.036% -2.037% -1.543% -0.460% 0.081% -0.779%
19.948% 3.802% 6.833% 3.342% 1.776% 2.399% 0.094% -0.220%
5.717% -0.567% 0.720% -1.833% 2.875% 3.485% 3.008% -1.645%
0.410% 1.690% 0.048% -1.580% -0.568% 1.250% -1.290% -1.152%
-1.550% 0.218% 2.840% 2.880% 1.286% 0.533% 0.423% 0.470%
-3.398% 2.704% 1.711% 1.400% 0.931% 0.442% -0.316% 0.011%
-0.215% -1.285% 0.034% -1.110% -13.757% -0.259% -0.396% -0.783%
-2.537% -3.061% -1.894% -0.717% 4.172% -0.618% 1.616% -0.511%
1.676% -0.556% -0.310% 0.380% 0.778% 1.220% 4.236% -0.302%
-0.390% 2.302% -0.575% -0.397% -3.809% 0.240% -1.163% -0.280%
-0.610% -0.329% 0.862% 1.558% -4.484% 0.834% 1.961% -0.166%
0.131% -1.167% -0.415% -0.075% 3.238% 0.745% 0.868% 0.103%
1.225% -1.428% 0.364% 0.084% 1.237% -0.331% 0.677% 0.988%
2.378% 1.353% -0.222% 1.235% 0.021% 1.046% 1.967% 2.331%
1.140% -0.727% 0.299% -0.046% -0.032% -0.684% -0.084% -0.400%
0.000% -1.008% 0.644% -0.943% -4.932% 0.236% 1.979% 0.692%
-0.125% -3.745% -0.564% 2.109% -1.218% -0.814% 0.635% 1.285%
1.839% 1.195% 1.117% 1.426% -0.594% 1.828% 1.835% 0.197%
1.437% 1.378% 0.728% 0.559% 0.253% 0.000% -0.631% -0.306%
-2.023% -0.305% 0.057% 0.690% 0.057% 0.304% -0.104% 0.329%
-3.015% 5.667% 0.310% -0.169% -3.103% 0.254% 0.879% 0.082%
0.213% 1.633% -0.984% -0.125% 3.108% 0.089% -0.378% 0.262%
0.637% -7.843% 1.051% 0.446% 1.215% 1.103% 0.656% 0.658%
-1.309% -3.199% 0.503% -0.240% -0.996% -0.422% -0.263% -2.410%
0.556% -3.091% -0.182% -0.499% -0.080% -0.031% -0.344% 0.421%
-4.638% -0.108% -0.575% 0.045% -0.195% -0.774% 0.046% 0.375%
-1.473% 0.127% -1.157% -1.217% 1.388% -0.918% -0.057% -0.830%
-0.317% 2.730% 0.238% 0.109% -1.550% -0.243% 0.552% -0.565%
4.316% 2.386% 3.464% 2.099% 3.171% 1.699% 2.047% 0.880%
2.308% -2.599% 1.124% 0.700% 0.056% 0.576% -0.493% 0.414%
-0.468% 1.976% 0.442% 0.775% 6.878% 0.687% 0.788% 0.126%
-2.395% 0.346% 1.112% 0.079% -3.749% 0.442% 0.324% 0.374%
2.060% -5.011% 1.301% 1.152% 1.212% 0.723% 1.181% 1.417%
-0.172% -2.157% 1.021% 1.432% 0.299% -0.337% -0.132% -0.745%
11.828% -0.749% -0.792% 0.068% 2.089% 0.269% -0.253% -0.457%
-1.154% 2.291% 0.874% -0.110% 0.282% -0.485% 0.265% 1.016%
8.521% 0.154% 3.683% 2.297% 3.175% 2.601% 1.289% 0.757%
-5.450% -3.463% -2.071% -2.637% -3.118% -2.166% -0.805% 0.236%
-1.517% -1.554% -1.209% 0.521% 0.010% -0.147% -3.181% -0.583%
-1.078% 2.822% -1.033% 0.212% 0.354% 1.246% 0.363% 0.948%
-3.114% 2.636% 0.899% -0.967% -1.951% -0.330% -1.761% 0.016%
0.683% 1.379% 0.133% 0.137% 2.117% 1.006% 0.287% 1.003%
1.836% 0.445% 0.652% 0.864% -2.197% 0.251% 1.272% 0.269%
3.292% 3.331% 0.679% 0.916% 1.399% 1.529% -0.215% -0.795%
1.480% -1.141% 1.454% 0.143% 2.059% 0.088% -0.215% -0.021%
8.486% 2.074% 0.685% 0.654% 0.256% -0.138% -2.500% 0.000%
0.241% -8.235% 0.174% -0.508% -4.300% -1.201% 0.303% 0.807%
-0.378% 2.682% 0.669% 0.444% 0.886% 0.241% -0.732% 0.442%
-1.553% -0.640% 1.574% 0.033% -0.254% -0.152% -0.152% -0.451%
-4.522% -0.326% -0.300% -0.542% -1.071% -0.152% 0.621% 0.121%
2.166% 1.377% 0.561% 0.763% 2.198% 0.487% -0.151% -0.452%
-0.144% -2.767% -0.832% 0.116% -0.063% -0.430% -0.233% -0.180%
0.216% -0.268% -0.040% 0.515% -1.218% 1.182% 0.304% 1.440%
-1.867% -0.493% 0.181% 0.083% -1.551% 0.134% 0.490% 0.130%
2.195% 2.620% 0.010% -0.231% -1.846% 0.393% 0.023% -0.078%
-1.575% -0.779% 1.947% 0.828% -1.320% 0.379% -0.847% -0.047%
0.691% 0.749% 0.359% 1.314% 1.114% -0.046% -1.158% 1.722%
1.806% -3.846% 0.329% 0.316% 1.300% 0.897% -0.237% -0.508%
-0.745% 0.438% 1.442% 1.357% 1.490% 0.181% 0.736% 0.691%
1.752% -1.986% -0.154% -0.343% 0.332% 0.739% -0.542% 1.214%
-2.811% -4.264% -0.908% 3.312% -0.748% 0.130% -1.018% 0.152%
0.795% -5.044% -0.477% 0.573% 3.606% 0.436% 1.400% -0.258%
-0.681% 2.692% 0.152% -0.092% 0.935% 0.182% 0.165% -0.152%
-0.217% -1.151% -1.926% 0.640% -0.329% 2.877% 1.955% 0.228%
-2.968% -1.961% 4.909% -2.083% 2.293% -2.159% -0.901% -1.721%
5.520% 4.312% -0.651% -1.306% 0.636% -0.627% -1.003% 0.227%
-0.247% 4.477% 1.243% 2.131% 1.946% 0.307% 0.919% 1.495%
-2.835% 0.122% -1.544% -0.582% 0.030% 0.278% -0.677% 0.699%
-2.772% -3.243% -2.696% -2.052% -1.741% -1.440% -0.811% -0.432%
1.613% -0.899% 0.020% -0.008% 1.932% 0.110% -0.734% -0.005%
0.443% -1.168% -1.074% -0.008% 0.304% -0.008% 0.143% -0.151%
2.756% -1.017% -1.764% 1.299% 1.234% 0.864% 0.727% 1.143%
-6.152% -5.223% -5.812% -2.973% -3.260% -2.445% -0.994% -0.480%
4.116% 2.335% 1.583% 1.119% 3.540% 1.889% 0.466% -0.512%
0.952% -0.155% 1.198% 1.034% 3.795% 1.305% 1.487% 0.535%
1.559% -1.561% -0.440% 2.309% 0.065% 1.714% 0.199% 0.462%
-1.821% -7.577% -0.568% -0.667% -0.828% -0.343% 1.520% -0.385%
-2.982% -2.687% -3.127% -1.445% -3.450% 0.372% -0.668% -0.115%
2.511% -0.136% 1.917% 0.539% 0.748% 0.738% -0.545% 0.427%
0.219% -6.023% -2.047% 0.607% 0.463% 0.603% -0.315% 0.060%
-3.831% 1.432% -1.707% -1.167% 0.144% -2.791% 0.877% -0.495%
0.303% -2.486% -0.384% 0.048% 0.613% 0.701% -1.855% -0.603%
9.796% -1.012% -0.413% -0.063% 1.447% 0.775% -3.651% -0.556%
-3.238% 0.614% -0.477% -0.967% 0.432% 0.051% -0.503% -0.331%
-0.214% -0.864% 0.519% 0.632% -0.009% 0.248% -1.898% 1.643%
-2.212% -1.626% -1.812% -1.630% 1.084% -1.062% -3.103% -0.487%
0.620% -3.343% -1.011% -3.105% -2.034% -3.670% 1.919% 0.257%
7.215% 8.174% 3.658% 2.770% 2.869% 2.856% -0.140% 0.428%
-0.237% 1.545% 1.614% 2.168% 2.349% 2.841% -1.592% 0.250%
7.864% 4.761% 1.468% 1.581% -0.789% 0.613% -0.065% 1.459%
1.854% -0.704% 2.662% 2.801% 0.886% 3.091% 1.256% 1.197%
2.530% 4.098% 1.278% 0.913% 0.116% 0.113% -1.548% -2.034%
-2.468% 1.982% 1.158% -0.377% -1.333% -0.917% 1.533% 0.974%
-0.710% -3.612% -0.318% -0.462% -1.433% 0.072% -1.190% 0.822%
-2.455% 2.222% -0.021% 0.631% 1.849% -1.004% 0.492% -0.215%
-3.281% 0.473% -0.726% 0.098% -0.325% -0.421% -0.503% 0.391%
-3.821% 4.703% 0.597% 0.302% -0.063% -0.346% 1.023% -0.721%
4.281% -0.129% 2.352% 1.739% 0.662% -0.150% -1.128% 0.343%
0.164% 0.752% -0.292% 0.392% 0.000% 0.410% -0.597% 0.020%
-1.607% -3.008% 0.804% 0.929% 0.468% 2.663% 0.691% 0.279%
-3.032% 1.020% -0.341% 0.015% 0.986% -0.870% 2.643% -0.419%
0.550% 0.803% -0.101% 0.591% 1.056% 0.314% -1.755% -0.166%
-1.367% -1.735% -1.516% -3.157% -0.896% -2.100% 1.272% 0.878%
3.673% -0.223% 2.163% 0.375% -1.117% 0.604% -1.827% -0.564%
2.741% 1.628% -0.030% 0.164% 1.649% -0.077% 0.698% 0.841%
-1.204% 0.278% -0.911% -0.142% 0.123% 1.314% 0.783% 0.674%
2.733% 1.660% 1.834% 1.284% 2.140% 0.847% -0.700% -0.655%
0.128% -1.153% 0.585% 0.663% 0.819% 1.424% 2.270% 1.590%
-0.160% 4.609% 0.829% 0.644% 0.992% 0.928% 1.103% 1.541%
0.994% -0.766% -0.088% -0.291% -0.711% -0.344% -0.633% -0.738%
1.714% -1.184% -2.061% -0.073% -2.115% -0.334% -0.637% 0.436%
3.464% -0.121% 0.610% -0.365% 0.296% 0.778% -0.214% -0.033%
1.931% 3.851% 0.989% 1.019% 1.799% 0.746% 1.057% 0.429%
-2.160% -0.134% -0.728% 0.399% -0.538% 1.068% 1.221% -0.146%
0.454% 2.716% 0.768% 0.361% -0.060% 0.438% 0.775% 0.141%
3.553% 3.435% 0.939% 0.000% 0.489% -0.061% -0.513% 0.573%
-1.570% -0.441% -0.346% -1.310% 0.359% -0.984% 0.135% -0.229%
-0.739% 0.982% -0.562% -0.591% 0.128% -0.484% -0.650% -0.005%
-1.786% -0.518% 1.136% 0.110% 0.085% 0.545% 8.217% 1.029%
-1.485% 1.830% -1.493% 0.147% -1.393% -0.426% 1.163% -0.945%
1.046% -0.968% 2.285% 1.325% 0.517% 1.092% -2.006% 0.528%
1.948% 1.756% 0.782% 0.621% 1.243% 0.129% -0.230% -0.321%
1.851% 1.810% -0.081% 1.027% 0.669% 0.459% -1.994% -0.714%
-1.290% -13.614% -0.791% -0.377% 0.294% -0.321% 0.717% 0.780%
1.040% -0.341% 0.348% 0.820% 2.122% 0.974% 0.409% 0.532%
-1.587% 3.390% 0.934% -0.219% 1.486% -0.223% 0.907% -0.278%
1.165% 2.753% -0.429% -0.482% -0.316% -1.165% -0.530% -1.228%
-10.097% -0.268% 2.040% -2.907% -0.552% -2.117% -3.117% -0.763%
-1.938% -3.212% -2.164% 1.314% -0.343% 0.694% -1.387% 0.252%
-1.407% 0.210% -2.116% -0.840% -0.336% -1.718% 2.086% 1.529%
-4.925% -2.569% -5.235% -3.426% -5.185% -4.680% -4.645% -1.879%
3.108% 1.064% 1.893% 1.876% 7.956% 3.052% 1.321% 1.725%
1.143% 1.157% 1.036% 0.438% 3.886% 1.749% 0.049% 1.285%
16.204% 2.090% 2.206% 2.669% 1.538% 3.242% 1.377% 0.544%
0.796% -1.380% -1.199% -0.850% -1.918% -1.111% 0.133% 1.440%
-5.148% -2.553% -0.254% -1.394% -0.970% -1.800% -0.254% -1.804%
-0.987% 2.615% 4.235% 2.069% -0.071% 1.678% 1.906% 1.183%
-5.824% -6.545% -2.977% -3.333% -1.027% -2.688% -0.739% -1.479%
-1.885% -1.812% -0.498% -0.224% -0.048% 1.774% 1.392% 0.827%
5.089% 1.994% 2.359% 1.833% 0.824% 0.908% 0.497% 0.092%
0.962% 3.132% 1.864% 1.675% 2.091% 1.352% 0.118% 0.142%
-2.414% -0.427% 0.005% -0.831% 1.209% -0.370% -2.364% -0.142%
3.190% -2.227% 1.084% 1.115% 2.115% 1.794% 0.060% 1.025%
0.631% 0.598% -0.085% -0.728% -1.356% -0.440% -0.120% -0.553%
-7.398% -4.839% -4.622% -3.186% -2.704% -3.163% -2.086% -2.201%
2.505% 1.703% 1.900% 1.544% 1.304% 1.670% -4.297% 1.048%
-0.264% -0.428% -1.128% 0.214% 0.268% 0.076% -7.758% -0.396%
1.921% 0.705% 0.671% -0.133% 0.290% 0.578% 3.654% 0.935%
2.177% 2.839% 1.693% 1.888% 0.899% 1.129% -2.153% 1.133%
0.000% 1.759% -0.129% -0.188% -0.325% -0.004% -0.866% -1.165%
-1.749% -0.266% -1.456% -1.320% -0.235% -0.448% 0.791% -0.385%
0.162% -1.924% 1.697% 1.169% 0.820% 2.138% 0.495% 0.631%
1.777% 4.033% 1.955% 1.758% -1.047% 2.090% -1.465% 0.453%
-2.984% -0.928% -0.009% -0.678% -0.449% -0.240% 1.418% 0.246%
-0.196% 1.908% 0.427% -1.136% 1.078% -2.752% 0.452% -1.259%
-0.885% 1.618% 1.181% -1.047% -2.852% -3.893% 1.637% -3.489%
-1.555% 4.908% 3.180% 0.029% -4.502% -0.874% 0.765% 0.248%
1.512% -0.498% -0.226% 1.029% 2.952% 2.389% -0.226% 0.928%
1.589% -0.273% -1.943% -0.145% -0.903% -0.029% -2.470% -1.103%
0.456% -0.975% 0.526% -0.721% 2.822% -0.811% -0.616% -1.149%
0.519% 0.815% 0.364% 0.778% 1.773% 0.792% -0.799% 1.181%
-1.839% -0.531% 0.938% 0.822% -0.878% -0.416% -0.639% 0.276%
-0.427% 1.277% -0.812% 1.841% 0.640% 0.294% 0.210% 0.043%
-0.792% -2.425% -1.462% -1.155% -0.023% -1.718% -0.711% -0.537%
1.963% 0.253% 0.455% -0.215% -3.699% 0.730% 1.124% 1.027%
-3.655% -7.470% -0.475% -1.265% -0.517% -0.743% -0.611% 0.227%
0.068% 2.460% 1.539% 1.441% 1.727% 0.601% 5.198% 0.288%
-0.237% 6.060% -0.516% 0.129% -0.369% 0.418% 0.013% -0.014%
-2.545% -0.177% -0.487% -1.297% -2.209% -1.738% -0.213% 0.263%
0.940% -0.520% 2.354% 0.944% 1.105% 0.907% 1.065% 0.727%
-0.793% 1.586% 0.277% -1.410% -1.939% -0.232% 2.502% -2.650%
-1.565% -0.638% -2.507% -1.766% -2.644% -2.384% -1.426% -1.316%
1.307% -4.154% 0.849% 1.211% 0.702% 1.441% 0.065% 1.823%
1.151% -0.687% 2.803% 1.350% 2.349% 2.151% 1.967% 0.790%
-0.276% 2.718% 0.022% -0.724% -0.276% -0.682% -1.418% 0.109%
-2.420% 0.981% -1.171% -1.057% -2.878% -1.881% -1.037% -0.382%
0.815% 1.866% 1.172% 1.894% 2.026% 1.936% 1.414% 0.815%
-0.281% 0.086% 1.348% 0.622% 0.435% 0.584% 0.387% -0.503%
4.827% 1.287% 2.660% 0.417% 0.016% 0.760% 0.257% -1.294%
2.622% 3.659% -0.144% -0.093% -1.029% 0.170% 0.103% -0.306%
0.622% 0.362% -0.233% 1.451% 2.294% 0.789% 0.372% -0.557%
0.293% 0.721% -0.404% -0.823% -2.251% -0.104% 0.996% 0.521%
1.071% 0.855% 0.388% -0.513% 1.312% -0.632% 0.948% -0.696%
-0.546% -1.916% 0.480% -1.632% -0.008% -2.127% 0.877% 0.798%
3.423% -1.343% 1.734% 0.742% 0.301% 1.356% 1.552% 0.647%
-1.623% 0.821% -0.229% -1.488% -0.902% -4.754% -0.770% -5.042%
-0.476% -0.352% 1.342% 0.638% 0.566% -0.157% 0.752% -0.030%
1.148% 17.669% 0.164% 1.967% 1.353% 3.029% -0.404% -1.601%
3.121% 9.493% 1.232% 0.565% 0.796% 0.536% 0.651% -0.719%
2.996% -0.128% 1.002% 2.459% -2.035% 2.124% 0.134% -1.454%
-1.959% -3.506% -2.313% -0.943% -1.376% -0.594% -0.292% 0.438%
0.303% -0.382% -0.012% 1.246% 1.685% 1.043% -0.782% 2.217%
2.415% -0.029% 2.261% -0.857% -2.258% -0.123% 0.283% -0.097%
2.829% -0.512% 2.838% 0.244% -2.867% 0.809% 1.879% -1.403%
4.013% 1.328% 0.657% 0.578% 0.257% -0.975% 0.566% -2.722%
-0.386% -0.079% -0.144% -0.062% 0.043% -2.653% 0.911% 1.866%
-0.609% 2.951% 0.043% -0.277% -0.486% 0.320% -0.594% 1.041%
0.974% 2.743% 0.851% 0.139% 0.197% 1.086% -1.732% -0.566%
0.028% 0.477% 0.274% 1.178% 0.043% 0.770% 1.605% 0.274%
0.055% 2.358% 0.792% 0.103% 2.300% 0.768% 0.203% -0.501%
1.102% 1.402% -0.092% 0.657% -0.552% 0.051% 0.860% 0.332%
2.206% -1.091% 0.958% 0.163% 1.076% 0.336% 0.320% 0.890%
2.212% 0.936% -0.692% 0.509% 1.688% 0.561% -1.286% -0.513%
0.548% 0.807% 1.188% 1.290% 1.243% 0.411% 1.375% -0.015%
3.423% -0.619% 0.504% 0.247% -0.541% 0.028% 0.000% 0.160%
3.536% 2.723% -0.303% 0.033% 0.406% 1.584% -1.569% -0.432%
-0.751% -2.031% -1.164% -0.512% -0.202% 0.025% 0.024% 0.357%
-3.563% 0.741% -0.448% -0.094% -0.697% -0.326% -0.024% -0.917%
-0.936% -6.141% -0.088% 0.074% -2.497% -0.661% -1.294% 0.411%
1.635% 0.991% 1.753% 1.096% -0.100% 1.784% -0.012% -0.647%
-2.011% -2.206% -0.781% 0.529% 0.905% 0.615% -0.121% 1.105%
1.077% 0.721% 1.343% 0.191% 0.947% 0.802% 0.255% 1.180%
-0.660% -0.408% -0.220% -0.617% -0.189% 0.182% 0.546% -0.927%
-1.073% 1.494% -1.156% -1.209% -0.511% -1.971% -0.398% 0.360%
0.439% 0.397% -1.783% -0.160% 1.971% 0.216% 0.448% -1.055%
2.031% -0.943% 0.883% 0.362% -0.934% -0.087% -1.049% 0.616%
-0.176% -0.799% 1.467% 0.053% 1.648% 1.049% 0.341% -0.051%
0.025% 1.671% 1.932% 1.214% -0.194% 0.190% 1.056% 0.587%
-1.766% 1.084% -1.400% -0.257% -2.966% -0.461% 0.408% -0.343%
1.310% 2.742% 0.584% -0.152% 1.857% -0.156% 0.371% 0.139%
0.076% 1.106% 0.853% 0.377% 0.090% 0.499% 1.120% -0.118%
7.905% 1.979% 0.255% 1.015% 2.345% 0.745% -0.931% 0.817%
-3.381% -0.359% 1.359% 0.842% -2.754% 1.328% 0.738% 0.413%
2.916% 6.448% 1.712% 0.647% 0.731% 0.294% 1.866% 0.386%
0.992% -0.658% 0.197% -0.540% -0.114% -0.323% -0.348% -0.687%
-1.099% 3.736% -0.239% -0.207% -0.090% -0.426% -0.291% -0.453%
1.253% 2.770% 0.100% 0.868% -0.523% 0.947% 0.338% 0.731%
3.082% 0.384% -0.207% 1.092% 1.469% 0.350% -0.837% 0.041%
Y
AMD TSLA AAPL MSFT TTWO MA PM MCD
-9.858% -3.305% -10.208% -3.868% -4.766% -4.706% -1.401% -0.710%
11.032% 5.612% 4.022% 4.462% 2.479% 4.541% 4.572% 1.882%
7.858% 5.278% -0.470% -0.061% 2.571% 0.575% -3.171% 1.037%
0.470% -0.041% 1.659% 0.536% 3.268% 0.360% 0.559% 0.160%
-3.104% 0.791% 1.451% 1.241% -0.520% 1.621% -0.050% -0.222%
-2.634% 1.745% 0.072% -0.831% 2.270% 0.408% 0.245% 0.648%
2.280% 0.506% -1.229% -0.961% -0.975% -0.728% 1.872% 0.401%
-0.603% -3.861% -1.751% -0.918% -3.808% -0.434% 0.064% -0.681%
0.336% 2.842% 1.800% 2.712% 1.345% 0.363% 1.155% -0.161%
-3.595% 0.313% 0.975% 0.164% -0.619% 0.442% 0.246% -0.973%
2.230% 0.206% 0.347% 0.513% -0.622% 0.584% 2.393% 0.931%
2.163% -13.129% 0.369% 1.310% 2.649% 1.155% 1.643% 0.755%
-5.268% -1.263% -2.492% -2.073% -0.952% -1.452% -1.437% 1.045%
-0.203% -3.948% 0.157% 0.786% -7.100% -0.751% 1.526% 0.773%
4.898% 1.205% -1.040% -0.667% 1.590% 0.532% -3.419% 0.637%
4.775% 1.740% 3.067% 0.725% 2.084% 1.382% 1.541% -1.849%
-8.385% -0.380% -1.173% -2.139% -1.357% -1.564% 2.119% -0.268%
-5.014% 0.207% -1.284% -2.225% -1.636% -0.654% -0.028% -0.830%
19.543% 3.645% 6.586% 3.153% 1.682% 2.205% -0.014% -0.270%
5.312% -0.725% 0.473% -2.022% 2.782% 3.290% 2.899% -1.696%
0.004% 1.533% -0.199% -1.769% -0.662% 1.056% -1.399% -1.203%
-1.956% 0.060% 2.593% 2.691% 1.193% 0.339% 0.314% 0.419%
-3.803% 2.546% 1.464% 1.211% 0.838% 0.248% -0.424% -0.039%
-0.620% -1.443% -0.213% -1.299% -13.850% -0.454% -0.504% -0.834%
-2.942% -3.218% -2.141% -0.906% 4.078% -0.812% 1.507% -0.562%
1.271% -0.714% -0.557% 0.191% 0.685% 1.025% 4.127% -0.353%
-0.796% 2.144% -0.822% -0.586% -3.902% 0.046% -1.271% -0.331%
-1.015% -0.487% 0.615% 1.369% -4.578% 0.639% 1.852% -0.217%
-0.274% -1.325% -0.663% -0.264% 3.145% 0.550% 0.760% 0.053%
0.820% -1.586% 0.117% -0.105% 1.144% -0.525% 0.568% 0.937%
1.973% 1.195% -0.470% 1.046% -0.072% 0.852% 1.858% 2.281%
0.735% -0.885% 0.052% -0.235% -0.125% -0.879% -0.192% -0.451%
-0.405% -1.165% 0.396% -1.132% -5.025% 0.041% 1.870% 0.641%
-0.530% -3.903% -0.811% 1.920% -1.311% -1.009% 0.526% 1.235%
1.434% 1.037% 0.869% 1.237% -0.687% 1.634% 1.726% 0.146%
1.032% 1.220% 0.481% 0.370% 0.159% -0.194% -0.740% -0.356%
-2.429% -0.462% -0.190% 0.501% -0.036% 0.110% -0.212% 0.278%
-3.420% 5.510% 0.063% -0.358% -3.196% 0.060% 0.770% 0.031%
-0.192% 1.475% -1.231% -0.314% 3.014% -0.105% -0.487% 0.211%
0.232% -8.001% 0.804% 0.258% 1.121% 0.909% 0.547% 0.607%
-1.714% -3.357% 0.256% -0.429% -1.090% -0.617% -0.371% -2.461%
0.151% -3.249% -0.429% -0.688% -0.173% -0.225% -0.452% 0.370%
-5.044% -0.266% -0.823% -0.144% -0.288% -0.968% -0.063% 0.324%
-1.878% -0.031% -1.405% -1.406% 1.294% -1.112% -0.166% -0.880%
-0.722% 2.572% -0.009% -0.080% -1.643% -0.437% 0.443% -0.616%
3.911% 2.229% 3.217% 1.911% 3.078% 1.505% 1.938% 0.829%
1.903% -2.756% 0.876% 0.511% -0.038% 0.382% -0.602% 0.363%
-0.873% 1.818% 0.195% 0.586% 6.785% 0.493% 0.680% 0.076%
-2.800% 0.189% 0.865% -0.110% -3.842% 0.248% 0.215% 0.323%
1.654% -5.169% 1.054% 0.963% 1.118% 0.529% 1.072% 1.367%
-0.577% -2.314% 0.774% 1.243% 0.206% -0.532% -0.241% -0.795%
11.423% -0.907% -1.040% -0.121% 1.996% 0.075% -0.362% -0.507%
-1.559% 2.134% 0.627% -0.299% 0.189% -0.679% 0.157% 0.965%
8.116% -0.004% 3.436% 2.109% 3.082% 2.407% 1.181% 0.706%
-5.855% -3.621% -2.318% -2.826% -3.211% -2.361% -0.914% 0.185%
-1.922% -1.711% -1.456% 0.332% -0.083% -0.342% -3.289% -0.634%
-1.483% 2.665% -1.280% 0.024% 0.261% 1.051% 0.254% 0.897%
-3.519% 2.479% 0.652% -1.156% -2.044% -0.525% -1.869% -0.035%
0.278% 1.222% -0.115% -0.052% 2.023% 0.812% 0.179% 0.952%
1.430% 0.287% 0.405% 0.675% -2.290% 0.057% 1.163% 0.219%
2.886% 3.173% 0.432% 0.727% 1.305% 1.335% -0.323% -0.846%
1.074% -1.299% 1.207% -0.046% 1.965% -0.107% -0.324% -0.072%
8.081% 1.917% 0.438% 0.466% 0.163% -0.332% -2.608% -0.051%
-0.164% -8.393% -0.073% -0.697% -4.393% -1.396% 0.194% 0.756%
-0.783% 2.524% 0.422% 0.255% 0.792% 0.047% -0.840% 0.392%
-1.958% -0.798% 1.326% -0.155% -0.347% -0.347% -0.261% -0.502%
-4.927% -0.484% -0.547% -0.731% -1.165% -0.347% 0.513% 0.070%
1.761% 1.219% 0.314% 0.574% 2.104% 0.293% -0.260% -0.503%
-0.549% -2.925% -1.080% -0.072% -0.156% -0.625% -0.342% -0.230%
-0.189% -0.426% -0.287% 0.326% -1.311% 0.988% 0.196% 1.389%
-2.272% -0.651% -0.066% -0.106% -1.645% -0.060% 0.381% 0.080%
1.790% 2.463% -0.237% -0.420% -1.939% 0.199% -0.085% -0.129%
-1.981% -0.937% 1.700% 0.639% -1.413% 0.185% -0.955% -0.098%
0.286% 0.591% 0.112% 1.125% 1.021% -0.240% -1.267% 1.671%
1.401% -4.004% 0.082% 0.127% 1.207% 0.702% -0.345% -0.559%
-1.150% 0.280% 1.195% 1.169% 1.397% -0.013% 0.627% 0.640%
1.347% -2.144% -0.401% -0.532% 0.239% 0.545% -0.650% 1.163%
-3.216% -4.422% -1.155% 3.123% -0.841% -0.064% -1.127% 0.101%
0.390% -5.202% -0.725% 0.384% 3.513% 0.241% 1.291% -0.308%
-1.087% 2.534% -0.095% -0.281% 0.842% -0.012% 0.057% -0.203%
-0.622% -1.309% -2.173% 0.451% -0.423% 2.683% 1.847% 0.178%
-3.373% -2.118% 4.661% -2.271% 2.199% -2.354% -1.010% -1.772%
5.115% 4.154% -0.898% -1.495% 0.543% -0.822% -1.111% 0.176%
-0.653% 4.320% 0.996% 1.943% 1.853% 0.113% 0.810% 1.445%
-3.240% -0.036% -1.791% -0.771% -0.064% 0.084% -0.785% 0.648%
-3.177% -3.400% -2.943% -2.241% -1.835% -1.634% -0.919% -0.483%
1.208% -1.056% -0.227% -0.197% 1.839% -0.084% -0.843% -0.056%
0.038% -1.326% -1.322% -0.197% 0.211% -0.203% 0.035% -0.202%
2.351% -1.174% -2.011% 1.110% 1.140% 0.670% 0.618% 1.092%
-6.557% -5.381% -6.059% -3.162% -3.353% -2.640% -1.102% -0.531%
3.711% 2.178% 1.336% 0.930% 3.446% 1.695% 0.357% -0.563%
0.546% -0.313% 0.951% 0.845% 3.702% 1.111% 1.378% 0.485%
1.154% -1.719% -0.687% 2.120% -0.028% 1.519% 0.091% 0.411%
-2.226% -7.734% -0.815% -0.856% -0.921% -0.538% 1.412% -0.436%
-3.387% -2.844% -3.374% -1.633% -3.544% 0.178% -0.777% -0.166%
2.106% -0.293% 1.670% 0.350% 0.654% 0.543% -0.654% 0.376%
-0.186% -6.180% -2.294% 0.418% 0.369% 0.409% -0.423% 0.009%
-4.236% 1.274% -1.954% -1.356% 0.051% -2.985% 0.769% -0.546%
-0.102% -2.644% -0.631% -0.141% 0.520% 0.506% -1.964% -0.654%
9.391% -1.170% -0.661% -0.252% 1.354% 0.581% -3.759% -0.607%
-3.643% 0.457% -0.724% -1.156% 0.338% -0.143% -0.611% -0.381%
-0.619% -1.021% 0.272% 0.444% -0.103% 0.054% -2.006% 1.592%
-2.617% -1.783% -2.059% -1.819% 0.991% -1.257% -3.212% -0.538%
0.215% -3.501% -1.258% -3.294% -2.128% -3.865% 1.810% 0.206%
6.810% 8.017% 3.411% 2.582% 2.776% 2.662% -0.248% 0.377%
-0.642% 1.387% 1.367% 1.979% 2.255% 2.647% -1.701% 0.200%
7.459% 4.604% 1.221% 1.393% -0.882% 0.418% -0.173% 1.408%
1.449% -0.862% 2.415% 2.612% 0.792% 2.897% 1.148% 1.146%
2.125% 3.940% 1.031% 0.724% 0.023% -0.082% -1.656% -2.085%
-2.873% 1.824% 0.911% -0.566% -1.426% -1.111% 1.425% 0.923%
-1.115% -3.769% -0.565% -0.651% -1.526% -0.122% -1.299% 0.771%
-2.860% 2.065% -0.268% 0.442% 1.756% -1.199% 0.384% -0.265%
-3.687% 0.315% -0.973% -0.091% -0.418% -0.616% -0.611% 0.340%
-4.226% 4.546% 0.350% 0.113% -0.157% -0.540% 0.915% -0.772%
3.876% -0.286% 2.105% 1.550% 0.569% -0.345% -1.237% 0.293%
-0.241% 0.595% -0.539% 0.203% -0.093% 0.215% -0.705% -0.031%
-2.012% -3.165% 0.556% 0.740% 0.375% 2.468% 0.583% 0.228%
-3.438% 0.862% -0.588% -0.174% 0.893% -1.064% 2.535% -0.470%
0.145% 0.645% -0.348% 0.403% 0.963% 0.119% -1.863% -0.217%
-1.772% -1.893% -1.763% -3.346% -0.989% -2.294% 1.163% 0.827%
3.268% -0.380% 1.916% 0.186% -1.210% 0.410% -1.935% -0.615%
2.335% 1.471% -0.277% -0.025% 1.556% -0.271% 0.589% 0.790%
-1.609% 0.120% -1.158% -0.330% 0.030% 1.119% 0.674% 0.623%
2.328% 1.502% 1.587% 1.095% 2.047% 0.652% -0.809% -0.706%
-0.277% -1.311% 0.338% 0.475% 0.726% 1.230% 2.161% 1.539%
-0.565% 4.451% 0.582% 0.456% 0.899% 0.733% 0.995% 1.490%
0.589% -0.924% -0.335% -0.480% -0.805% -0.539% -0.741% -0.789%
1.309% -1.342% -2.309% -0.262% -2.209% -0.529% -0.745% 0.385%
3.059% -0.279% 0.363% -0.554% 0.203% 0.583% -0.322% -0.084%
1.525% 3.693% 0.742% 0.830% 1.705% 0.552% 0.949% 0.378%
-2.566% -0.291% -0.975% 0.210% -0.631% 0.873% 1.112% -0.196%
0.049% 2.558% 0.521% 0.172% -0.153% 0.244% 0.667% 0.090%
3.148% 3.278% 0.692% -0.189% 0.396% -0.255% -0.621% 0.522%
-1.975% -0.599% -0.593% -1.499% 0.266% -1.179% 0.026% -0.280%
-1.144% 0.825% -0.810% -0.780% 0.034% -0.679% -0.758% -0.055%
-2.191% -0.676% 0.889% -0.079% -0.008% 0.350% 8.109% 0.979%
-1.890% 1.672% -1.740% -0.042% -1.487% -0.621% 1.054% -0.996%
0.641% -1.126% 2.038% 1.136% 0.424% 0.898% -2.115% 0.478%
1.543% 1.598% 0.535% 0.432% 1.150% -0.065% -0.339% -0.372%
1.446% 1.653% -0.329% 0.838% 0.576% 0.264% -2.103% -0.765%
-1.695% -13.771% -1.038% -0.565% 0.201% -0.516% 0.609% 0.729%
0.634% -0.499% 0.101% 0.632% 2.028% 0.779% 0.300% 0.481%
-1.993% 3.232% 0.687% -0.408% 1.393% -0.418% 0.799% -0.329%
0.760% 2.595% -0.676% -0.671% -0.409% -1.360% -0.639% -1.279%
-10.503% -0.426% 1.793% -3.096% -0.645% -2.312% -3.226% -0.814%
-2.343% -3.370% -2.411% 1.125% -0.436% 0.500% -1.496% 0.201%
-1.812% 0.052% -2.363% -1.029% -0.429% -1.912% 1.978% 1.478%
-5.330% -2.726% -5.482% -3.615% -5.279% -4.874% -4.754% -1.930%
2.703% 0.907% 1.646% 1.687% 7.863% 2.858% 1.212% 1.674%
0.738% 0.999% 0.788% 0.249% 3.792% 1.555% -0.059% 1.234%
15.799% 1.933% 1.958% 2.480% 1.445% 3.047% 1.268% 0.493%
0.391% -1.538% -1.447% -1.038% -2.011% -1.306% 0.025% 1.390%
-5.553% -2.711% -0.501% -1.583% -1.063% -1.995% -0.363% -1.855%
-1.392% 2.458% 3.988% 1.881% -0.164% 1.483% 1.797% 1.133%
-6.229% -6.702% -3.224% -3.522% -1.121% -2.883% -0.847% -1.530%
-2.290% -1.970% -0.745% -0.413% -0.141% 1.580% 1.284% 0.776%
4.684% 1.836% 2.112% 1.644% 0.731% 0.714% 0.389% 0.041%
0.557% 2.975% 1.617% 1.486% 1.998% 1.158% 0.009% 0.091%
-2.819% -0.585% -0.242% -1.020% 1.116% -0.565% -2.473% -0.192%
2.785% -2.384% 0.837% 0.926% 2.022% 1.600% -0.048% 0.975%
0.226% 0.440% -0.332% -0.917% -1.449% -0.634% -0.229% -0.604%
-7.803% -4.997% -4.869% -3.375% -2.797% -3.357% -2.194% -2.251%
2.100% 1.545% 1.653% 1.356% 1.211% 1.475% -4.405% 0.997%
-0.669% -0.585% -1.376% 0.025% 0.175% -0.118% -7.866% -0.447%
1.515% 0.547% 0.424% -0.321% 0.197% 0.384% 3.546% 0.884%
1.772% 2.681% 1.446% 1.700% 0.806% 0.934% -2.261% 1.082%
-0.405% 1.601% -0.376% -0.377% -0.418% -0.198% -0.975% -1.216%
-2.154% -0.424% -1.704% -1.509% -0.328% -0.642% 0.682% -0.436%
-0.243% -2.082% 1.449% 0.980% 0.727% 1.944% 0.387% 0.580%
1.372% 3.875% 1.708% 1.570% -1.141% 1.896% -1.574% 0.402%
-3.389% -1.085% -0.257% -0.867% -0.543% -0.434% 1.309% 0.195%
-0.602% 1.750% 0.180% -1.325% 0.985% -2.947% 0.344% -1.310%
-1.290% 1.460% 0.934% -1.236% -2.946% -4.087% 1.529% -3.540%
-1.960% 4.750% 2.932% -0.159% -4.595% -1.068% 0.657% 0.197%
1.107% -0.655% -0.473% 0.840% 2.859% 2.195% -0.335% 0.877%
1.184% -0.430% -2.190% -0.334% -0.996% -0.223% -2.578% -1.154%
0.051% -1.132% 0.279% -0.910% 2.728% -1.005% -0.725% -1.199%
0.114% 0.658% 0.117% 0.589% 1.679% 0.597% -0.907% 1.131%
-2.245% -0.689% 0.691% 0.634% -0.972% -0.611% -0.747% 0.226%
-0.833% 1.119% -1.060% 1.652% 0.546% 0.100% 0.101% -0.008%
-1.198% -2.582% -1.709% -1.344% -0.116% -1.912% -0.820% -0.588%
1.558% 0.095% 0.208% -0.404% -3.793% 0.536% 1.015% 0.976%
-4.061% -7.628% -0.723% -1.454% -0.610% -0.938% -0.720% 0.176%
-0.337% 2.302% 1.292% 1.252% 1.634% 0.407% 5.090% 0.237%
-0.642% 5.903% -0.763% -0.060% -0.463% 0.224% -0.095% -0.065%
-2.950% -0.335% -0.734% -1.486% -2.302% -1.932% -0.321% 0.213%
0.535% -0.678% 2.106% 0.755% 1.012% 0.712% 0.956% 0.676%
-1.199% 1.429% 0.030% -1.599% -2.032% -0.426% 2.394% -2.701%
-1.970% -0.795% -2.754% -1.954% -2.738% -2.579% -1.535% -1.366%
0.902% -4.312% 0.602% 1.022% 0.609% 1.246% -0.043% 1.772%
0.745% -0.844% 2.556% 1.161% 2.255% 1.956% 1.858% 0.740%
-0.681% 2.560% -0.225% -0.913% -0.369% -0.877% -1.527% 0.058%
-2.825% 0.823% -1.419% -1.246% -2.972% -2.075% -1.145% -0.433%
0.410% 1.708% 0.925% 1.706% 1.933% 1.741% 1.306% 0.764%
-0.686% -0.072% 1.101% 0.433% 0.342% 0.390% 0.279% -0.554%
4.422% 1.129% 2.413% 0.228% -0.077% 0.565% 0.149% -1.345%
2.217% 3.501% -0.391% -0.282% -1.123% -0.024% -0.006% -0.357%
0.217% 0.204% -0.480% 1.262% 2.201% 0.594% 0.263% -0.607%
-0.112% 0.564% -0.651% -1.012% -2.344% -0.299% 0.887% 0.470%
0.666% 0.697% 0.141% -0.702% 1.219% -0.827% 0.840% -0.747%
-0.951% -2.074% 0.233% -1.821% -0.101% -2.321% 0.768% 0.747%
3.017% -1.500% 1.487% 0.554% 0.208% 1.162% 1.443% 0.597%
-2.029% 0.663% -0.476% -1.677% -0.995% -4.948% -0.879% -5.092%
-0.881% -0.510% 1.095% 0.449% 0.472% -0.351% 0.643% -0.081%
0.743% 17.512% -0.083% 1.779% 1.260% 2.834% -0.512% -1.652%
2.716% 9.336% 0.984% 0.376% 0.703% 0.341% 0.542% -0.770%
2.591% -0.286% 0.755% 2.270% -2.128% 1.930% 0.026% -1.505%
-2.364% -3.664% -2.560% -1.132% -1.470% -0.789% -0.401% 0.387%
-0.102% -0.540% -0.259% 1.057% 1.591% 0.848% -0.890% 2.166%
2.010% -0.186% 2.014% -1.046% -2.351% -0.317% 0.175% -0.147%
2.424% -0.669% 2.591% 0.055% -2.960% 0.615% 1.770% -1.454%
3.607% 1.170% 0.410% 0.389% 0.163% -1.169% 0.458% -2.773%
-0.791% -0.237% -0.391% -0.251% -0.051% -2.847% 0.802% 1.815%
-1.014% 2.793% -0.204% -0.466% -0.579% 0.125% -0.702% 0.990%
0.569% 2.586% 0.604% -0.050% 0.104% 0.891% -1.841% -0.617%
-0.378% 0.319% 0.027% 0.990% -0.051% 0.575% 1.496% 0.224%
-0.350% 2.200% 0.545% -0.086% 2.207% 0.573% 0.095% -0.552%
0.696% 1.245% -0.339% 0.468% -0.645% -0.144% 0.751% 0.281%
1.801% -1.249% 0.711% -0.026% 0.982% 0.141% 0.211% 0.839%
1.807% 0.778% -0.939% 0.320% 1.595% 0.367% -1.395% -0.564%
0.142% 0.650% 0.941% 1.101% 1.150% 0.217% 1.266% -0.066%
3.018% -0.777% 0.257% 0.058% -0.634% -0.166% -0.109% 0.109%
3.130% 2.566% -0.550% -0.156% 0.313% 1.390% -1.677% -0.483%
-1.156% -2.188% -1.411% -0.701% -0.296% -0.170% -0.085% 0.306%
-3.968% 0.583% -0.695% -0.282% -0.790% -0.520% -0.132% -0.968%
-1.341% -6.299% -0.335% -0.115% -2.590% -0.855% -1.403% 0.360%
1.230% 0.833% 1.506% 0.908% -0.194% 1.589% -0.121% -0.698%
-2.416% -2.363% -1.028% 0.340% 0.811% 0.421% -0.230% 1.054%
0.672% 0.563% 1.096% 0.002% 0.853% 0.607% 0.147% 1.130%
-1.065% -0.565% -0.467% -0.806% -0.283% -0.013% 0.437% -0.978%
-1.478% 1.336% -1.403% -1.398% -0.604% -2.166% -0.506% 0.309%
0.034% 0.240% -2.030% -0.349% 1.878% 0.022% 0.339% -1.106%
1.626% -1.100% 0.635% 0.173% -1.027% -0.282% -1.157% 0.565%
-0.582% -0.957% 1.220% -0.135% 1.555% 0.855% 0.233% -0.102%
-0.380% 1.513% 1.684% 1.025% -0.287% -0.005% 0.948% 0.536%
-2.172% 0.926% -1.647% -0.446% -3.059% -0.656% 0.300% -0.394%
0.905% 2.585% 0.337% -0.341% 1.764% -0.350% 0.262% 0.088%
-0.329% 0.949% 0.606% 0.188% -0.003% 0.304% 1.012% -0.169%
7.500% 1.821% 0.008% 0.826% 2.251% 0.550% -1.040% 0.766%
-3.786% -0.516% 1.112% 0.653% -2.847% 1.133% 0.629% 0.362%
2.511% 6.291% 1.465% 0.458% 0.637% 0.099% 1.758% 0.335%
0.587% -0.816% -0.051% -0.729% -0.207% -0.518% -0.456% -0.738%
-1.504% 3.579% -0.486% -0.396% -0.183% -0.620% -0.399% -0.504%
0.848% 2.612% -0.147% 0.679% -0.616% 0.752% 0.230% 0.680%
2.677% 0.226% -0.454% 0.903% 1.376% 0.155% -0.946% -0.010%
AMD TSLA AAPL MSFT
Expected Returns <== E(r) 0.405% 0.158% 0.247% 0.189%
n 245
Stddev <== σ 3.428% 3.101% 1.666% 1.268%
Variance <== σ2 0.001175130 0.000961451 0.0002775978 0.0001607218
Modified Sharpe <== E(r)/σ 11.8205355% 5.0839379% 14.8339883% 14.8923349%
0.000091678 0.001175130
VARCOVAR Σ = XTX/(n-1)
VARCOVAR AMD TSLA AAPL MSFT
AMD 0.0011751296 0.0002913055 0.0002827482 0.0002323708
TSLA 0.0002913055 0.0009614508 0.0001713588 0.0001124553
AAPL 0.0002827482 0.0001713588 0.0002775978 0.0001316935
MSFT 0.0002323708 0.0001124553 0.0001316935 0.0001607218
TTWO 0.0002526732 0.0001177303 0.0001151468 0.0001079512
MA 0.0002500675 0.0001063835 0.0001224578 0.0001280805
PM 3.360162E-05 1.601281E-05 6.617576E-05 3.831308E-05
MCD 5.212226E-05 -1.524359E-05 2.361449E-05 4.337176E-05
TTWO MA PM MCD
0.0002526732 0.0002500675 3.360162E-05 5.212226E-05
0.0001177303 0.0001063835 1.601281E-05 -1.524359E-05 Variance
0.0001151468 0.0001224578 6.617576E-05 2.361449E-05 Covariance
0.0001079512 0.0001280805 3.831308E-05 4.337176E-05 Covariance
0.0004505956 0.0001235985 2.691573E-05 3.723222E-05
0.0001235985 0.0001850582 4.557408E-05 4.925945E-05
2.691573E-05 4.557408E-05 0.000239883 2.774197E-05
3.723222E-05 4.925945E-05 2.774197E-05 9.167837E-05
TTWO MA PM MCD
0.347234 0.536241 0.063287 0.158799
0.178867 0.252207 0.033343 -0.051344
0.325574 0.540287 0.256443 0.148026
0.401141 0.742662 0.195124 0.357303
1 0.428021 0.081868 0.183186
0.428021 1 0.216304 0.378183
0.081868 0.216304 1 0.187070
0.183186 0.378183 0.187070 1
TTWO MA PM MCD
0.00% 0.00% 0.00% 0.00% 100.00%
TTWO MA PM MCD
3.46% 0.00% 16.57% 59.21% 100.00%
TTWO MA PM MCD
0.00% 23.41% 13.90% 0.00% 100.00%
TTWO MA PM MCD
12.50% 12.50% 12.50% 12.50% 100.00%
TTWO MA PM MCD
0.6736325346 0.9638728668 0.9838702833 0.5752792039 5.112735
13.18% 18.85% 19.24% 11.25% 100.00%
Expected Return
PM MCD Total
165.7459 592.114 1000
2.462425 3.363137 10.84387
209.971 663.0089 1235.438
Profit : 235.4377
ROI: 23.54%
PM MCD Total
138.9781 0 1000
2.064746 0 16.77712
176.0609 0 1632.87
Profit : 632.8703
ROI: 63.29%
PM MCD Total
125 125 1000
1.857079 0.709985 21.51442
158.3531 139.9665 1515.907
Profit : 515.9068
ROI: 51.59%
PM MCD Total
192.4352 112.5189 1000
2.858939 0.639094 19.69446
243.7818 125.991 1498.021
Profit : 498.0213
ROI: 49.80%
X
AMD TSLA AAPL MSFT TTWO MA PM MCD
3.355% 33.418% 3.449% -0.638% -0.148% 0.844% 3.359% -0.114%
3.278% -16.383% 0.323% 5.116% 7.702% -5.737% 1.001% 1.872%
-2.814% -1.799% 8.267% -3.319% -10.292% -3.391% 4.163% 2.263% AMD
-7.009% -1.588% 5.599% -0.543% -1.997% 2.092% 3.455% -1.105% TSLA
-0.059% 14.010% 1.094% -0.023% 4.580% -5.749% -4.963% -1.835% AAPL
-11.491% -8.512% 1.200% 1.621% -2.594% -0.926% -2.914% -7.289% MSFT
1.841% 19.249% 5.545% 3.380% 1.825% 0.387% 4.167% -2.043% TTWO
-23.034% -11.549% -3.380% 0.167% -5.095% -4.344% -2.733% 0.009% MA
-22.697% -1.934% 5.523% -0.607% 11.427% 11.447% 6.541% -2.294% PM
-5.166% -0.364% 8.448% -0.048% 1.351% 2.375% -2.523% 2.132% MCD
-9.110% -10.573% -8.862% -4.724% -1.886% -3.146% -6.490% -4.367%
-8.554% -9.988% 4.470% -14.905% 2.805% -6.645% -1.671% -2.499%
16.203% -1.658% 7.972% 6.660% -14.092% 8.023% 3.204% 5.834%
-18.635% -8.697% -4.810% -9.166% -7.131% -6.001% -9.383% -2.631%
-20.480% 18.218% -1.094% 17.761% -10.118% 2.570% 10.620% -2.068%
-3.924% 9.418% 2.426% -5.539% 12.261% 0.421% -0.665% -1.797%
0.454% 5.431% -5.399% -7.663% -2.493% -0.529% -3.677% -2.051%
-24.392% -2.317% -4.962% 3.896% 11.321% 2.342% 6.500% 3.884%
-11.026% -7.952% -8.713% -8.689% -10.982% -7.016% -6.885% -6.001%
-9.781% -1.796% -3.854% -0.180% -4.597% -4.287% -0.775% 2.539%
18.447% -18.225% 6.668% 17.054% 12.335% 7.991% 11.247% 12.770%
6.512% 9.744% -2.677% 1.369% 3.312% -2.932% -1.328% 0.547%
16.801% 2.704% -12.695% 0.199% -4.722% -2.423% 0.409% 2.332%
-28.154% -21.868% -9.197% -2.583% -3.626% -10.407% 2.203% 3.620%
-7.536% -1.149% -2.340% -9.522% 0.494% -4.221% 0.947% -6.478%
28.369% 18.185% 11.048% 6.670% 1.444% 6.869% 7.592% 6.090%
19.753% 3.253% -15.665% -11.585% -12.488% 0.784% -0.176% -0.510%
23.924% -8.811% 4.856% 4.396% 10.615% -2.975% 0.385% -4.657%
7.664% -6.436% -5.939% -5.333% -5.768% -10.027% 2.895% -2.564%
28.654% 9.073% 7.334% 8.888% 2.736% 6.302% -1.621% -3.390%
3.063% -11.233% 0.141% -0.504% 4.964% -0.392% -0.515% -2.846%
-11.430% -5.295% 4.878% -1.636% 0.480% 3.468% -2.898% -1.414%
-0.178% -4.618% -1.239% 2.148% -4.754% 3.307% -0.988% -3.573%
18.428% -5.744% -4.332% -1.312% 7.680% -6.355% -8.647% 4.797%
22.464% 11.295% 3.123% 1.240% -3.102% -0.824% 3.450% 0.900%
-13.362% 16.364% 3.102% 2.159% 5.622% 1.132% 4.886% -0.456%
34.632% -2.301% 11.216% -2.916% 2.983% 2.033% 13.566% 2.990%
-4.186% 9.794% 3.196% 1.059% 0.795% -0.032% 3.061% 0.381%
-13.400% 11.323% -1.680% 2.068% 2.816% 1.572% -2.010% 6.808%
-20.673% 7.047% 4.669% 0.136% 18.876% 3.788% 7.898% 6.678%
6.719% 4.510% -7.394% -3.183% -7.602% -3.015% -2.147% 0.350%
4.246% -12.078% 1.598% 3.589% 5.089% 3.377% -0.816% 0.138%
-9.291% 8.495% 8.594% 0.967% 19.813% 2.452% 0.003% 1.959%
-6.732% -5.689% -7.697% -2.254% 1.317% 4.075% -5.249% -3.211%
-18.652% -4.336% 8.008% 9.786% 5.013% 3.510% -5.924% 5.375%
-5.673% -8.372% -0.010% -0.690% -2.410% -0.709% -1.992% 1.877%
-10.410% -0.721% -3.197% -0.252% -4.811% -1.260% 2.637% -1.067%
28.849% 12.267% -2.736% 9.191% 12.162% 9.803% 1.310% -1.724%
-16.672% -4.706% 4.712% -3.185% -14.908% 2.149% -3.618% -8.984%
-21.819% -23.955% -7.478% -4.546% -15.819% -2.193% -4.194% -2.017%
3.450% 8.904% -3.175% 0.585% -1.250% -0.076% -17.691% 5.918%
21.386% -4.651% 11.404% 3.809% 9.182% 4.796% -3.186% -5.592%
4.368% 18.917% -2.614% -2.113% 2.379% 1.515% 1.323% -3.229%
17.473% -14.597% 1.126% 5.695% -7.735% -1.098% 6.700% -0.612%
32.507% -0.350% 17.950% 4.012% 14.950% 7.017% -9.931% 1.823%
17.917% -13.760% -2.503% -0.064% 0.093% 1.419% 4.500% 1.965%
-45.858% 25.870% -4.720% -8.490% -9.833% -13.055% 7.823% 4.590%
12.160% 2.371% -20.077% 1.940% -18.123% -0.131% -1.934% 5.409%
-18.142% -6.575% -13.342% -10.285% -9.360% -8.028% -23.033% -6.958%
27.423% -9.277% 3.843% 0.936% -0.688% 10.065% 14.733% -0.473%
AMD TSLA AAPL MSFT TTWO MA PM MCD
1 0.028214 0.261497 0.305770 0.177421 0.404224 0.146164 0.111717
0.028214 1 0.125513 0.099540 0.105365 0.122766 0.158044 0.091604
0.261497 0.125513 1 0.399416 0.515056 0.507286 0.302251 0.117265
0.305770 0.099540 0.399416 1 0.303007 0.571863 0.348018 0.384292
0.177421 0.105365 0.515056 0.303007 1 0.371750 0.133149 0.197006
0.404224 0.122766 0.507286 0.571863 0.371750 1 0.311811 0.158044
0.146164 0.158044 0.302251 0.348018 0.133149 0.311811 1 0.295722
0.111717 0.091604 0.117265 0.384292 0.197006 0.158044 0.295722 1