Need watchlist for close where the price crosses below a 10 period SMA

[craigjjmorrison]

In the code below, I tried hard to isolate the close for the bar during which the price first crossed below the SMA. With every attempt to write this, the answer I get seems to be pulled from a hat. In some tests, I have to go back several days just to determine where the return falls within the stock's daily price range.

This code is in a watchlist column with a five-minute aggregation.

def FloorIsOpen = SecondsFromTime(930) >= 0 and SecondsTillTime(1600) >= 0;
def SMA10 = SimpleMovingAvg(Close,10);
def Top = Max(Open,Close);
def SMACross = if !FloorIsOpen[1] and FloorIsOpen then 0 else if FloorIsOpen and SMACross[1] == 0 and crosses(Top,SMA10,CrossingDirection.BELOW) then Close else SMACross[1];

Plot X = SMACross;

 

[rad14733]

In the code below, I tried hard to isolate the close for the bar during which the price first crossed below the SMA. With every attempt to write this, the answer I get seems to be pulled from a hat. In some tests, I have to go back several days just to determine where the return falls within the stock's daily price range.

This code is in a watchlist column with a five-minute aggregation.

def FloorIsOpen = SecondsFromTime(930) >= 0 and SecondsTillTime(1600) >= 0;
def SMA10 = SimpleMovingAvg(Close,10);
def Top = Max(Open,Close);
def SMACross = if !FloorIsOpen[1] and FloorIsOpen then 0 else if FloorIsOpen and SMACross[1] == 0 and crosses(Top,SMA10,CrossingDirection.BELOW) then Close else SMACross[1];

Plot X = SMACross;

You may be making it more difficult than needed... Either that or we need more details...

close crosses below Average(close, 10);
close[1] crosses below Average(close, 10)[1];

This code will trigger each time close crosses below the SMA10... You can also use an offset to test if the cross was in the previous candle by using the second example... I would recommend the first example... That's all the code needed for the Scan to return those results... For only between 9:30 and 16:00 just leave Extended Hours unchecked...