# 45° trending stocks.......is a scanner possible

#### praveen5344

##### Active Member
Heard a lot about the strength of the stocks that are trending particularly in 45° angle either it is in upward or downward direction but I have'nt came across any such AFL or any such Scanner...........is it possible to code it........or if anyone has already got it can u please share it.

#### praveen5344

##### Active Member
we can scan in an excel using gann angle principles in live trading,if ur intrested i wil lshare u
please do share brother.....it will be very helpful for many.....and plz do explain ur way of using it..........

#### dhilsath

##### New Member
Hai.
Find the degree factors for angle 45 =45/180
calculate the price range=(if nifty is at 8688 daily volatility is 0.55 then price range = 8688*0.55/100)
use this formula to find price action is above or below 45 degree
calculate in excel
power(sqrt(price range)+ degree factor,2)=A (let us assume) and then calculate
opening price+ (A)* with degree factor= v
when the price is trading above(V)we can consider the stock is above 45 degree or below
Apply this formula in excell and select maximum no of stocks in market watch(nest.odin.etc) give link to excel
In excell apply condition if the price is trading above the calculated value (v)give buy signal or below give sell signal. I hope it is enough to understand

#### alokdaga

##### Active Member
From where do you get the Daily volatility for Nifty? Can you please give a specific example of any current trading day... thanks..

#### dhilsath

##### New Member
u can get it http://www.nseindia.com/ there select derivaties and enter the stock name or index name u wish to know and at the bottom of the page u select 'other information'

#### dhilsath

##### New Member
This is an excell format i am using as a scanner if u are intrested i will demonstrate with an example.