greatspotter@gmail.com 5 posts msg #147933 - Ignore greatspotter@gmail.com |
5/27/2019 10:23:31 AM
When I run the below code I am finding that it is not working off of the upper bollinger band. It will not add the upper bollinger band column or will it show stocks that penetrate the upper bollinger band. Instead the results show stocks that crossed above the mid bollinger band.
Can anyone show me my mistake?
show stocks where high crossed above Upper Bollinger Band(20,2)
and high above the EMA(50)
and stocks high below MA(200)
and Average Volume(30) is above 500000
and price is greater than $10
and market is not AMEX
and market is not OTCBB
and market is not ETF
add column EMA(50)
add column Upper Bollinger Band(20,2)
|
KSK8 561 posts msg #147934 - Ignore KSK8 |
5/27/2019 1:35:08 PM
It must be a glitch, here's the fix though:
|
nibor100 1,044 posts msg #147938 - Ignore nibor100 |
5/27/2019 7:09:23 PM
@greatspotter,
Regarding your post I'm not quite following some of your comments so I am hoping you will clarify so we can better assist you:
a. "When I run the below code I am finding that it is not working off of the upper bollinger band"
If I put your filter code in a new filter box in SF and run it; I get 3 stocks whose high all are above the upper bollinger band so I am not quite sure what you meant by that phrase.
b. ". It will not add the upper bollinger band column" .
SF is not adding that column because when it runs into the word "upper" it doesn't know which of its indicators that use that word to go to (for some unknown coding reason)
c. " or will it show stocks that penetrate the upper bollinger band"
I thought you wanted stocks whose high had penetrated the upper bollinger band so this should be good for you?
d. ." Instead the results show stocks that crossed above the mid bollinger band"
When I add the mid bollinger band to your filter or the simple Ma(20) line to your filter, for all 3 stock results they had crossed above the mid bollinger band days earlier than last Friday so I am uncertain what you meant by that phrase either.
Thanks,
Ed S.
|
greatspotter@gmail.com 5 posts msg #147941 - Ignore greatspotter@gmail.com |
5/28/2019 8:07:52 AM
Thanks for all your help KSK8 and Ed S.
Everything works great now. Really appreciate the help.
Brett
|