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