Multiple Column Screener Results Display

• 08/04/2019 at 7:48 AM #104110
  OrionGold

  G’day

  Was looking to see if its possible for the proscreener to display more that 1 column

  For example i want the proscreener to display a column both  values,  the highest high over 20 periods and lowest low over 20 periods in addition to my filter criteria (RSI < 30).

  I only to seem be able to display one column.

  Assistance is appreciated.

  Cheers.

  

  OrionGold

  Participant

  Topics: 1

  Replies: 0

  Been thanked: 0 times
  08/04/2019 at 8:59 AM #104112
  robertogozzi

  ProScreener only returns one column.

  A workaround would be combining the two values into a single one.

  You can use a two-digit number, 99, with the leftmost digit representing highest highs and the rightmost one the lowest lows.

  If your scanned instrument has a highest high set the leftmost digit to 1 or to 9 if it is not (you cannot use zero because leading 0’s are dropped), if it has a lowest low set the rightmost digit to 1, or 9 if it isn’t.

  This grants 4 combinations:

  99 – no match (set it to 0 to avoid being returned)

  19 – highest high

  91 – lowest low

  11 – both (very unlikely)

  1 user thanked author for this post.

  OrionGold

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17134

  Been thanked: 4031 times
  08/04/2019 at 10:48 AM #104122
  GraHal

  Link to above idea added to here

  Snippet Link Library

  

  GraHal

  Participant

  Topics: 212

  Replies: 8785

  Been thanked: 2185 times
  08/04/2019 at 11:16 AM #104130
  robertogozzi

  There’s the code:

  // Result hh ll // 9 9 (no match) // 1 9 // 9 1 // 1 1 // MyRsi = Rsi[14](close) c1 = MyRsi < 30 hh = (high = highest[20](high)) ll = (low = lowest[20](low)) x = 90 IF hh THEN x = 10 ENDIF IF ll THEN x = x + 1 ELSE x = x + 9 ENDIF IF x = 99 THEN x = 0 ENDIF Result = x IF c1 = 0 THEN Result = 0 ENDIF SCREENER[Result](Result AS "HL")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

  // Result hh ll //        9   9   (no match) //        1   9 //        9   1 //        1   1 // MyRsi = Rsi[14](close) c1    = MyRsi < 30 hh    = (high = highest[20](high)) ll    = (low = lowest[20](low)) x     = 90 IF hh THEN    x = 10 ENDIF IF ll THEN    x = x + 1 ELSE    x = x + 9 ENDIF IF x = 99 THEN    x = 0 ENDIF Result = x IF c1 = 0 THEN    Result = 0 ENDIF SCREENER[Result](Result AS "HL")

   

  2 users thanked author for this post.

  Kovit, OrionGold

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17134

  Been thanked: 4031 times
  08/04/2019 at 12:56 PM #104139
  GraHal

  Snippet Library link changed to the post above showing the code

  Snippet Link Library

  2 users thanked author for this post.

  Kovit, robertogozzi

  

  GraHal

  Participant

  Topics: 212

  Replies: 8785

  Been thanked: 2185 times
• Author
  Posts