How to sort by a custom value in my screener?

• 12/02/2020 at 9:18 PM #152441
  telboy

  having difficulty sorting my screener results properly

  i have defined the timeframe:

  TIMEFRAME(daily)

  1	TIMEFRAME(daily)

   

  i have defined the variable I want to sort by:

  proc = ROC[20](close)

  1	proc = ROC[20](close)

   

  I am happy with the screener test output but the results are not sorted by the proc properly as when I work down the list the proc is not in any sort of order for individual shares

  screener[test1] SORT BY (proc)

  1	screener[test1] SORT BY (proc)

   

  anyone any thoughts about where im going wrong?

   

  MODERATORS COMMENT: Always use the ‘Insert PRT Code’ button when posting code. Your post has been edited.

  

  telboy

  Participant

  Topics: 11

  Replies: 5

  Been thanked: 0 times
  12/02/2020 at 9:36 PM #152442
  robertogozzi

  You can write:

  screener[test1](proc as "criterion")

  1	screener[test1](proc as "criterion")

  you can use the CRITERION column to sort data.

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16477

  Been thanked: 3643 times
  12/03/2020 at 10:12 AM #152463
  telboy

  thanks robertogozzi – that works for sorting the criteria

   

  another question please

  the value for the ROC(20)(close) i get in the screener list does not correspond to the ROC(20) line on my chart – why would that be?

  I have specified timeframe(daily) in the screener and the ROC on the graph is selected to 20 units – but the results are wildly different

  

  telboy

  Participant

  Topics: 11

  Replies: 5

  Been thanked: 0 times
  12/03/2020 at 11:21 AM #152468
  robertogozzi

  Actually I don’t know why there are such discrepancies.

  RSI returns correct data, apart from some decimals at times.

  I suggest that you open a ticket for assistance hitting Ctrl+M from the platform.

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16477

  Been thanked: 3643 times
• Author
  Posts