Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 03:07:09 +0000



Post From: How to wait for 2 new bars before calculating a value in the Spreadsheet alert study?

[2024-09-18 20:35:18]
C_Money - Posts: 64
So I'm trying to use a custom ZigZag to give me higher highs and lower lows etc and grab the highest and lowest of those values in X bar range.

In column "O" I have
=ID35.SG6@3
returning a value between 0 and 4. When I get any value thats greater than or equal to 1, I want to wait for another 2 bars before getting the highest high and lowest low of a 5 bar range and plot the highest high in column "T" and the lowest low in column "U".

At the moment all I know how to do is get the immediate previous 5 highs and lows which.. is ok but not quite what I'm looking for.