Unexpected returns in screen

Viewing 7 posts - 1 through 7 (of 7 total)

Author

Posts
07/19/2023 at 8:47 PM #217903 quote

sgrech
Participant

Junior

I have a few questions here on what is a very simple scan (screenshot attached)

1. Why is the % fall column showing assets with a value less than 1.1?

2. Why are assets with a volume of zero not being excluded?

3. Last but not least, I am searching for assets where close of previous period is > the upper bollinger band of the previous period, for some reason some of the assets returned this is clearly not the case?

Many thanks

Simon

Capture23.jpg

07/20/2023 at 9:39 AM #217918 quote

Nicolas
Keymaster

Legend

Are you sure the results window is displaying the results from this code and for the monthly timeframe?

Please copy/paste the code in your next reply, so I could try to replicate the issue 🙂

07/20/2023 at 3:00 PM #217946 quote
sgrech
Participant

Junior
```
TIMEFRAME(Monthly)
bb1 = BollingerUp[20](close)

c1 = (close[1] > bb1[1])
c2= ((high[1]/low) >1.1)
c3 = (volume > 0)



Screener[c1 and c2 and c3](high[1]/low as "% fall")
```
This is being run for UK Stocks
07/21/2023 at 3:06 PM #217989 quote
JS
Participant

Master
Hi Simon,

I tried your screener and it works the way it’s supposed to work…
1. %fall anything above 1.1
2. Volume everything above 0
I think you should try again… (when markets are not closed)

Schermafbeelding-2023-07-21-om-15.59.51.png
07/23/2023 at 8:27 AM #218020 quote

sgrech
Participant

Junior

“when markets are not closed” I dont understand, why do you say this, this is a closing price scan?

07/23/2023 at 9:39 AM #218026 quote

JS
Participant

Master

I say this because, when the market is closed, some calculations (dates) are not performed as you would expect…

07/28/2023 at 10:25 AM #218251 quote

sgrech
Participant

Junior

Some answers to my own questions: 2. Why are assets with a volume of zero not being excluded? Added this TIMEFRAME(Daily) c3 = volume > 0 1. Why is the % fall column showing assets with a value less than 1.1? 3. Last but not least, I am searching for assets where close of previous period is > the upper bollinger band of the previous period, for some reason some of the assets returned this is clearly not the case? Issues with both 1 and 3 are partly due to a misunderstanding. I thought that close[1] would provide the data for the 2 candle from the right i.e. candle before the current one. This is not the case for monthly charts. Close[1] is current candle minus 2 (third from right). I guess that this is because the current candle does not close until end of Monday (31st July). I need to find the low of the current (unclosed) monthly candle – how can I do that? Also the formula was somewhat incorrect for 1.
Author

Posts