Stock Percentile Measure

• 10/11/2016 at 5:59 PM #14727
  deletedaccount14122020

  Hello Nicolas,

  I’m currently working on a couple of new indicators which I will send to ProRealCode when completed. I’m struggling with a part of my code and was wondering if you could advise.

  What I want to do is this:

  I want to know how many times the current CLOSE is higher than the previous 180 days CLOSES expressed as a percentage.

  Example using the last four days only : Last previous days CLOSE 10, 10, 15, 20

  Todays CLOSE is 18. Therefore this beats the previous four closes 3 out of 4 = 75%

  Hope this makes sense and thanks in advance

  

  deletedaccount14122020

  Participant

  Topics: 24

  Replies: 36

  Been thanked: 2 times
  10/12/2016 at 10:55 AM #14756
  Nicolas

  You can easily count if a condition is true with a summation of this condition, like this:

  currentclose=Close count = SUMMATION[180](currentclose>close) ratio = count/180 return ratio

  1 2 3 4 5 6 7

  currentclose=Close   count = SUMMATION[180](currentclose>close)   ratio = count/180   return ratio

  Didn’t test it, should work as is. You’ll get a ratio here.

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  10/12/2016 at 4:01 PM #14780
  deletedaccount14122020

  Nicolas,

  Thanks for your reply however I cannot get this to work as per your code. Example using just 5 periods back in time. Today’s close is 39.11, last 5 days are 38.33, 38.90, 38.98, 38.08, 38.54. Todays price is therefore beating the previous 5 days a 100% of the time. The code produces 60%.

  I also had to change the currentclose to close[1] as just close produced zero values. I’m not running real time just 1 day delayed

  currentclose= Close [1]

  count = SUMMATION[5](currentclose>close)

  ratio = count/5

  return ratio

   

  Many thanks

  

  deletedaccount14122020

  Participant

  Topics: 24

  Replies: 36

  Been thanked: 2 times
  10/12/2016 at 4:07 PM #14783
  Nicolas

  Ok, try this instead:

  currentclose= Close count = SUMMATION[5](currentclose>close[1]) ratio = count/5 return ratio

  1 2 3 4 5 6

  currentclose= Close   count = SUMMATION[5](currentclose>close[1]) ratio = count/5   return ratio

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  10/15/2016 at 4:00 PM #14947
  deletedaccount14122020

  Hello Nicolas, Thanks for the follow up. I think this code is looking at the current close and the previous close every day for each SUMMATION value and presenting a value. What I’m trying to achieve is some code where the current close is always the latest value and it checks this value against the close on all the previous values (as defined in the SUMMATION line) and produces a count. Do you think I’m correct here or have I got my thinking wrong?

  Many thanks

  

  deletedaccount14122020

  Participant

  Topics: 24

  Replies: 36

  Been thanked: 2 times
  10/15/2016 at 4:13 PM #14948
  Nicolas

  The last code I gave you should do what you need. Because the code store the current close at line 1 and then make a summation of how much condition tested return true.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  10/15/2016 at 4:37 PM #14950
  deletedaccount14122020

  OK, got it, many thanks Nicolas

  

  deletedaccount14122020

  Participant

  Topics: 24

  Replies: 36

  Been thanked: 2 times
• Author
  Posts