Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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


BSE Sensex on Jul 27,2009 15375.04 [-3.92]
Prev. Day Close:15378.96 Change:-0.03%
Code	Rank	Company	Mkt. Cap.	Equity	FV	Last Price	Trd.Value*	% of Mkt.Cap*	Last traded Date	Last traded time	Volume
500325	1	RELIANCE	305102.57	1573.87	10	1938.55	332.34	0.11	Jul 27,2009	-	1714350
500312	2	ONGC CORPN	234131.4	2138.87	10	1094.65	32.29	0.01	Jul 27,2009	-	294998
532555	3	NTPC LTD	176823.89	8245.46	10	214.45	20.37	0.01	Jul 27,2009	-	949790
532454	4	BHARTI ARTL	160777.19	1898.42	5	423.45	18	0.01	Jul 27,2009	-	425134
513377	5	MINERAL&METL	153905	50	10	30781	2.45	0	Jul 27,2009	-	795
526371	6	NMDC LTD	147328.25	396.47	1	371.6	2.08	0	Jul 27,2009	-	55910
500209	7	INFOSYS TECH	116061.84	286.53	5	2025.3	29.1	0.03	Jul 27,2009	-	143672
500103	8	BHEL	110670.68	489.52	10	2260.8	49.57	0.04	Jul 27,2009	-	219270
500112	9	STATE BANK	108535.91	634.88	10	1709.55	59.61	0.05	Jul 27,2009	-	348689
532540	10	TCS LTD.	93984.74	195.72	1	480.2	17.72	0.02	Jul 27,2009	-	368912
Code	Rank	Company	Mkt. Cap.	Equity	FV	Last Price	Trd.Value*	% of Mkt.Cap*	Last traded Date	Last traded time	Volume
500875	11	ITC LTD.	90094.93	377.44	1	238.7	24.48	0.03	Jul 27,2009	-	1025571
500510	12	LARSEN & TOU	87908.19	117.25	2	1499.5	46.21	0.05	Jul 27,2009	-	308150
532174	13	ICICI BANK	84346.64	1113.34	10	757.6	188.19	0.22	Jul 27,2009	-	2484050
500113	14	STEEL AUTH.	72467.87	4130.4	10	175.45	38.16	0.05	Jul 27,2009	-	2175261
532868	15	DLF LIMITED	69941.61	339.44	2	412.1	282.13	0.4	Jul 27,2009	-	6846061
507685	16	WIPRO LTD.	67385.56	293.14	2	459.75	7.38	0.01	Jul 27,2009	-	160541
500010	17	HDFC	67319.78	284.56	10	2365.75	30.39	0.05	Jul 27,2009	-	128450
500696	18	HIND UNI LT	66047.65	221.08	1	298.75	33.64	0.05	Jul 27,2009	-	1126050
530965	19	INDIAN OIL	62683.86	1213.98	10	516.35	3.69	0.01	Jul 27,2009	-	71372
500180	20	HDFC BANK	61139.78	426.18	10	1434.6	13.52	0.02	Jul 27,2009	-	94264
Code	Rank	Company	Mkt. Cap.	Equity	FV	Last Price	Trd.Value*	% of Mkt.Cap*	Last traded Date	Last traded time	Volume
532712	21	REL COM LTD	58226	1032.01	5	282.1	83.3	0.14	Jul 27,2009	-	2952869
532743	22	REL PET	54247.5	4500	10	120.55	18.82	0.03	Jul 27,2009	-	1561448
532898	23	POWER GRID	48233.31	4208.84	10	114.6	10.92	0.02	Jul 27,2009	-	953176
532286	24	JINDAL STE	47961.57	15.51	1	3092.3	55.96	0.12	Jul 27,2009	-	180970
532792	25	CAIRN IND	46724.47	1896.67	10	246.35	8.21	0.02	Jul 27,2009	-	333275
500900	26	STERLITE IN	46249.76	141.74	2	652.6	57.77	0.12	Jul 27,2009	-	885167
532155	27	GAIL (I) LTD	43071.24	1268.48	10	339.55	15.51	0.04	Jul 27,2009	-	456640
532939	28	RPOWER	41692.34	2396.8	10	173.95	21.64	0.05	Jul 27,2009	-	1244297
532500	29	MARUTISUZUK	39580.6	144.46	5	1369.95	16.43	0.04	Jul 27,2009	-	119904
532215	30	AXIS BANK	33777.4	359.87	10	938.6	88.51	0.26	Jul 27,2009	-	942979
Code	Rank	Company	Mkt. Cap.	Equity	FV	Last Price	Trd.Value*	% of Mkt.Cap*	Last traded Date	Last traded time	Volume
532532	31	JAIPRA	33699.27	280.36	2	240.4	185.67	0.55	Jul 27,2009	-	7723293
500182	32	HERO HONDA	33614.5	39.94	2	1683.25	10.66	0.03	Jul 27,2009	-	63348
500470	33	TATA STEEL	33413.53	730.59	10	457.35	163.78	0.49	Jul 27,2009	-	3581091
500188	34	HINDUS.ZI	29553.86	422.53	10	699.45	6.32	0.02	Jul 27,2009	-	90333
500400	35	TATA POWER	27464.86	222.01	10	1237.1	16.82	0.06	Jul 27,2009	-	135969
532754	36	GMR INFRASTR	26964.56	366.74	2	147.05	34.65	0.13	Jul 27,2009	-	2356125
500300	37	GRASIM IND.	26474.75	91.67	10	2888.05	14.49	0.05	Jul 27,2009	-	50160
500390	38	REL INFRA	26365.48	226.42	10	1164.45	95.81	0.36	Jul 27,2009	-	822772
524715	39	SUN PHARMA.	25781.26	103.56	5	1244.75	2.21	0.01	Jul 27,2009	-	17736
532810	40	POWER FINAN	25038.6	1147.77	10	218.15	1.63	0.01	Jul 27,2009	-	74669
Code	Rank	Company	Mkt. Cap.	Equity	FV	Last Price	Trd.Value*	% of Mkt.Cap*	Last traded Date	Last traded time	Volume
532822	41	IDEA CELL	24769.72	3100.09	10	79.9	7.34	0.03	Jul 27,2009	-	919050
513599	42	HIND.COPPER	24009.46	462.61	5	259.5	0.71	0	Jul 27,2009	-	27340
500247	43	KOTAK MAH.BK	23182.07	346.57	10	668.9	27.82	0.12	Jul 27,2009	-	415953
513683	44	NEYVELI LIGN	22951.07	1677.71	10	136.8	14.68	0.06	Jul 27,2009	-	1073378
532461	45	PUNJAB NATIO	22903.39	315.3	10	726.4	7.67	0.03	Jul 27,2009	-	105648
500520	46	MAH & MAH	22755.89	278.82	10	816.15	8.34	0.04	Jul 27,2009	-	102205
532921	47	MUNDRA PORT	22410.03	400.68	10	559.3	4.93	0.02	Jul 27,2009	-	88129
500111	48	REL.CAP.	22144.77	245.63	10	901.55	126.97	0.57	Jul 27,2009	-	1408402
500087	49	CIPLA LTD.	22077.79	155.45	2	284.05	3.23	0.01	Jul 27,2009	-	113777
507878	50	UNITECH LTD	21021.44	477.76	2	88	121.49	0.58	Jul 27,2009	-	13805373

* During market trading hours, as traded values are not available on a real time basis, an approximation is done. The traded value is calculated as follows, using the last traded price:
Traded Value (Rs. cr) = (Last Price * Volume) /100,00,000
This value will be updated with the actual figures, once trading closes and end-of-day data is available.

New Text Document