Possible to do calculations on Screener Results

• 02/01/2019 at 8:05 PM #90276
  bhav63

  Hi All,

  Is it possible to do various calculations on results returned by screener?

  So for example, if I have a custom list to scan which contains the 30 Dax Index stocks, and I want to check simply the number of stocks that are up today and the number that are down today. I use something like:

  yesterdayClose = Dclose(1) priceCurrent = close SCREENER(priceCurrent > yesterdayClose)

  1 2 3

  yesterdayClose = Dclose(1) priceCurrent = close SCREENER(priceCurrent > yesterdayClose)

  If I run the screener say at 9am and there are 10 stocks higher than yesterday and 20 stocks lower than yesterday, this screen should return a list of the 10 stocks that are higher today. Now is there a way to get this value in the code, so can I somehow get the value that 10 are up and 20 down somehow in the screener code? Is this possible?

  Any help is greatly appreciated.

  Thanks

  

  bhav63

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
  02/04/2019 at 10:50 AM #90385
  Nicolas

  No because the screener returns individual test and can’t be compared to any other result produced before or after.

  I think you might have made a mistake in your code? condition of a screener must be in brackets, the sorting criteria is in parenthesis, so actually the screener should return all stocks but sorting them with a “1” for up stocks and a “0” for down ones.

  yesterdayClose = Dclose(1) priceCurrent = close SCREENER[priceCurrent > yesterdayClose]

  1 2 3

  yesterdayClose = Dclose(1) priceCurrent = close SCREENER[priceCurrent > yesterdayClose]

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/04/2019 at 11:37 AM #90399
  bhav63

  Hi Nicolas,

  Thank you for getting back to me. Much appreciated.

  I had a feeling that what I was trying to do could not be done via the screener. You are absolutely correct about the parentheses in the code, it was my mistake. I am very new to prorealcode.

  Is there any way to achieve what I’m trying to do? Perhaps code it as an indicator – is it possible to create the indicator and reference each of the 30 stocks in the code, get the closing values and perform the calculation that way?

  Many thanks.

  

  bhav63

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
• Author
  Posts