New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

Need help with simple "Scan" which Check Syntax says is correct but returns no results

Scan is: [Group is ETF] and [EMA(10, Williams %R (30)) > 20]

Scan returns no results ....... what am I not seeing that is causing my "no results" ....... Thanks.


Best Answer

  • gordgord admin
    Answer ✓
    Yes the scan engine can check for syntax errors and for things it doesn't know what to with. In this case it understands the formulas and there are numbers where it expects to see numbers. The following article explains the Williams indicator in detail.

    So in your case you are asking for a EMA10 of Williams %R (30) to be greater than 20. This is the problem the Williams oscillator is bounded between 0 and - 100. Thus the scan engine calculates and looks for values > 20 but it will never ever find any. So we just need to adjust the scan criteria to match what you are looking for, maybe as follows.

    and [EMA(10, Williams %R (30)) > -20]

    Note working with negative numbers can be confusing, just remember -19 is greater than - 20, and -21 is less than -20. Think of the value not the absolute magnitude of the number.


  • Thanks Gord ..... I knew that ..... just not used to dealing with it as a scan ...... knew it was going to be something in "plain sight" so to speak.
  • Yep, happens to all of us, me included. Just have to be a little methodical in checking and verifying the output of any scan.

    If you add clauses one at a time and quickly verify a few charts at each step, the problem clause usually jumps right out. Try adjusting some of the settings, sometimes its just not the right bull scan in a bear market, ie sometimes you get no hits for a reason.

    Often its just something like a > sign should actually be a < sign. Just check your logic.

    Often what we THINK we asked for, is actually quite different from what we ACTUALLY asked for.
Sign In or Register to comment.