Bharat Financial.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	P	Q	S	T
1	Date	Symbol	Series	Open	High	Low	LTP	Close	Volume	Turnover	Buy - If close price increases from previous close price
2	Date	Symbol	Series	Open	High	Low	LTP	Close	Volume	(in Lakhs)	Sell - If close price decreases from previous close price			Close Price	Buy Volumes	Sell Volumes	Close Price
3	21-Dec-16	BHARATFIN	EQ	586	596.15	574.2	577.65	578.9	62,06,914	36,216.57	Sell	High	756	739.5	3458260	697.7	2916947
4	20-Dec-16	BHARATFIN	EQ	598	604.75	550	586	580.5	1,41,37,106	81,608.88	Sell	Low	550	744.75	1871000	705.15	1421616
5	19-Dec-16	BHARATFIN	EQ	640	641.3	599	602	603.2	30,51,574	18,853.66	Sell	Difference	206	716.5	1418836	653.3	2078271
6	16-Dec-16	BHARATFIN	EQ	665.9	666	636	639	641.25	19,83,639	12,838.06	Sell	Avg	103	707.6	1689888	676.95	2510624
7	15-Dec-16	BHARATFIN	EQ	645	669.7	631.9	661.6	659.85	27,97,830	18,465.23	Buy			720.8	1523945	692.25	1899849
8	14-Dec-16	BHARATFIN	EQ	680	685.4	651.2	654	653.3	20,78,271	13,783.76	Sell	Low	550	659.85	2797830	714.35	1106229
9	13-Dec-16	BHARATFIN	EQ	690.3	691	669	678	676.95	25,10,624	17,016.94	Sell	Avg	103			578.9	6206914
10	12-Dec-16	BHARATFIN	EQ	715.25	717.4	682	692.9	692.25	18,99,849	13,262.36	Sell	Total	653			580.5	14137106
11	9-Dec-16	BHARATFIN	EQ	725.6	725.6	709.5	715.15	714.35	11,06,229	7,902.58	Sell					603.2	3051574
12	8-Dec-16	BHARATFIN	EQ	713	730	710.1	721.95	720.8	15,23,945	11,002.01	Buy					641.25	1983639
13	7-Dec-16	BHARATFIN	EQ	717.5	723.15	700.05	708.4	705.15	14,21,616	10,099.29	Sell
14	6-Dec-16	BHARATFIN	EQ	709	726	708.25	718.2	716.5	14,18,836	10,234.73	Buy
15	5-Dec-16	BHARATFIN	EQ	703.45	712.45	691.2	707.9	707.6	16,89,888	11,909.24	Buy				12759759		37312769
16	2-Dec-16	BHARATFIN	EQ	735.75	737	688.8	699.95	697.7	29,16,947	20,648.94	Sell
17	1-Dec-16	BHARATFIN	EQ	745	756	732.2	745.6	744.75	18,71,001	13,932.09	Buy
18	30-Nov-16	BHARATFIN	EQ	737	755	734	739.8	739.5	34,58,260	25,779.32	Buy
19	29-Nov-16	BHARATFIN	EQ	693.4	738.45	692	734.4	733	44,23,944	32,112.53	High Volumes
20	28-Nov-16	BHARATFIN	EQ	691.35	708.8	677.15	684.05	681.45	17,19,044	11,914.17
21	25-Nov-16	BHARATFIN	EQ	689	703.95	672.25	698.9	699.35	31,52,806	21,710.51
22	24-Nov-16	BHARATFIN	EQ	706	709.15	679.35	687	684.45	26,41,403	18,230.56
23	23-Nov-16	BHARATFIN	EQ	700	719.15	687.1	713	715.4	23,54,215	16,617.55
24	22-Nov-16	BHARATFIN	EQ	684	695	677.1	692	690.1	18,88,326	12,963.07
25
26	Stock is in bear trend because 1) Sell Volumes are higher than the Buy Volumes so bears are in control 2) Target will be 447 calculated as 550 (low price) - 103 (Avg Price) = 447
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100