jjmcguire
22 posts
msg #157567
- Ignore jjmcguire |
9/12/2021 2:45:51 PM
Can someone please let me know why my filter show stocks where rsi71 = 0 doesn't work correctly? When rsi71 has a value of 1 in the table, I still get a record returned even though I have "show stocks where rsi71 = 0"
Thanks,
Jason
|
snappyfrog
731 posts
msg #157568
- Ignore snappyfrog
modified |
9/12/2021 2:58:40 PM
Run this and go back 1 day.
|
jjmcguire
22 posts
msg #157570
- Ignore jjmcguire |
9/12/2021 3:18:11 PM
Thanks Snappy! It is now working. I thought that Count returned only integers but apparently not.
|
snappyfrog
731 posts
msg #157571
- Ignore snappyfrog |
9/12/2021 3:28:24 PM
" I thought that Count returned only integers but apparently not."
It does return integers, so I set it to less than 1 (.99) so as not to show anything above 0.
|
nibor100
1,046 posts
msg #157583
- Ignore nibor100 |
9/14/2021 12:07:29 PM
I believe you guys have run into one of SF’s occasional anomalies between math symbols and English text.
If you change this line
show stocks where rsi71 = 0
To this
show stocks where rsi71 equals 0
I believe it will work as expected
Ed S.
|
snappyfrog
731 posts
msg #157585
- Ignore snappyfrog |
9/14/2021 12:21:48 PM
nibor100, you are correct again.
|