Market is said to be Bullish above 50 SMA and
Bearish below it.
When price is above 50 sma one should buy above
the recent high ( ie the pivot high).
The opposite is true for selling .
According to this we got Buy signal in N.spot on 5th july
Buy > 8398. And it trigered on 11th july.
If we were alert we would have filled buy
between 8420 to 8440.(coressponding price in Nfut).
Now the recent high is 8824 .
This is for Learners
Learn to trade positional.
Make your own excel if you wish
This assumes date in M column
you can download 100 days data from nse & paste it here
S51 = Average(Q2:Q51)
T54 = if(and(Q52>S52,O53=max(O52:O54)),"BUY > "&Round(O53,0),T53)
U54 = if(and(q52<s52,p53=min(p52:p54)),"SELL < "&Round(p53,0),u53)
copy the formula thru Row no 101