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 Capture23.jpg
    07/20/2023 at 9:39 AM #217918 quote
    Nicolas
    Keymaster
    Master

    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
    Veteran

    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)

    Scherm­afbeelding-2023-07-21-om-15.59.51.png Scherm­afbeelding-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
    Veteran

    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
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.

Unexpected returns in screen


ProScreener: Market Scanners & Detection

New Reply
Author
author-avatar
sgrech @sgrech Participant
Summary

This topic contains 6 replies,
has 3 voices, and was last updated by sgrech
2 years, 7 months ago.

Topic Details
Forum: ProScreener: Market Scanners & Detection
Language: English
Started: 07/19/2023
Status: Active
Attachments: 2 files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™