Monthly pivot

• 05/29/2018 at 12:41 PM #71574
  jean.stiker

  Hi everyone,

  I looked for an answer before publishing my question, then sory  if someone already replied for a similar question.

  So, I try to have monthly pivot (code below), and to display via SCREENER.

  it don’t work, and display 0 (zero), i don’t know why !

  My questions are :

  1. do my monthly pivot calculation is right ?
  2. why it don’t detect anything, and display “0”?

   

  ====CODE=== ONCE LastMonthBarIndex = BarIndex // Monthly data setting ONCE monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] ONCE monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] ONCE monthlyC = DClose(1) ONCE monthlyO = Open[BarIndex - lastMonthBarIndex] ONCE mPivot = (monthlyO + monthlyH + monthlyL + monthlyC) / 4 If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] monthlyC = DClose(1) monthlyO = Open[BarIndex - lastMonthBarIndex] mPivot = (monthlyO + monthlyH + monthlyL + monthlyC) / 4 ENDIF c1 = mPivot > 1 SCREENER[c1] (mPivot AS "% dPivot")//SCREENER[c3 AND c4] (mPivot < wPivot AS "% dPivot")

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

  ====CODE===   ONCE LastMonthBarIndex = BarIndex // Monthly data setting ONCE monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] ONCE monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] ONCE monthlyC = DClose(1) ONCE monthlyO = Open[BarIndex - lastMonthBarIndex] ONCE mPivot = (monthlyO + monthlyH + monthlyL + monthlyC) / 4 If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] monthlyC = DClose(1) monthlyO = Open[BarIndex - lastMonthBarIndex] mPivot = (monthlyO + monthlyH + monthlyL + monthlyC) / 4 ENDIF c1 = mPivot > 1 SCREENER[c1] (mPivot AS "% dPivot")//SCREENER[c3 AND c4] (mPivot < wPivot AS "% dPivot")

  Thanks, and many green pips / ticks for everybody.

  Jean

  

  jean.stiker

  Participant

  Topics: 4

  Replies: 5

  Been thanked: 0 times
  05/29/2018 at 12:59 PM #71577
  Vonasi

  Please use the ‘Insert PRT Code button when putting code in your posts as it makes it far easier for others to read. I have tidied your post up for you 🙂

  Hopefully someone will be along with an answer soon….

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  05/29/2018 at 1:42 PM #71586
  jean.stiker

  Hi vonasi,

  thanks a lot

  

  jean.stiker

  Participant

  Topics: 4

  Replies: 5

  Been thanked: 0 times
  05/29/2018 at 3:44 PM #71605
  robertogozzi

  Practicing with the search utility won me this link https://www.prorealcode.com/prorealtime-indicators/daily-weekly-monthly-pivot-points/.

  You may win more!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  05/29/2018 at 10:02 PM #71649
  jean.stiker

  Hi and thanks for the answer…

  I forget to tell that it for a screener.

  I tried the solution in the link above , the screener display “0” for all products selected !

  I don’t really know what is wrong !

  screener Monthly pivot

  Once lastMonthBarIndex = 0 Once monthlyH = undefined Once monthlyL = undefined Once mPivot = undefined If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] LastMonthBarIndex = BarIndex mPivot = (Open + monthlyH + monthlyL + Close[1]) / 4 ENDIF SCREENER[c1 AND c2 OR c3 AND c4] (mPivot AS "% dPivot")

  1 2 3 4 5 6 7 8 9 10 11

  Once lastMonthBarIndex = 0 Once monthlyH = undefined Once monthlyL = undefined Once mPivot = undefined If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] LastMonthBarIndex = BarIndex mPivot = (Open + monthlyH + monthlyL + Close[1]) / 4 ENDIF SCREENER[c1 AND c2 OR c3 AND c4] (mPivot AS "% dPivot")

  thans for everything

  Jean

  

  jean.stiker

  Participant

  Topics: 4

  Replies: 5

  Been thanked: 0 times
  05/29/2018 at 11:58 PM #71659
  robertogozzi

  Screeners are not applicable to MONTHLY TF, Weekly is the highest one. But you can calculate monthly pivots and use them in a lower TF.

  The screener is missing variable C1, C2, C3 and C4.

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  05/30/2018 at 11:19 AM #71684
  jean.stiker

  Hi RobertoGozzi, thanks for the answer,

  effectively, I posted the old code, here is the new :

  Once lastMonthBarIndex = 0 Once monthlyH = undefined Once monthlyL = undefined Once mPivot = undefined If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] LastMonthBarIndex = BarIndex mPivot = (Open + monthlyH + monthlyL + Close[1]) / 4 ENDIF c1 = mPivot < High SCREENER[c1] (mPivot AS "% mPivot")

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

  Once lastMonthBarIndex = 0 Once monthlyH = undefined Once monthlyL = undefined Once mPivot = undefined If month <> Month[1] then monthlyH = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyL = Lowest[BarIndex - lastMonthBarIndex](Low)[1] LastMonthBarIndex = BarIndex mPivot = (Open + monthlyH + monthlyL + Close[1]) / 4 ENDIF c1 = mPivot < High SCREENER[c1] (mPivot AS "% mPivot")

  Ok, there is no mean to have directly the monthly pivot, but the code above allow to calculate it (i’m not sure for the open price). once the monthly pivot calculated, i would like to display it with the last code line (SCREENER[c1] (mPivot As “% mPivot”).

  But instead I only have “0” for all rows, how can i correct that ?

  I hope I’m enough clear…

  don’t hesitate if I can clerify more.

  Thanks and cheers

  Jean

   

  

  jean.stiker

  Participant

  Topics: 4

  Replies: 5

  Been thanked: 0 times
  05/30/2018 at 3:00 PM #71700
  robertogozzi

  I tried this code as an indicator and it works perfectly (see screenshot):

  Monthly PIVOT indicator

  If Month<>Month[1] then monthlyHigh = Highest[BarIndex - lastMonthBarIndex](High)[1] monthlyLow = Lowest[BarIndex - lastMonthBarIndex](Low)[1] lastMonthBarIndex = BarIndex monthlyPivot = (Open + monthlyHigh + monthlyLow + Close[1]) / 4 Endif x = high > monthlyPivot y = -(low < monthlyPivot) Return x OR y,0

  1 2 3 4 5 6 7 8 9

  If Month<>Month[1] then    monthlyHigh = Highest[BarIndex - lastMonthBarIndex](High)[1]    monthlyLow  = Lowest[BarIndex - lastMonthBarIndex](Low)[1]    lastMonthBarIndex = BarIndex    monthlyPivot = (Open + monthlyHigh + monthlyLow + Close[1]) / 4 Endif x = high > monthlyPivot y = -(low < monthlyPivot) Return x OR y,0

  While the same code as a screener on a 4-hour TF does not return any valid scan for HIGH > monthlypivot or LOW < monthlypivot.

  I guess it may be that ProScreener can only scan at most 255 bars (the current one + the previous 254), while highest and lowest use more!

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  05/30/2018 at 3:02 PM #71703
  robertogozzi

  The solution could be to use it as an indicator and then code a screener that reads the values returned by the indicator.

  I’ll have a try.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  05/30/2018 at 3:26 PM #71711
  robertogozzi

  It doesn’t work either.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
• Author
  Posts