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.

performance on a daily basis less than 5%

heidibaer
heidibaer ✭
in Scanning
Hi,
first of all, english is a foreign language to me, so please be kind.
I working on a scan to find stocks that perform on a daily basis less than 5%. I tried different things but did not come to a result. My latest try was this:
...
and [[today's low * 1,05] > [today's high]]
and [[yesterday's low * 1,05] > [yesterday's high]]
and [[2 days ago low * 1,05] > [2 days ago high]]
and [[3 days ago low * 1,05]> [3 days ago high]]
and [[4 days ago high] < [4 days ago low * 1,05]]
and [[5 days ago low * 1,05] > [5 days ago high]]
and [[6 days ago low * 1,05] > [6 days ago high]]
and [7 days ago low * 1,05 > 7 days ago high]
and [8 days ago high < 8 days ago low * 1,05]
and [9 days ago high < 9 days ago low * 1,05]
...

With these lines, some of the stocks should'nt be in the results, but are still in the results, for example BLKB had more than -10% performance 5 days ago. In my country we say "the issue is between my ears". I don't get it, what am I doing wrong.

Thank you for your help.
Heidi

Comments

  • markd
    markd mod
    Try 1.05 instead of 1,05.

    In other words, use a "." (period) instead of a "," (comma).

    Apparently, the syntax check does not catch that as an error, but it is.
  • heidibaer
    heidibaer ✭
    OMG, That's it. Thank you so much! Can't believe how easy this was.

Categories