ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
Risk Analysis of Securities
2
3
4
2014-20182019
5
SBI(2014-18)HDFC(2014-18)NIFTY(2014-2018)NIFTY(2019)SBI(2019)HDFC(2019)STANDARD DEVIATON
6
DatePRICERETURNPRICERETURNPRICERETURNDatePRICERETURNPRICERETURNPRICERETURNSBIHDFCPORT FOLIO
7
1/1/2014176.505005332.5750126221.1499021/1/201910792.5299.6000061065.045288DAILY2.1%1.1%SBI40%0.4
8
1/2/2014174.259995-1.27%328.5-1.23%6211.149902-0.16%1/2/201910672.25-1.1%293.899994-1.9%1055.327393-0.9%
ANNUALIZED
40.8%20.33%HDFC60%0.6
9
1/3/2014171.964996-1.32%331.5499880.93%6191.450195-0.32%1/3/201910727.349610.5%291.100006-1.0%1047.047363-0.8%20192.19%1.24%
10
1/6/2014168.815002-1.83%330.850006-0.21%6162.25-0.47%1/4/201910771.799810.4%297.6499942.3%1049.843750.3%
2014-2018
2019
11
1/7/2014166.139999-1.58%332.2000120.41%6174.6000980.20%1/7/201910802.150390.3%296.299988-0.5%1051.4302980.2%
AVERAGE RETURN
RETURN
31.2%28.8%
12
1/8/2014165.714996-0.26%332.3500060.05%6168.350098-0.10%1/8/201910855.150390.5%305.2999883.0%1042.684326-0.8%SBIHDFCNIFTY
SUMMARY OUTPUT
13
1/9/2014163.979996-1.05%331.475006-0.26%6171.4501950.05%1/9/201910821.59961-0.3%305.2999880.0%1049.5264890.7%
DAILY(2014-18
0.06%0.10%0.049%RISK 23.02%1.389%
14
1/10/2014160.815002-1.93%331.024994-0.14%6272.751.64%1/10/201910794.9502-0.2%305.5499880.1%1045.411255-0.4%
ANNUALISED
23.3%36.5%17.94%Regression Statistics
15
1/13/2014164.1252.06%336.4249881.63%6241.850098-0.49%1/11/201910737.59961-0.5%302.75-0.9%1047.0969240.2%
DAILY(2019)
0.07%0.08%0.06%Multiple R0.04046039598
16
1/14/2014162.75-0.84%336.149994-0.08%6320.8999021.27%1/14/201910886.799811.4%300.399994-0.8%1042.009888-0.5%
ANNUALISED
26.7%30.16%20.7%R Square0.001637043643
17
1/15/2014164.0700070.81%340.2749941.23%6318.899902-0.03%1/15/201910890.299810.0%301.6499940.4%1052.0550541.0%
Adjusted R Square
0.0008233819015
18
1/16/2014163.619995-0.27%336.524994-1.10%6261.649902-0.91%1/16/201910905.20020.1%303.1499940.5%1051.212158-0.1%Annual Return 2019Standard Error0.02136513033
19
1/17/2014162.154999-0.90%332.5-1.20%6303.9501950.68%1/17/201910906.95020.0%297.399994-1.9%1057.2115480.6%SBI12.57%Observations1229
20
1/20/2014164.1849981.25%335.0249940.76%6313.7998050.16%1/18/201910961.849610.5%294.950012-0.8%1056.190186-0.1%CORRELATIONHDFC19.71%
21
1/21/2014165.9499971.08%338.0499880.90%6338.9501950.40%1/21/201910922.75-0.4%292.450012-0.8%1065.0650630.8%2014-20180.2876238177ANOVA
22
1/22/2014164.684998-0.76%338.5499880.15%6345.6499020.11%1/22/201910831.5-0.8%290.25-0.8%1058.976685-0.6%20190.465749907dfSSMSF
Significance F
23
1/23/2014165.8300020.70%339.750.35%6266.75-1.24%1/23/201910849.799810.2%286.649994-1.2%1043.874146-1.4%Regression10.00091839065230.00091839065232.0119461930.1563189351
24
1/24/2014162.119995-2.24%336.700012-0.90%6135.850098-2.09%1/24/201910780.54981-0.6%288.0499880.5%1042.307495-0.2% VARIANCECAPMResidual12270.56008721020.0004564687939
25
1/27/2014159.449997-1.65%324.600006-3.59%6126.25-0.16%1/25/201910661.54981-1.1%285.399994-0.9%1039.213623-0.3%SBIHDFC2014-2018Total12280.5610056008
26
1/28/2014159.6300050.11%322.225006-0.73%6120.25-0.10%1/28/201910652.2002-0.1%281.600006-1.3%1033.333252-0.6%0.00045615995620.000113233859SBIHDFC
27
1/29/2014157.365005-1.42%322.7250060.16%6073.700195-0.76%1/29/201910651.799810.0%280.600006-0.4%1020.174683-1.3%Rfr7.00%7.00%
Coefficients
Standard Error
t StatP-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
28
1/30/2014151.660004-3.63%315.899994-2.11%6089.50.26%1/30/201910830.95021.7%287.4500122.4%1008.820618-1.1%BETARm17.9%17.9%Intercept0.00058369512650.00061040710510.95623907660.3391398221-0.00061386211640.001781252369-0.00061386211640.001781252369
29
1/31/2014152.3849950.48%314.25-0.52%6001.799805-1.44%1/31/201910893.650390.6%293.6499942.2%1031.2508542.2%2014-18 sbi0.09923950971Beta0.099239509710.08145284661X Variable 10.099239509710.069964289641.4184308910.1563189351-0.038023377810.2365023972-0.038023377810.2365023972
30
2/3/2014148.835007-2.33%313.25-0.32%6000.899902-0.01%2/1/201910912.250.2%284.399994-3.2%1036.4569090.5%hdfc0.08145284661CAPM8.09%7.89%
31
2/4/2014151.5399931.82%315.2999880.65%6022.3999020.36%2/4/201910934.349610.2%283.950012-0.2%1043.6263430.7%
32
2/5/2014152.1699980.42%318.7250061.09%6036.2998050.23%2/5/201911062.45021.2%284.6499940.2%1048.1679690.4%
33
2/6/2014150.485001-1.11%323.51.50%6063.2001950.45%2/6/201911069.400390.1%289.0499881.5%1052.4218750.4%
34
2/7/2014152.7599951.51%323.8750.12%6053.450195-0.16%2/7/201910943.59961-1.1%287.399994-0.6%1049.744629-0.3%
35
2/10/2014151.410004-0.88%321.950012-0.59%6062.7001950.15%2/8/201910888.79981-0.5%286-0.5%1052.4218750.3%
SUMMARY OUTPUT
36
2/11/2014151.9700010.37%322.3999940.14%60840.35%2/11/201910831.40039-0.5%280.5-1.9%1060.8507080.8%
37
2/12/2014153.250.84%322.7250060.10%6001.100098-1.36%2/12/201910746.04981-0.8%275.399994-1.8%1055.922363-0.5%Regression Statistics
38
2/13/2014150.054993-2.08%316.25-2.01%6048.3500980.79%2/14/201910724.40039-0.2%267.100006-3.0%1046.25415-0.9%Multiple R0.06666254085
39
2/14/2014147.509995-1.70%320.8999941.47%6073.2998050.41%2/15/201910640.9502-0.8%262.950012-1.6%1041.51416-0.5%R Square0.004443894353
40
2/17/2014147.360001-0.10%325.2000121.34%6127.1000980.89%2/18/201910604.34961-0.3%259.950012-1.1%1036.189087-0.5%
Adjusted R Square
0.003632520183
41
2/18/2014150.0950011.86%330.2000121.54%6152.750.42%2/19/201910735.45021.2%262.8999941.1%1033.293701-0.3%Standard Error0.01062830747
42
2/19/2014150.8049930.47%335.0249941.46%6091.450195-1.00%2/20/201910789.849610.5%267.7000121.8%1045.3417971.2%Observations1229
43
2/20/2014148.059998-1.82%331.375-1.09%6155.4501951.05%2/21/201910791.650390.0%2680.1%1049.08020.4%
44
2/21/2014150.2100071.45%332.2000120.25%6186.1000980.50%2/22/201910880.099610.8%270.9500121.1%1036.952637-1.2%ANOVA
45
2/24/2014151.0500030.56%335.50.99%6200.0498050.23%2/25/201910835.29981-0.4%270.149994-0.3%1053.7902831.6%dfSSMSF
Significance F
46
2/25/2014150.600006-0.30%335.5499880.01%6238.7998050.62%2/26/201910806.65039-0.3%266.350006-1.4%1046.47229-0.7%Regression10.00061868668280.00061868668285.4769975690.01942789278
47
2/26/2014152.0399930.96%338.7000120.94%6276.9501950.61%2/27/201910792.5-0.1%267.6499940.5%1037.349365-0.9%Residual12270.13860304850.0001129609197
48
2/28/2014153.3249970.85%334.799988-1.15%6221.450195-0.88%2/28/201910863.50.7%269.0499880.5%1030.071045-0.7%Total12280.1392217352
49
3/3/2014151.835007-0.97%333.100006-0.51%6297.9501951.23%3/1/201910987.45021.1%272.9500121.4%1032.9466550.3%
50
3/4/2014155.0350042.11%335.8500060.83%6328.6499020.49%3/5/2019110530.6%276.4500121.3%1044.7171631.1%
Coefficients
Standard Error
t StatP-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
51
3/5/2014157.6600041.69%334.875-0.29%6401.1499021.15%3/6/201911058.20020.0%278.1000060.6%1043.299194-0.1%Intercept0.00095428444980.00030365339683.1426766830.0017142021120.00035854707780.0015500218220.00035854707780.001550021822
52
3/6/2014157.7400050.05%337.7999880.87%6526.6499021.96%3/7/201911035.40039-0.2%281.751.3%1054.3356931.1%X Variable 10.081452846610.034804467422.3402986070.019427892780.013169988010.14973570520.013169988010.1497357052
53
3/7/2014164.9649964.58%355.7250065.31%6537.250.16%3/8/201911168.049811.2%281.200012-0.2%1055.1785890.1%
54
3/10/2014169.2149962.58%367.2250063.23%6511.899902-0.39%3/11/201911301.20021.2%287.3500062.2%1055.2976070.0%
55
3/11/2014167.479996-1.03%362.575012-1.27%6516.8999020.08%3/12/201911341.70020.4%286.899994-0.2%1076.399172.0%
56
3/12/2014164.509995-1.77%362.7749940.06%6493.100098-0.37%3/13/201911343.250.0%293.1499942.2%1103.9464112.6%
57
3/13/2014165.2100070.43%371.1749882.32%6504.2001950.17%3/14/201911426.849610.7%291.899994-0.4%1103.053833-0.1%
58
3/14/2014165.4149930.12%366.075012-1.37%6516.6499020.19%3/15/201911462.20020.3%298.3999942.2%1117.0555421.3%
59
3/18/2014170.1300052.85%3670.25%6524.0498050.11%3/18/201911532.400390.6%298.9500120.2%1121.2401120.4%
60
3/19/2014170.8849950.44%369.2250060.61%6483.100098-0.63%3/19/201911521.04981-0.1%303.0499881.4%1124.3736570.3%
61
3/20/2014167.794998-1.81%365.100006-1.12%6493.2001950.16%3/20/201911456.90039-0.6%303.7999880.2%1139.8626711.4%
62
3/21/2014170.2149961.44%366.9249880.50%6400-1.44%3/22/201911354.25-0.9%298.049988-1.9%1128.528442-1.0%
63
3/22/2014170-0.13%366-0.25%6583.52.87%3/25/201911483.251.1%294-1.4%1131.0869140.2%
64
3/24/2014172.5599981.51%375.3250122.55%6589.750.09%3/26/201911445.04981-0.3%303.53.2%1145.9908451.3%
65
3/25/2014174.3399961.03%375.075012-0.07%6601.3999020.18%3/27/2019115701.1%308.7999881.7%1140.080811-0.5%
66
3/26/2014176.751.38%373.024994-0.55%6641.750.61%3/28/201911669.150390.9%3193.3%1141.7468260.1%
67
3/27/2014183.6999973.93%373.3750.09%6695.8999020.82%4/1/201911713.20020.4%322.751.2%1146.2089840.4%
68
3/28/2014190.1950073.54%372.475006-0.24%6704.2001950.12%4/2/201911643.9502-0.6%3291.9%1137.810181-0.7%
69
3/31/2014191.7700040.83%374.3999940.52%6721.0498050.25%4/3/201911598-0.4%320.5-2.6%1136.768921-0.1%
70
4/1/2014189.365005-1.25%369.049988-1.43%6752.5498050.47%4/4/201911665.95020.6%321.7999880.4%1132.395752-0.4%
71
4/2/2014193.4900052.18%365.950012-0.84%6736.100098-0.24%4/5/201911604.5-0.5%317.049988-1.5%1143.135010.9%
72
4/3/2014189.619995-2.00%364.399994-0.42%6694.350098-0.62%4/8/201911671.95020.6%312.799988-1.3%1135.102905-0.7%
73
4/4/2014190.2799990.35%362.725006-0.46%6695.0498050.01%4/9/201911584.29981-0.8%314.750.6%1134.03186-0.1%
74
4/7/2014192.2400051.03%362.674988-0.01%6796.2001951.51%4/10/201911596.70020.1%310.899994-1.2%1109.301025-2.2%
75
4/9/2014198.53.26%370.9249882.27%6796.3999020.00%4/11/201911643.45020.4%314.8999941.3%1119.2866210.9%
76
4/10/2014202.8049932.17%369.700012-0.33%6776.299805-0.30%4/12/201911690.349610.4%315.250.1%1123.1241460.3%
77
4/11/2014199.414993-1.67%369.075012-0.17%6733.100098-0.64%4/15/201911787.150390.8%315.6000060.1%1134.805421.0%
78
4/15/2014196.404999-1.51%361.975006-1.92%6675.299805-0.86%4/16/201911752.79981-0.3%315.750.0%1142.867310.7%
79
4/16/2014195.940002-0.24%362.9750060.28%6779.3999021.56%4/18/201911594.4502-1.3%310.799988-1.6%1137.2052-0.5%
80
4/17/2014201.7299962.95%359.350006-1.00%6817.6499020.56%4/22/201911575.9502-0.2%310.049988-0.2%1124.839722-1.1%
81
4/21/2014207.2100072.72%358.225006-0.31%6815.350098-0.03%4/23/201911726.150391.3%305.25-1.5%1113.237915-1.0%
82
4/22/2014204.854996-1.14%363.7749941.55%6840.7998050.37%4/24/201911641.79981-0.7%310.751.8%1130.3233641.5%
83
4/23/2014206.5200040.81%366.50.75%6800-0.60%4/25/201911754.650391.0%306.200012-1.5%1122.231812-0.7%
84
4/24/2014206.5200040.00%366.50.00%6782.75-0.25%4/26/201911748.15039-0.1%312.52.1%1130.9083250.8%
85
4/25/2014208.5249940.97%363.200012-0.90%6761.25-0.32%4/30/201911724.75-0.2%309.950012-0.8%1149.0052491.6%
86
4/28/2014210.6199951.00%362.600006-0.17%6715.25-0.68%5/2/201911712.25-0.1%308.149994-0.6%1168.0246581.7%
87
4/29/2014206.580002-1.92%357.899994-1.30%6696.399902-0.28%5/3/201911598.25-1.0%3100.6%1174.0437010.5%
88
4/30/2014207.8600010.62%360.6499940.77%6694.799805-0.02%5/6/201911497.90039-0.9%308.75-0.4%1154.459229-1.7%
89
5/2/2014204.820007-1.46%358.549988-0.58%6699.3500980.07%5/7/201911359.4502-1.2%305.450012-1.1%1151.444824-0.3%
90
5/5/2014204.455002-0.18%358.350006-0.06%6715.2998050.24%5/8/201911301.79981-0.5%298.25-2.4%1143.94812-0.7%
91
5/6/2014205.2200010.37%360.1000060.49%6652.549805-0.93%5/9/201911278.90039-0.2%299.2999880.4%1135.846558-0.7%
92
5/7/2014207.5800021.15%357.799988-0.64%6659.8500980.11%5/10/201911148.2002-1.2%308.0499882.9%1138.6231690.2%
93
5/8/2014209.1750030.77%359.1499940.38%6858.7998052.99%5/13/201911222.049810.7%306.899994-0.4%1134.012085-0.4%
94
5/9/2014217.3249973.90%378.3999945.36%7014.252.27%5/14/201911157-0.6%314.6499942.5%1134.3591310.0%
95
5/12/2014224.2700043.20%396.0750124.67%7108.751.35%5/15/201911257.099610.9%312.100006-0.8%1133.76416-0.1%
96
5/13/2014227.6100011.49%394.075012-0.50%7108.750.00%5/16/201911407.150391.3%315.751.2%1145.6337891.0%
97
5/14/2014228.2550050.28%387.725006-1.61%7123.1499020.20%5/17/201911828.253.7%319.251.1%1171.1481932.2%
98
5/15/2014227.925003-0.14%394.1749881.66%72031.12%5/20/201911709.09961-1.0%344.7000128.0%1205.9837653.0%
99
5/16/2014241.7200016.05%402.3500062.07%7263.5498050.84%5/21/201911737.900390.2%337.549988-2.1%1191.773804-1.2%
100
5/19/2014256.8099986.24%405.9500120.89%7275.50.16%5/22/201911657.04981-0.7%341.1000061.1%1192.7951660.1%