Hi All,

Before I wrote this I went through this forum, but found nothing.

I’m working on the trading system based on Pivot points. And it looks like I just crashed the wall on something what looks very simple.

When working with Pivots there is always a problem that the most recent pivot is “not stable” as long it is not confirmed. In my particular case it seems like the best confirmation of pivot is next pivot. I mean pivot (n-1) is confirmed when pivot (n) is formed.

To find and plot pivots I use good, old add-on Power Pivots Plus.

And here comes my problem.
I would like to plot pivot (n-2) but NOT from the moment it was formed but from the moment pivot(n-1) (confirmation) is formed. Then pivot (n-1) starting when pivot (n) is formed, etc.

I tried to use Valuewhen function and counting bars for this job. Both didn’t work. It might be wrong logic or coding or both.

I’m not sure if the above is clear and understandable, I can’t think of anything better at the moment. English is not my first language .

But I will answer all questions, if asked

I would very much appreciate help.

Mark

Problem solved. I took a "day off" and with fresh aproach I solved the problem.