Nr7 to nifty 50 stocks

nac

nac

Well-Known Member
#2
#2
^

Follow this link and download the file... Here you can all the stocks which fall on NR7...

http://www.traderji.com/advanced-trading-strategies/29825-trading-nr7-setup-142.html#post478979

And add this formula in the next column (i.e. Column J) and filter it with NIFTY50, you will get what you want...

=IF(OR(A36="AMBUJACEM",A36="ACC",A36="AXISBANK",A36="BAJAJ-AUTO",A36="BHEL",A36="BPCL",A36="BHARTIARTL",A36="CAIRN",A36="CIPLA",A36="DLF",A36="DRREDDY",A36="GAIL",A36="HCLTECH",A36="HDFCBANK",A36="HEROHONDA",A36="HINDALCO",A36="HINDUNILVR",A36="HDFC",A36="ITC",A36="ICICIBANK",A36="INFOSYSTCH",A36="IDFC",A36="JPASSOCIAT",A36="JINDALSTEL",A36="KOTAKBANK",A36="LT",A36="M&M",A36="MARUTI",A36="NTPC",A36="ONGC",A36="POWERGRID",A36="PNB",A36="RANBAXY",A36="RELCAPITAL",A36="RCOM",A36="RELIANCE",A36="RELINFRA",A36="RPOWER",A36="SESAGOA",A36="SIEMENS",A36="SBIN",A36="SAIL",A36="STER",A36="SUNPHARMA",A36="SUZLON",A36="TCS",A36="TATAMOTORS",A36="TATAPOWER",A36="TATASTEEL",A36="WIPRO"),"NIFTY50","")
Click to expand...
Here 36 indicates "row" address... You paste this formula in J36 and copy it from there. I guess, its not too complicate thing to do...
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
P afl coding help required for nr7 trading Algo & Automated Trading 1
vagar11 Is anyone using NR7 for trading? Technical Analysis 28
B NR7 Trading help Advanced Trading Strategies 6
P Apply logic only after a nr7 day AmiBroker 4
amitrandive NR7-NR21-Inside day Excel sheet needed Advanced Trading Strategies 14

Similar threads