0% found this document useful (0 votes)
46 views12 pages

Stock Price and Turnover Analysis

The document contains daily stock market data from December 22, 2016 to January 30, 2017 including open price, close price, turnover, and binning categories. There are 27 data points total with open prices ranging from 6.75 to 9.5948, close prices ranging from 6.75 to 9.5948, and turnover ranging from 5.98 to 144.0471 lacs. The binning categories included 7, 8, and more with frequencies of 9, 6, and 12 respectively.

Uploaded by

Rupali Sengar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
46 views12 pages

Stock Price and Turnover Analysis

The document contains daily stock market data from December 22, 2016 to January 30, 2017 including open price, close price, turnover, and binning categories. There are 27 data points total with open prices ranging from 6.75 to 9.5948, close prices ranging from 6.75 to 9.5948, and turnover ranging from 5.98 to 144.0471 lacs. The binning categories included 7, 8, and more with frequencies of 9, 6, and 12 respectively.

Uploaded by

Rupali Sengar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Serial No.

Date Open Price Close Price Turnover in Lacs Binning


1 22-Dec-16 1187 1183.6 10111.64 open
2 23-Dec-16 1171 1171.6 9014.42 1175
3 26-Dec-16 1172 1148.7 12253.56 1225
4 27-Dec-16 1149 1167.25 6736.41 more
5 28-Dec-16 1171.1 1174.1 12599.42
6 29-Dec-16 1177.8 1174.95 9788.06
7 30-Dec-16 1178.25 1184.7 6043.83
8 2-Jan-17 1184.5 1229.8 12691.94
9 3-Jan-17 1230 1222.55 9486.27
10 4-Jan-17 1222.65 1221.95 6921.73
11 5-Jan-17 1224 1227.35 15280.82
12 6-Jan-17 1239 1220.45 13815.83
13 9-Jan-17 1219.3 1204 6287.3
14 10-Jan-17 1201 1213.5 3381.63
15 11-Jan-17 1217.25 1232 8666.47
16 12-Jan-17 1235 1213.4 3995.31
17 13-Jan-17 1221.8 1217.85 4804.31
18 16-Jan-17 1215 1211 5967.33
19 17-Jan-17 1210 1204.45 5787.44
20 18-Jan-17 1205.1 1214.6 11875.04
21 19-Jan-17 1212 1210.8 4760.57
22 20-Jan-17 1210 1192.05 9195.46
23 23-Jan-17 1230.9699 1226.0092 6389.79
24 24-Jan-17 1233.4512 1228.1096 6196.52
25 25-Jan-17 1235.9325 1230.21 6003.25
26 27-Jan-17 1238.4138 1232.3104 5809.98
27 30-Jan-17 1240.8951 1234.4108 5616.71

Bin Frequency
1175 4
1225 15
More 8

Histogram
20

10 Frequency
Frequency
0
1175 1225 More
Bin
0
1175 1225 More
Bin

Bin Frequency
1150 1 Histogram
1200 7
More 19 20

10
Frequency
0
1150 1200
Bin
Binning
close
1150 Open Price
1200
more 1260
1240
1220 f(x) = 2.4812817617x + 1173.862987013
1200 R = 0.4263821233 Open Price
Linear (Open Price)
1180
1160
1140
1120
1100
1 2 3 4 5 6 7 8 9 10111213141516171819202122

Close Price
1240

1220
f(x) = 2.1004234896x + 1177.6928571429
1200 R = 0.3386506047
Close Price
1180 Linear (Close Price)
1160

1140

1120

1100
1 2 3 4 5 6 7 8 9 10111213141516171819202122

Turnover in Lacs
18000
16000
14000
12000 Turnover in Lacs
10000 Linear (Turnover in Lacs)
f(x) = - 193.2677526821x + 10834.6150649351
Frequency 8000 R = 0.1354123542
6000
4000
2000
0
6000
4000
2000
0

Histogram

Frequency

1150 1200 More


Bin
en Price
ear (Open Price)

ose Price
ear (Close Price)

r in Lacs
Turnover in Lacs)
serial No. Date Open Price Close Price Turnover in Lacs Binning
1 22-Dec-16 6.9 6.75 15.98 open
2 23-Dec-16 6.8 6.85 11.65 7
3 26-Dec-16 6.9 6.75 14.06 8
4 27-Dec-16 6.8 6.9 20.92 more
5 28-Dec-16 6.95 6.85 14.85
6 29-Dec-16 6.8 6.9 19.65
7 30-Dec-16 6.9 6.9 10.63
8 2-Jan-17 6.95 6.9 18.39
9 3-Jan-17 6.95 7.3 43.24
10 4-Jan-17 7.35 7.3 15.01
11 5-Jan-17 7.2 7.3 10.75
12 6-Jan-17 7.25 7.15 8.79
13 9-Jan-17 7.2 7.15 8.9
14 10-Jan-17 7.15 7.4 37.34
15 11-Jan-17 7.55 8.85 138.08
16 12-Jan-17 9.55 9.05 524.75
17 13-Jan-17 9 8.75 90.03
18 16-Jan-17 8.6 8.65 28.72
19 17-Jan-17 8.7 8.55 26.93
20 18-Jan-17 8.6 8.6 51.18
21 19-Jan-17 8.65 9.15 99.89
22 20-Jan-17 9 8.8 66.58
23 23-Jan-17 8.9945 9.0988 121.8451
24 24-Jan-17 9.1136 9.2228 127.3956
25 25-Jan-17 9.2327 9.3468 132.9461
26 27-Jan-17 9.3518 9.4708 138.4966
27 30-Jan-17 9.4709 9.5948 144.0471

Bin Frequency
7 9
8 6
More 12

Histogram
15
10
Frequency Frequency
5
0
7 8 More
Bin
0
7 8 More
Bin

Frequency
7 8 Histogram
8 6
15
More 13
10
Frequency 5
0
7 8
Bin
Binning
close
7
8
Open Price
more 12

10

8 f(x) = 0.1191134952x + 6.2551948052 Open Price


R = 0.7225071328
Linear (Open Price)
6

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Close Price
10
9
8 f(x) = 0.1239977414x + 6.2467532468
R = 0.8025963132
7
Close Price
6
Linear (Close Price)
5
4
3
2
1
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Turnover in Lacs
600

500

400 Turnover in Lacs


Frequency Linear (Turnover in Lacs)
300

200

100
f(x) = 5.550513834x - 5.8163636364
0 R = 0.1078650182
1 2 3 4 5 6 7 8 9 10111213141516171819202122
200

100
f(x) = 5.550513834x - 5.8163636364
0 R = 0.1078650182
1 2 3 4 5 6 7 8 9 10111213141516171819202122

Histogram

Frequency

7 8 More
Bin
Open Price
Linear (Open Price)

Close Price
Linear (Close Price)

rnover in Lacs
near (Turnover in Lacs)

You might also like