Unexpected returns in screen

• 07/19/2023 at 8:47 PM #217903
  sgrech

  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

   

  

  sgrech

  Participant

  Topics: 14

  Replies: 27

  Been thanked: 1 time
  07/20/2023 at 9:39 AM #217918
  Nicolas

  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 🙂

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  07/20/2023 at 3:00 PM #217946
  sgrech

  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")

  1 2 3 4 5 6 7 8 9 10

  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

  

  sgrech

  Participant

  Topics: 14

  Replies: 27

  Been thanked: 1 time
  07/21/2023 at 3:06 PM #217989
  JS

  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)

  

  JS

  Participant

  Topics: 26

  Replies: 1716

  Been thanked: 779 times
  07/23/2023 at 8:27 AM #218020
  sgrech

  “when markets are not closed”

  I dont understand, why do you say this, this is a closing price scan?

  

  sgrech

  Participant

  Topics: 14

  Replies: 27

  Been thanked: 1 time
  07/23/2023 at 9:39 AM #218026
  JS

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

  

  JS

  Participant

  Topics: 26

  Replies: 1716

  Been thanked: 779 times
  07/28/2023 at 10:25 AM #218251
  sgrech

  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.

  

  sgrech

  Participant

  Topics: 14

  Replies: 27

  Been thanked: 1 time
• Author
  Posts