Multiple Column Screener Results Display

Viewing 5 posts - 1 through 5 (of 5 total)

Author

Posts
08/04/2019 at 7:48 AM #104110 quote

OrionGold
Participant

New

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.

08/04/2019 at 8:59 AM #104112 quote

robertogozzi
Moderator

Legend

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)

OrionGold thanked this post

08/04/2019 at 10:48 AM #104122 quote

GraHal
Participant

Master

Link to above idea added to here

Snippet Link Library

08/04/2019 at 11:16 AM #104130 quote
robertogozzi
Moderator

Legend
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")
```
OrionGold and Kovit thanked this post

x.jpg
08/04/2019 at 12:56 PM #104139 quote

GraHal
Participant

Master

Snippet Library link changed to the post above showing the code

Snippet Link Library

robertogozzi and Kovit thanked this post
Author

Posts