cnatarajan rajan
View Profile

FIND YOUR FRIEND -> cnr

Cnatarajan Rajan at 09:37 PM - Jul 08, 2016 ( ) Views: 1,294

5 5

Friends

Trend is ur friend

To know at wat trend we are in

there is a simple method

make your own excel

this assumes  column  A= date

                                  B = open

                                 C = high

                                 D = low

                                 E = close p

we need  20 days OHLC you can download from NSE

      Cell   F9 =MAX(C3:C9)

   IN CELL G9 =MIN(D3:D9)

IN CELL    H9 =IF(E9<G9+(F9-G9)*0.382,"BEAR",IF(E9>G9+(F9-G9)0.618,"BULL","NEUTRAL"))

copy formula from here excluding =

go to excel select cell  F9, type = then paste the formula (CTRL+V)

Like this paste all formula

copy & paste all formulas to last ROW

you  are Done

Thank you

 

 



From: cnatarajan rajan at 07:25 AM - Jul 09, 2016( )


AFTER  ERROR  CHECK

Cell   F9 =MAX(C3:C9)

   IN CELL G9 =MIN(D3:D9)

IN CELL    H9 =IF(E9<G9+(F9-G9)*0.382,"BEAR",IF(E9>G9+(F9-G9)*0.618,"BULL","NEUTRAL"))

copy formula from here excluding =

go to excel select cell  F9, type = then paste the formula (CTRL+V)

Like this paste all formula

copy & paste all formulas to last ROW

you  are Done


(1 to 7 out of 7) - Latest Replies on Top | First | << Previous | Next >> | Last |
Cnatarajan Rajan at 08:39 PM - Jul 11, 2016 ( )

Nifty spot last close = 8468

Above   8490 , 8505 , 8561 , 8612

Below   8490 , 8567 , 8423 , 8398 , 8336 , 8295

Cnatarajan Rajan at 11:38 AM - Jul 11, 2016 ( )

Nspot   above 8398 the levels are

8423 , 8467 , 8490 , 8505 , 8561

Now near  8467

Cnatarajan Rajan at 08:58 PM - Jul 09, 2016 ( )

 

Nifty spot last close = 8323.2
Above      8295 , 8336 , 8398
Below       8295 , 8262 , 8245 , 8212 , 8186 , 8153
Lets  watch these levels  on monday
Thanks

Cnatarajan Rajan at 02:38 PM - Jul 09, 2016 ( )

Ashish Patel ji

Sorry , my internet connection is too bad to upload  a file

 

Date Open High Low Close 7d  H 7d  L trend
16-May-16 7871.6 7921.6 7810.7 7912.8      
17-May-16 7925.0 7980.0 7921.1 7932.8      
18-May-16 7895.6 7930.0 7845.1 7905.1      
19-May-16 7880.0 7898.5 7801.0 7811.9      
20-May-16 7830.0 7849.2 7780.2 7788.7      
23-May-16 7819.1 7836.0 7762.1 7770.4      
24-May-16 7766.1 7793.4 7747.0 7785.0      
25-May-16 7827.5 7970.9 7827.5 7964.7 7980.0 7747.0 BULL
26-May-16 7999.0 8099.9 7968.0 8084.5 8099.9 7747.0 BULL
27-May-16 8113.5 8200.0 8102.6 8192.0 8200.0 7747.0 BULL
30-May-16 8214.4 8240.6 8193.1 8214.7 8240.6 7747.0 BULL
31-May-16 8242.2 8244.5 8177.0 8211.5 8244.5 7747.0 BULL
1-Jun-16 8222.1 8244.4 8200.0 8215.1 8244.5 7747.0 BULL
2-Jun-16 8202.0 8274.0 8185.0 8263.6 8274.0 7827.5 BULL
3-Jun-16 8287.5 8296.7 8250.0 8260.7 8296.7 7968.0 BULL
6-Jun-16 8275.0 8277.0 8231.1 8255.6 8296.7 8102.6 BULL
7-Jun-16 8289.5 8344.2 8257.0 8309.1 8344.2 8177.0 BULL
8-Jun-16 8305.7 8322.0 8290.0 8309.0 8344.2 8177.0 BULL
9-Jun-16 8316.0 8316.0 8230.0 8256.8 8344.2 8185.0 NEUTRAL
10-Jun-16 8226.3 8325.0 8202.2 8220.6 8344.2 8185.0 BEAR
13-Jun-16 8150.0 8175.0 8111.1 8157.4 8344.2 8111.1 BEAR
14-Jun-16 8159.7 8166.5 8106.0 8149.0 8344.2 8106.0 BEAR
15-Jun-16 8200.0 8259.9 8160.0 8249.2 8344.2 8106.0 NEUTRAL
16-Jun-16 8210.3 8212.5 8115.1 8183.5 8325.0 8106.0 BEAR
17-Jun-16 8201.1 8241.0 8175.9 8199.2 8325.0 8106.0 NEUTRAL
20-Jun-16 8135.0 8288.0 8131.8 8280.5 8325.0 8106.0 BULL
21-Jun-16 8280.4 8280.4 8236.0 8253.8 8288.0 8106.0 BULL
22-Jun-16 8258.1 8280.0 8186.1 8233.5 8288.0 8106.0 BULL
23-Jun-16 8236.5 8332.9 8225.0 8310.1 8332.9 8115.1 BULL
24-Jun-16 8072.6 8130.0 7959.8 8118.4 8332.9 7959.8 NEUTRAL
27-Jun-16 8065.0 8159.4 8065.0 8134.5 8332.9 7959.8 NEUTRAL
28-Jun-16 8126.0 8188.1 8121.0 8166.6 8332.9 7959.8 NEUTRAL
29-Jun-16 8195.0 8246.0 8186.5 8236.7 8332.9 7959.8 BULL
30-Jun-16 8281.3 8334.6 8268.3 8321.1 8334.6 7959.8 BULL
1-Jul-16 8310.0 8378.0 8310.0 8355.2 8378.0 7959.8 BULL
4-Jul-16 8385.1 8415.0 8376.0 8387.4 8415.0 7959.8 BULL
5-Jul-16 8381.0 8382.5 8342.0 8354.0 8415.0 8065.0 BULL
7-Jul-16 8347.7 8392.0 8330.1 8358.3 8415.0 8121.0 BULL
8-Jul-16 8350.0 8353.0 8295.1 8336.5 8415.0 8186.5 BULL
Today              

 

