Adding Date Conditions to Highest(n) & Lowest(n)

• 09/27/2016 at 9:54 AM #13791
  liammaher11

  Hi

  Is it possible to add a date function into the highest & lowest code? To add a highest or lowest indicator between two sets of dates without defining the dates.

   

  For example:

  Pulling the highest high from an hourly chart for a 7 day period. Something like, highest(t)-(t-7), to pull the highest high between 27th sept (t) and 20th sept (t-7).

   

  The reason I am looking down this avenue is because I was using an hourly multiple to indicate daily levels, however this becomes a problem when the highest or lowest prices fall near the back end of the time frame, as the number of hours it would need to look at to capture “daily” levels would need to increase by 1 every hour. So if it used 115 hours of prices to capture 7 days of data, this would need to increase by 1 every hour in order to keep the full days pricing data.

   

  Any advice or solution would be greatly received.

   

  Many Thanks

   

  Liam

   

   

  

  liammaher11

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/27/2016 at 8:40 PM #13825
  Nicolas

  Why are you looking specifically to the hourly chart to catch the highest and lowest prices between 2 dates?

   

  

  Nicolas

  Keymaster

  Topics: 83

  Replies: 20906

  Been thanked: 4870 times
  09/28/2016 at 7:05 AM #13833
  liammaher11

  Hi Nicolas,

   

  To add levels derived from daily numbers to an hourly candle chart

   

  Many Thanks

  

  liammaher11

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/28/2016 at 7:09 AM #13834
  Nicolas

  So you are looking for daily high and low between 2 dates and show them on an hourly timeframe?

  (sorry for questions, I’m like a doctor, I want to give you the right treatment)😄

  

  Nicolas

  Keymaster

  Topics: 83

  Replies: 20906

  Been thanked: 4870 times
  09/28/2016 at 7:42 AM #13835
  liammaher11

   

  No prob at all!

  looking more for the highest high & lowest low between 2 dates and show them on hourly timeframe

   

   

  

  liammaher11

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/28/2016 at 1:12 PM #13853
  Nicolas

  Ok! So you don’t need to spot them on an hourly chart specifically, you can use OHLC of daily timeframe for that!

  Because the highest high of an hourly chart is exactly the same as the high of a day.

  So, you can code it like this:

   

  //store the highest high and lowest low during 7 days and then reset if day<>day[1] then count = count +1 endif if count=8 then count = 0 hh = close ll = close endif hh= max(hh,high) ll= min(ll,low) RETURN hh,ll

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

  //store the highest high and lowest low during 7 days and then reset if day<>day[1] then count = count +1 endif   if count=8 then count = 0 hh = close ll = close endif   hh= max(hh,high) ll= min(ll,low)   RETURN hh,ll

   

  

  Nicolas

  Keymaster

  Topics: 83

  Replies: 20906

  Been thanked: 4870 times
  09/28/2016 at 1:30 PM #13856
  liammaher11

  Thanks very much Nicolas, will try this out

  

  liammaher11

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
• Author
  Posts