Share Price Data Saved As
Share Price Data Saved As
Share Price Data Saved As
RF rate1 -3%
RF rate2 -5%
0.004823749 0.0017027712 0.0018359344 0.0018681967 0.0009653322 0.003258949 0.0018463306
0.001702771 0.0052402179 0.0024167873 0.0034731111 0.0015899238 0.0031376694 0.0009321404
0.001835934 0.0024167873 0.0033328546 0.0030610104 0.0012860993 0.0023443179 0.0018759719
0.001868197 0.0034731111 0.0030610104 0.008504204 0.00213455 0.0039692168 0.000848155
0.000965332 0.0015899238 0.0012860993 0.00213455 0.0064631193 0.0039262852 -0.000129846
0.003258949 0.0031376694 0.0023443179 0.0039692168 0.0039262852 0.0168036996 0.0038422211
0.001846331 0.0009321404 0.0018759719 0.000848155 -0.000129846 0.0038422211 0.0067287402
0.001685579 0.0021428243 0.0019855008 0.0030228153 0.0010747519 0.0028503232 0.0016034424
0.002409461 0.0018997299 0.0027086747 0.0034685819 0.0005006721 0.0023616913 0.0016383048
0.001799296 0.0028618857 0.0029340855 0.0037140549 0.0010756911 0.001856981 0.0006435509
Weights Transpose
0.198763897 0.9938655299 -77.52% -7.09% 0.1882699912 -0.208703826 0.4746427021
0.160395597 0.5492707304 -38.22% -7.58% 0.2257373201 -0.150595528 0.3309965042
Efficient PF
A B
Rp 0.0275277324 0.85%
Varp 0.0054489528 0.28%
STD 0.0738170227 0.0524621394
CovPa,Pb 0.0036471601
corr 0.9417861771
0.04
0.02
0
0.00% 2.00%
-0.02
-0.04
Years
AGAL.N0000 AHPL.N0000 AHUN.N0000 AMSL.N0000
turn Matrix
0.0775941775 0.0130556564 0.0130556564 -0.051482865 0.07759418 0.0130556564 0.1561565
0.0280835366 0.021289864 0.1351085396 -0.036682645 0.00727517 -0.0682879847 0.049834783
0.0294744161 -0.058186772 0.0148674045 0.0501392245 -0.0537905 0.0018297718 0.147482937
-0.023412185 -0.086767973 0.0353815527 0.1861784004 -0.0213899 -0.061179409 0.165151033
0.1257242451 -0.0637584 0.0661364993 -0.07095489 0.01134873 -0.0500656455 0.100807973
0.4338334591 -0.30682677 0.2389861577 -0.091038981 0.00468562 -0.0157364504 0.185478488
0.138035273 -0.063519652 -0.012607156 0.0413310872 -0.0834161 0.05839121 0.061756328
0.0147314816 -0.031629239 0.05380622 0.0641983157 0.04332198 0.0110884904 0.068847325
-0.023296522 -0.079866874 -0.019968732 0.0522638832 -0.0735973 0.0023103067 0.153327014
-0.016518698 -0.054502814 0.0038505548 0.0635115161 -0.0559861 -0.0200435129 0.074634056
ce Matrix
0.0664679024 0.0606808356 0.0867405822 0.0647746512
0.0335570547 0.0771416738 0.0683902768 0.1030278868
0.0675349898 0.0714780299 0.0975122875 0.1056270765
0.0305335788 0.1088213495 0.1248689488 0.133705975
-0.004674443 0.0386910672 0.018024196 0.038724878
0.1383199596 0.1026116366 0.085020887 0.0668513175
0.2422346483 0.0577239272 0.0589789732 0.0231678329
0.0577239272 0.1152203273 0.0790771847 0.0841434704
0.0589789732 0.0790771847 0.1493714189 0.1070771361
0.0231678329 0.0841434704 0.1070771361 0.170870589
Weights of Efficient P2
R-CA z
4% 3.409531371
6% 11.67585533
3% -8.125233598
4% -1.610622025
3% 4.798501259
3% -3.201211167
4% 7.035997155
4% 5.291858327
2% -1.859056221
4% 3.841393062
21.25701349
Mean Wa Wb
0.0016855788 0.0024094606 0.0017992959 -0.0130557 0.1987638971 0.160395597
0.0021428243 0.0018997299 0.0028618857 0.01470374 0.9938655299 0.54927073
0.0019855008 0.0027086747 0.0029340855 -0.0189242 -0.7752373241 -0.382237778
0.0030228153 0.0034685819 0.0037140549 -0.0143281 -0.0709054683 -0.07576897
0.0010747519 0.0005006721 0.0010756911 -0.0156131 0.1882699912 0.22573732
0.0028503232 0.0023616913 0.001856981 -0.0177862 -0.2087038265 -0.150595528
0.0016034424 0.0016383048 0.0006435509 -0.0070979 0.4746427021 0.330996504
0.0032005646 0.0021965885 0.0023373186 -0.0110885 0.2310750241 0.248946463
0.0021965885 0.0041492061 0.0029743649 -0.0254936 -0.3288979532 -0.087456134
0.0023373186 0.0029743649 0.0047464053 -0.0114552 0.2971274276 0.180711795
4%
3%
2%
SML
1% Mark
0%
0 0.2 0.4 0.6 0.8 1 1.2
-1%
-2%
0.08
-3%
0.06 -4%
0
0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00%
-0.02
-0.04
0.0775941775 0.013056 -0.05148 0.077594 -0.12048 0.082049 -0.05594 0.013056 0.013056 0.013056
0.041385728 0.029748 -0.03225 -0.01914 -0.03718 -0.01017 -0.10956 0.029099 0.031816 0.016619
0.0464579012 -0.03181 0.00557 0.004341 0.018924 -0.02835 -0.02493 -0.01023 -0.02091 0.069355
0.0143281435 -0.00587 0.014328 -0.02734 0.076204 0.014328 -0.02649 0.05515 0.014328 0.014328
0.0100420816 -0.0966 -0.04959 0.141443 0.015613 -0.10955 0.080152 -0.04893 0.015613 -0.01142
0.0724073261 -0.01944 -0.07236 -0.03649 0.013794 0.037589 -0.04284 -0.02043 0.017786 0.013448
0.048770612 -0.03991 0.169617 -0.01125 -0.02107 -0.05681 -0.0721 0.101409 -0.05478 -0.0036
0.0212408618 0.021139 -0.07592 -0.045 0.065358 -0.02981 0.00538 0.018693 0.022388 0.005455
0.0279905223 -0.0283 -0.03136 -0.07709 -0.00268 0.028663 -0.02647 0.008687 0.05883 0.038523
0.0416081924 -0.00855 0.001303 0.001199 0.081135 0.067545 -0.00689 -0.01672 0.075994 -0.06265
s of Efficient P1
W
0.1987638971
0.9938655299
-0.775237324
-0.070905468
0.1882699912
-0.208703826
0.4746427021
0.2310750241
-0.328897953
0.2971274276
s of Efficient P2
W
0.1603955971
0.5492707304
-0.382237778
-0.07576897
0.2257373201
-0.150595528
0.3309965042
0.2489464632
-0.087456134
0.1807117949
1
SML
Stocks Cov(I,m) Beta R
0 0 -3%
-3.00% AAF.N0000 0.001605 0.294542 -0.01306
0.85% AAIC.N000 0.004234 0.777082 0.014704
2.75% ABAN.N00 0.001049 0.19253 -0.01892
6.35% AGST.N000 0.001484 0.272423 -0.01433
ARPI.N000 0.001363 0.250086 -0.01561
AFSL.N000 0.001157 0.212311 -0.01779
AGAL.N0000.002169 0.398105 -0.0071
AHPL.N0000.001791 0.328737 -0.01109
AHUN.N00 0.000427 0.078334 -0.02549
AMSL.N00 0.001757 0.322364 -0.01146
Pa,M 0.005449 1 0.027528
Pb 0.003647 0.669332 0.85%
SML
Market PF
1 1.2
Efficient Frontier
Individual Stocks
CML
14.00% 16.00%
0.013056 -0.06105 -0.154 0.013056 0.013056 -0.08225 0.013056 0.013056
-0.01912 0.0454 0.001826 -0.10023 0.095111 -0.00674 0.020388 0.154117
0.00596 0.03889 0.018924 -0.09162 -0.00739 -0.05007 0.033109 0.03291
0.014328 -0.00587 -0.0933 -0.13228 0.040304 0.039646 -0.20882 0.237472
-0.00515 0.119784 -0.00155 -0.02294 0.001524 0.142365 -0.03631 -0.03915
-0.059 0.098912 -0.13133 0.071589 -0.05121 -0.0133 -0.08757 0.194243
-0.05386 0.035269 -0.11069 -0.02465 0.038847 -0.21605 0.165703 0.059058
-0.04507 0.082204 -0.06402 -0.01526 -0.04595 -0.10642 -0.02121 0.084114
0.106283 -0.02032 -0.03572 0.015477 -0.03681 -0.08784 0.033462 0.094487
-0.00796 0.040443 -0.00778 -0.00815 0.021307 -0.0184 -0.02979 0.021926