Ashish Patel at 09:21 AM - Jul 09, 2016 ( )

THANKS SIR

KINDLY POST EXCELSHEET OR ONE CALCULATION FOR BETTER UNDERSTANDING

Cnatarajan Rajan at 07:23 AM - Jul 09, 2016 ( )

AFTER  ERROR  CHECK

Cell   F9 =MAX(C3:C9)

   IN CELL G9 =MIN(D3:D9)

IN CELL    H9 =IF(E9<G9+(F9-G9)*0.382,"BEAR",IF(E9>G9+(F9-G9)*0.618,"BULL","NEUTRAL"))

copy formula from here excluding =

go to excel select cell  F9, type = then paste the formula (CTRL+V)

Like this paste all formula

copy & paste all formulas to last ROW

you  are Done

1 to 7 out of 7

Login to participate in discussion.



Top Gainers

MANUGRAPH INDIA LIMITED 18.00 3.00 (20.00%)
SMS LIFESCIENCES (I) LTD 512.15 85.35 (20.00%)
INDIA TOUR. DEV. CO. LTD. 267.05 44.50 (20.00%)
IFB AGRO INDUSTRIES LTD 408.80 68.10 (19.99%)
ARIES AGRO LTD. 73.60 12.25 (19.97%)
PRIME FOCUS LIMITED 48.10 8.00 (19.95%)
VISHNU CHEMICALS LIMITED 137.00 22.65 (19.81%)
MUKAND ENGINEERS LIMITED 13.95 2.30 (19.74%)
GLOBAL OFFSHORE SERV LTD 8.90 1.30 (17.11%)
THE STATE TRADING CORPN 127.75 17.90 (16.29%)



Top Losers

MALU PAPER MILLS LIMITED 28.40 -3.15 (-9.98%)
INDIAN ENERGY EXC LTD 118.70 -12.10 (-9.25%)
ALPA LABORATORIES LTD 15.90 -1.20 (-7.02%)
SANCO INDUSTRIES LIMITED 20.50 -1.25 (-5.75%)
GOA CARBON LIMITED 320.10 -17.80 (-5.27%)
GENUS P&B LIMITED 6.40 -0.35 (-5.19%)
THE BYKE HOSPITALITY LTD 24.50 -1.30 (-5.04%)
EVEREADY INDS. IND. LTD. 60.50 -3.15 (-4.95%)
ORIENT PAPER AND INDS LTD 29.95 -1.55 (-4.92%)
TALWALKAR LIFESTYLES LTD 9.70 -0.50 (-4.90%)