Screener quarter bar

• 02/25/2018 at 5:31 PM #63899
  mmichael

  Hello,

  I am trying to do a screener to compare the quarter high / low with the previous quarter.

  I saw I can use this code for the previous quarter

  trimH=max(trimH,high) trimL=min(trimL,low) If openMonth<>openMonth[1] then if openmonth=4 or openmonth=7 or openmonth=10 or openmonth=1 then trimestrialH=trimH trimestrialL=trimL trimL=close*100 trimH=0 endif Endif

  1 2 3 4 5 6 7 8 9 10

  trimH=max(trimH,high) trimL=min(trimL,low) If openMonth<>openMonth[1] then if openmonth=4 or openmonth=7 or openmonth=10 or openmonth=1 then trimestrialH=trimH trimestrialL=trimL trimL=close*100 trimH=0 endif Endif

  1/ How can I do to get current quarter H/L?

  2/ How to get the preceding quarter H/L? (the one N-2)

  I believe this could be easier if we have a quarterly timeframe. Is there a solution?

  Many thx

  

  mmichael

  Participant

  Topics: 4

  Replies: 36

  Been thanked: 4 times
  05/09/2020 at 5:00 AM #130685
  efex77

  Hello,

   

  Did you get a workaround for this?

  I am need to calculate quarterly pivot points and also don’t know how to get previus quarter high, low and close.

  Any thoughts?

   

  Regards

  

  efex77

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
  05/09/2020 at 8:15 AM #130692
  Vonasi

  Simply store the last value in a different set of variables before storing the latest values. You can also reset the trimL to the high rather than to close*100 which is more guaranteed to work on every instrument.

  trimH=max(trimH,high) trimL=min(trimL,low) If openMonth<>openMonth[1] then if openmonth=4 or openmonth=7 or openmonth=10 or openmonth=1 then trimestrialH2=trimestrialH trimestrialL2=trimestrialL trimestrialH=trimH trimestrialL=trimL trimL=high trimH=0 endif Endif

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

  trimH=max(trimH,high) trimL=min(trimL,low) If openMonth<>openMonth[1] then if openmonth=4 or openmonth=7 or openmonth=10 or openmonth=1 then trimestrialH2=trimestrialH trimestrialL2=trimestrialL trimestrialH=trimH trimestrialL=trimL trimL=high trimH=0 endif Endif

   

  1 user thanked author for this post.

  mmichael

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  05/10/2020 at 5:18 AM #130823
  mmichael

  Hello Vonaci,

  Thank you for  reactivating this topic.

  As reminder, The idea is to build a screener for quarter bars, starting with the instruction “timeframe (Monthly) as workaround.

  Previous code allows to retrieve current high and past high only.

  Is there a way to use instructions like

  • trimestrialH[i], trimestrialL[i], trimestrialC[i], trimestrialO[i]

  to retrieve the high, low, close and open of the bar number i in the past?

  Many thanks in advance.

  

  mmichael

  Participant

  Topics: 4

  Replies: 36

  Been thanked: 4 times
  05/10/2020 at 11:04 AM #130860
  Vonasi

  You could use something like this code that I’ve stolen from my OHLC MTF indicator.

  lookback = 2 //How many quarters back to get results from if openmonth <> openmonth[1] and (openmonth = 1 or openmonth = 4 or openmonth = 7 or openmonth = 10) then quarterindex = quarterindex + 1 quarterhigh = 0 quarterlow = close quarteropen = open quarterclose = close if quarterindex > lookback then for j = 1 to barindex if quarterindex[j] = quarterindex - lookback then myquarterhigh = quarterhigh[j] myquarterlow = quarterlow[j] myquarteropen = quarteropen[j] myquarterclose = quarterclose[j] break endif next endif endif quarterhigh = max(quarterhigh,high) quarterlow = min(quarterlow,low) quarterclose = close return myquarterhigh, myquarterlow, myquarterclose, myquarteropen

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

  lookback = 2 //How many quarters back to get results from   if openmonth <> openmonth[1] and (openmonth = 1 or openmonth = 4 or openmonth = 7 or openmonth = 10) then quarterindex = quarterindex + 1 quarterhigh = 0 quarterlow = close quarteropen = open quarterclose = close if quarterindex > lookback then for j = 1 to barindex if quarterindex[j] = quarterindex - lookback then myquarterhigh = quarterhigh[j] myquarterlow = quarterlow[j] myquarteropen = quarteropen[j] myquarterclose = quarterclose[j] break endif next endif endif quarterhigh = max(quarterhigh,high) quarterlow = min(quarterlow,low) quarterclose = close   return myquarterhigh, myquarterlow, myquarterclose, myquarteropen

   

  1 user thanked author for this post.

  mmichael

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
• Author
  Posts