Hello,
I have a formula for Weekly Fair Value Pivot and I plotted it on Daily chart but this formula is only showing a plot for previous week’s pivot dated: (April 3-6th) , and not this current week’s pivot that just ended:(April 10-14,2023)
How do I fix it so that I can get a Weekly Pivot plot as soon as Friday of that same week closes?
Please see my current formula that I need help with:
// POINT PIVOT HEBDOMADAIRE
IF dayofweek < dayofweek[1] THEN
weekhigh = prevweekhigh
weeklow = prevweeklow
weekclose = prevweekclose
prevweekhigh = high
prevweeklow = low
ENDIF
prevweekhigh = max(prevweekhigh, high)
prevweeklow = min(prevweeklow, low)
prevweekclose = close
PPWeek = (weekhigh + weeklow + weekclose) / 3
RETURN PPWeek COLOURED(50,50,220) AS”Pivot Week”