Consider the below trade. As per the NR7 setup, a short trade was initiated at 03/13/2013 10:10 @ Rs.488.8 (1000 shares). Short trade is initiated because 488.8 is lesser than 489.05(which low of NR7). So my initial stop loss will be high of NR7(489.9).
Column "F" is "HIGH-LOW", Column "L" is maximum range value for last 7 rows of column "F".
Column "M" is if maximum range value for last 7 rows of column "F" is current row then it returns "Y". Which simply means if column "L" = "cOLUMN "F" - it returns "Y".
So in column "M" wherever it is marked as "Y" then that row is considered to have maximum range value.
Back to the Trade:
1st Stop Loss: 489.9 (high of NR7)
Trailing SL 1: 488.95 (Column = "M" generated "Y")
So at this point consider your stop loss as 1st Stop Loss: 489.9
Trailing SL 2: 482.2 (Column = "M" generated "Y")
So at this point consider your stop loss as Trailing SL 1: 488.95
Trailing SL 3: 486.5 (Column = "M" generated "Y")
So at this point consider your stop loss as Trailing SL 2: 482.2
it goes on like this untill 3:10 PM. If your SL is not hit till this time, then book profit in whatever price it trades during this time.
Column "F" is "HIGH-LOW", Column "L" is maximum range value for last 7 rows of column "F".
Column "M" is if maximum range value for last 7 rows of column "F" is current row then it returns "Y". Which simply means if column "L" = "cOLUMN "F" - it returns "Y".
So in column "M" wherever it is marked as "Y" then that row is considered to have maximum range value.
Back to the Trade:
1st Stop Loss: 489.9 (high of NR7)
Trailing SL 1: 488.95 (Column = "M" generated "Y")
So at this point consider your stop loss as 1st Stop Loss: 489.9
Trailing SL 2: 482.2 (Column = "M" generated "Y")
So at this point consider your stop loss as Trailing SL 1: 488.95
Trailing SL 3: 486.5 (Column = "M" generated "Y")
So at this point consider your stop loss as Trailing SL 2: 482.2
it goes on like this untill 3:10 PM. If your SL is not hit till this time, then book profit in whatever price it trades during this time.