Sector Rotation

kkseal

Well-Known Member
Wow, the complete list :)

Sugar seems to be coming out of the bear phase.

BHEL -> Power
RELIANCE -> Refineries
L&T -> Engg

Is that right? Have you clubbed Power generators & equipment manufacturers together (like say NTPC & BHEL)?

Regards
 

oxusmorouz

Well-Known Member
Wow, the complete list :)

Sugar seems to be coming out of the bear phase.

BHEL -> Power
RELIANCE -> Refineries
L&T -> Engg

Is that right? Have you clubbed Power generators & equipment manufacturers together (like say NTPC & BHEL)?
Hi Kalyan
Created a template in excel so that this process is automated with a copy paste.

Power includes only power generation and distribution. Transmission and equipment are not included in that. Reliance Ind is not included in any of the sectors, owing to its diversified set up. BHEL and LT are included in engineering sector.
 
Last edited:

oxusmorouz

Well-Known Member
For the day ended 15 July 2008

Code:
Rank	Security Name	Absolute ROC 20
1	Pharma	        85.4485	 -12.5279
2	FMCG	        73.8582	 -9.9782
3	Oil Exp         73.3597	 -11.7653
4	Suger	        73.2399	 -12.8587
5	Software	71.9181	 -17.6673
6	Aluminum	70.627	 -20.7203
7	Nifty	        62.8398	 -17.0191
8	Steel	        60.5672	 -16.8043
9	Auto	        59.796	 -14.4202
10	Retail	        57.8985	 -13.7115
11	Telecom	        57.6592	 -18.6467
12	Fertiliz	55.0977	 -24.8145
13	AutoAnci	54.9217	 -18.5238
14	Cements	        53.3789	 -12.7424
15	Shipping	52.5225	 -21.4785
16	Power	        52.0392	 -17.1246
17	PVTBK	        51.5746	 -23.6069
18	Refineri        51.0781	 -15.6633
19	Engineer	50.1040	 -18.5576
20	Hotels	        49.8420	 -18.5343
21	Media	        49.1595	 -20.0736
22	Hardware	48.8305	 -23.3568
23	Textiles	47.2335	 -20.7502
24	PSUBK	        46.5655	 -23.745
25	ConCivil	40.1449	 -23.1544
26	Cables	        39.8	 -21.3065
27	RealEst	        33.8712	 -28.033
 

oxusmorouz

Well-Known Member
For the day ended 16 July 2008

Code:
[B]Rank	Security Name	Absolute	 ROC 20[/B]
1	Pharma	        86.2833 	-11.0550
2	Sugar	        73.2399	        -10.3042
3	FMCG	        72.9255	        -11.0999
4	Oil Exp         72.2488	        -12.8261
5	Software	71.2678	        -16.7240
6	Aluminum	67.4319	        -23.5239
7	Nifty	        62.1172	        -16.7096
8	Steel	        59.5581	        -16.9374
9	Auto	        58.0103	        -17.6190
10	Telecom	        57.6617	        -19.0209
11	Retail	        57.6263	        -13.8660
12	AutoAnci	54.5660	        -17.7128[U]
13	Fertiliz	53.3363	        -24.5387[/U]
14	Cements	        52.9461	        -15.1551
15	Shipping	52.5225	        -22.2662
16	Power	        52.0392	        -18.8182
17	Refineri        51.0516	        -15.0637
18	PVTBK	        50.8915	        -23.5087
19	Engineer	49.5867	        -17.7331
20	Hotels	        49.1039	        -19.0956
21	Media	        47.9934	        -22.7983
22	Hardware	47.5132	        -24.8875
23	Textiles	46.3772	        -22.6755
24	PSUBK	        46.1794	        -23.3672
25	Cables	        39.8540	        -20.5214
26	ConCivil	39.2156	        -23.8994
27	RealEst	        32.4318	        -28.7524
 

kkseal

Well-Known Member
Hi Kalyan
Created a template in excel so that this process is automated with a copy paste.

Power includes only power generation and distribution. Transmission and equipment are not included in that. Reliance Ind is not included in any of the sectors, owing to its diversified set up. BHEL and LT are included in engineering sector.
Ok Clear.

Regards
 

oxusmorouz

Well-Known Member
For the day ended 17 July 2008

