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.

Looking for stocks within last 50 days with change > 70$

stokkcharts
stokkcharts ✭
in Scanning
Dear stockchart-fellows,
when I try to find stocks with 70 points changes in the last 50 days I use [(max(50, high)-min(50, low)) > 70]

This does not work. The answer is:
Could not parse "" located in the clause "(MAX(50, HIGH) - MIN(50, LOW)) > 70"

Is this a syntax problem? $ANET should be a stock the screener should find:

schrts.co/UjZzpenm

Thank you for input.

Best regards

Comments

  • markd
    markd mod
    edited September 2019
    You don't need the extra set of parens. If you want to group the max and min expressions, use brackets instead [ ] not ( ). Parentheses are reserved for functions.
  • stokkcharts
    stokkcharts ✭
    Thank you, with bracket it works.

Categories