Widest range from high to low last 20 days

• 12/14/2019 at 9:09 PM #114897
  Dr Manhattan

  How can I find the widest range from high to low of any the previous 20 days from now? any ideas? it should involve <code>range</code> and <code>summation</code>, or? anyone know how to write it?

  

  Dr Manhattan

  Participant

  Topics: 13

  Replies: 28

  Been thanked: 1 time
  12/14/2019 at 9:20 PM #114899
  robertogozzi

  There you go

  x = highest[20](range)

  1	x = highest[20](range)

   

  1 user thanked author for this post.

  Dr Manhattan

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16465

  Been thanked: 3641 times
  12/14/2019 at 9:23 PM #114900
  Vonasi

  bigrange = high = low for a = 1 to 19 bigrange = max(bigrange,high[a] - low[a]) next

  1 2 3 4 5

  bigrange = high = low   for a = 1 to 19 bigrange = max(bigrange,high[a] - low[a]) next

   

  1 user thanked author for this post.

  Dr Manhattan

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  12/14/2019 at 9:41 PM #114901
  Dr Manhattan

  Aaaah! always so clear when the answer is there!! 🙂 thanks

  

  Dr Manhattan

  Participant

  Topics: 13

  Replies: 28

  Been thanked: 1 time
  12/14/2019 at 10:11 PM #114903
  GraHal

  Both codes added as Log 189 and 190 here

  Snippet Link Library

  

  GraHal

  Participant

  Topics: 204

  Replies: 8397

  Been thanked: 2039 times
• Author
  Posts