Code:
[U][SIZE="3"]Rank	Security Name	Absolute	ROC 20[/SIZE][/U]
1	Pharma	         86.508	         -8.9416
2	Oil Exp          73.3676	-10.8217
3	Sugar	         73.2399	-11.4058
4	Software	 72.9874	-13.6439
5	FMCG	         72.8708	-10.5373
6	Aluminum	 65.7383	-24.231
7	Nifty	         64.2411	-12.3672
8	Auto	         59.4396	-15.0202
[u]9	Steel	         59.0707	-16.9989[/u]
10	Telecom	         59.0096	-16.953
11	Retail	         58.4208	-13.0204
12	AutoAnci	 55.4688	-15.8434
13	Cements	         53.3196	-13.3205
14	Fertiliz	 53.2838	-22.4351
15	PVTBK	         52.7251	-18.1457
16	Shipping	 52.5225	-20.6549
17	Refineri         52.1764	-12.0074
[u]18	Power	         52.0392	-14.0446[/u]
19	Engineer	 50.9391	-13.8068
20	Hotels	         49.323         -17.3422
21	Media	         48.6586	-21.0836
22	PSUBK	         47.9809	-17.8495
23	Hardware	 47.6412	-22.6792
24	Textiles	 47.3398	-19.6352
25	ConCivil	 40.4286	-19.4451
26	Cables	         39.8555	-19.2374
27	RealEst	         33.0454	-25.1304
 

oxusmorouz

Well-Known Member
For the day ended 18 July 2008

Code:
[B][U]Rank	Security Name	Absolute	ROC 20[/U][/B]
1	Pharma	         87.0713	-5.8262
2	Oil Exp          74.4121	-6.4027
3	FMCG	         73.7887	-8.5779
4	Sugar	         73.2399	-7.6522
5	Software	 71.4257	-13.1379
6	Aluminum	 68.8594	-15.2629
7	Nifty	         66.6018	-5.8723
8	Telecom	         60.8831	-11.3085
[U]9	Auto	         60.4616	-11.4254[/U]
10	Steel            59.1962	-14.1821
11	Retail	         58.4657	-10.6391
12	AutoAnci	 55.4421	-13.7406
13	PVTBK	         55.1597	-11.8053
14	Fertiliz	 54.9280	-15.5816
15	Refineri         54.2289	-5.5267
16	Cements	         54.0215	-9.3969
17	Shipping	 52.5225	-15.6942
[U]18	Engineer	 52.1911	-8.8271[/U]
19	Power	         52.0392	-8.9701
20	PSUBK	         50.0126	-9.8387
21	Hotels	         49.6034	-15.696
22	Media	         49.5752	-15.9597
23	Hardware	 48.5919	-18.8747
24	Textiles	 48.0946	-15.8911
25	ConCivil	 41.9017	-12.9663
26	Cables	         39.8744	-15.8887
27	RealEst	         33.9734	-18.2681
 

oxusmorouz

Well-Known Member
For the day ended 21 July 2008

Code:
[U]Rank	Security Name	Absolute	ROC 20[/U]
1	Pharma	         89.1591	-1.3257
2	Oil Exp          74.6702	-4.0307
3	FMCG	         73.7586	-7.14
4	Sugar	         73.2399	-1.1226
5	Aluminum	 72.6772	-4.7524
6	Software	 71.0170	-13.0002
7	Nifty	         67.6963	-2.5056
8	Auto	         61.8244	-6.6382
[U]9	Telecom	         61.2871	-9.1347[/U]
10	Steel	         59.1237	-11.2703
11	Retail	         57.4226	-9.4835
12	PVTBK	         55.7221	-8.2273
13	AutoAnci	 55.1351	-11.5396
14	Fertiliz	 54.2343	-11.9932
15	Cements	         53.6637	-7.8016
16	Refineri         53.5445	-3.3252
17	Engineer	 52.6217	-4.1566
[U]18	Shipping	 52.5225	-11.9623[/U]
19	Power	         52.0392	-2.5489
20	PSUBK	         51.9903	-0.8857
21	Hotels	         49.5337	-11.8878
22	Hardware	 49.5241	-14.0094
23	Media	         49.2172	-14.0116
24	Textiles	 48.1365	-12.9004
25	ConCivil	 42.3067	-7.3383
26	Cables	         39.8571	-13.2204
27	RealEst	         34.3029	-11.9356
 

renu daga

Well-Known Member
hi oxy
kindly make teh dat for ur excel sheet .. sorted out as per data..in ascending or descending manner
next u can add a column in ur sheet..stating difference with last sheets roc

renu
 

Similar threads