strange behavior with SMA crossing

• 09/07/2023 at 2:51 PM #220511
  benkunz

  Hi,

  here is my screener :

  TIMEFRAME(daily) SMA50 = average[50](close) SMA200 = average[200](close) C1=SMA50>SMA200 Crossing=1000 N=50 For i=0 to N-1 If SMA50[i]<SMA200[i] then Crossing=i Break EndIf Next // i want SMA50 above SMA200in the last 5 days C2=Crossing<5 Screener[C1 and C2](Crossing as "DaysBackCrossing")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  TIMEFRAME(daily) SMA50 = average[50](close) SMA200 = average[200](close)   C1=SMA50>SMA200   Crossing=1000 N=50 For i=0 to N-1 If SMA50[i]<SMA200[i] then Crossing=i Break EndIf Next // i want SMA50 above SMA200in the last 5 days C2=Crossing<5   Screener[C1 and C2](Crossing as "DaysBackCrossing")

  Basically, I want to get the stocks whose SMA50 went above SMA200 in the last 5 days.

  Most of my results are correct, but for some, i notice the SMA50 being below SMA200. Any idea why ? I’ll attach 2 screenshots for the same stock that was reported by the screener. one screenshot has historical data adjusted for dividends, and the other without the adjustment. In both cases, SMA200 is above SMA50.

  thanks

  

  benkunz

  Participant

  Topics: 23

  Replies: 69

  Been thanked: 2 times
  09/08/2023 at 8:17 AM #220538
  robertogozzi

  This will do:

  TIMEFRAME(daily) SMA50 = average[50](close) SMA200 = average[200](close) c1 = Sma50[5] < Sma200[5] c2 = (summation[5](Sma50 > Sma200) = 5) Screener[C1 and C2]

  1 2 3 4 5 6

  TIMEFRAME(daily) SMA50  = average[50](close) SMA200 = average[200](close) c1     = Sma50[5] < Sma200[5] c2     = (summation[5](Sma50 > Sma200) = 5) Screener[C1 and C2]

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16469

  Been thanked: 3643 times
  09/08/2023 at 7:53 PM #220599
  benkunz

  hi,

  it seems that this script returns the stocks where SMA50 went above SMA200 5 days ago, and not in the last 5 days, doesn’t it ?

  and this script returns 4 results on the NYSE. I’m attaching one of the 4 results where SMA50 is below SAM200. So it also seems to be doing the same weird thing as my original script. any idea why ?

  

  benkunz

  Participant

  Topics: 23

  Replies: 69

  Been thanked: 2 times
  09/08/2023 at 8:28 PM #220601
  JS

  Hi,

  Try this one:

  SMA Crossing

  TIMEFRAME(daily) SMA50 = average[50](close) SMA200 = average[200](close) xCrossing=0 For i=1 to 5 If SMA50[i] crosses over SMA200[i] then xCrossing=i Break EndIf Next C1=xCrossing=1 or xCrossing=2 or xCrossing=3 or xCrossing=4 or xCrossing=5 Screener[C1](xCrossing as "DaysBackCrossing")

  1 2 3 4 5 6 7 8 9 10 11 12 13

  TIMEFRAME(daily) SMA50  = average[50](close) SMA200 = average[200](close) xCrossing=0 For i=1 to 5 If SMA50[i] crosses over SMA200[i] then xCrossing=i Break EndIf Next C1=xCrossing=1 or xCrossing=2 or xCrossing=3 or xCrossing=4 or xCrossing=5   Screener[C1](xCrossing as "DaysBackCrossing")

  1 user thanked author for this post.

  benkunz

  

  JS

  Participant

  Topics: 22

  Replies: 1423

  Been thanked: 557 times
  09/08/2023 at 8:51 PM #220606
  robertogozzi

  No, my script checks only the last 5 bars, the 6th bar, bar 5, is checked not to be above.’

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16469

  Been thanked: 3643 times
  09/10/2023 at 7:10 PM #220660
  benkunz

  JS wrote:

  Hi,

  Try this one:

  SMA Crossing

  TIMEFRAME(daily)<br /> SMA50 = average[50](close)<br /> SMA200 = average[200](close)<br /> xCrossing=0<br /> For i=1 to 5<br /> If SMA50[i] crosses over SMA200[i] then<br /> xCrossing=i<br /> Break<br /> EndIf<br /> Next<br /> C1=xCrossing=1 or xCrossing=2 or xCrossing=3 or xCrossing=4 or xCrossing=5</p> <p>Screener[C1](xCrossing as “DaysBackCrossing”)

  1 2 3 4 5 6 7 8 9 10 11 12 13

  TIMEFRAME(daily) SMA50 = average[50](close) SMA200 = average[200](close) xCrossing=0 For i=1 to 5 If SMA50[i] crosses over SMA200[i] then xCrossing=i Break EndIf Next C1=xCrossing=1 or xCrossing=2 or xCrossing=3 or xCrossing=4 or xCrossing=5 Screener[C1](xCrossing as “DaysBackCrossing”)

  works great !

  1 user thanked author for this post.

  JS

  

  benkunz

  Participant

  Topics: 23

  Replies: 69

  Been thanked: 2 times
• Author
  Posts