Login Page - Create Account

Support Board


Date/Time: Wed, 12 Feb 2025 05:13:31 +0000



Post From: Spreadsheet - function to determine high/low value of session?

[2020-09-29 04:05:02]
mattvk - Posts: 32
I would like to add a function to determine if the close of a study bar is the highest (or lowest) of the current session. I'm testing a simple crossover strategy and would like to add an AND function with a check to see if the Cumulative Delta Bars study value has broken out on the corresponding candle. Is this possible?

I can manually put in a value during the session, but it's impossible to backtest.

Currently using K3: =AND(CROSSFROMBELOW(ID0.SG1@3:ID0.SG4@4, ID1.SG1@3:ID1.SG1@4), ID6.SG1@3 > n)

(n = manually input value)