Hi vonasi,

thanks a lot

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 !

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

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")

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