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
    Master

    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
    Master

    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 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
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

Multiple Column Screener Results Display


ProScreener: Market Scanners & Detection

New Reply
Author
author-avatar
OrionGold @oriongold Participant
Summary

This topic contains 4 replies,
has 3 voices, and was last updated by GraHal
6 years, 7 months ago.

Topic Details
Forum: ProScreener: Market Scanners & Detection
Language: English
Started: 08/04/2019
Status: Active
Attachments: 1 files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™