Variable Pivot (based on x mn interval)

[Phantom]

Hello,

I am trying to design a formula to calculate a variable pivot. Instead of using Daily or Weekly data, I want to use x mn data. I based my code so far on the Pivot Point Weekly formula but it seems there is something I didn't catch on the vIndex calculation.
Have a look at line 142 and line 145 in particular.

If someone could help me it would be wonderful.


Thanks,
Matt

[Phantom]

Weekly pivot formula I used

Here is the original formula I tried to modify...

[JayF]

Matt,

I would suggest using Chris Kryza's Pivot Console. You have the ability to use x-minute intervals for pivots with that EFS. Here's a screenshot showing a 60-minute pivot on a 3 minute chart.

[Phantom]

Jay,

Unfortunately Chris formula doesn't display the previous pivot points : only the existing one, and in addition to that there is a bug in the formula which doesn't display the variable pivot immediately but with a 1 bar lag.