Support Board
Date/Time: Wed, 12 Feb 2025 01:38:16 +0000
[Programming Help] - Spreadsheet - function to determine high/low value of session?
View Count: 600
| [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) |
| [2020-09-29 12:43:18] |
| ForgivingComputers.com - Posts: 1001 |
|
Add the study High/Low for Time Period, and set the times to match the session time. Then create two formulas that check if the close (E3) is above/below the study value.
|
| [2020-09-29 17:58:58] |
| mattvk - Posts: 32 |
|
Add the study High/Low for Time Period, and set the times to match the session time. Then create two formulas that check if the close (E3) is above/below the study value.
^This doesn't work because the high/low values change with each consecutive high/low in real time and all entries on the spreadsheet are updated with the same value. There is no historical record, e.g. "high/low for time period value on bar close" for each bar printed. Date Time Of Last Edit: 2020-09-29 18:00:00
|
| [2020-09-29 22:55:25] |
| ForgivingComputers.com - Posts: 1001 |
|
There is no historical record, e.g. "high/low for time period value on bar close" for each bar printed.
If you change the setting "Display High Low Incrementally" to Yes, you will see the values as they develop bar by bar. But if you are trading the last bar, the values will be the same with either setting. Date Time Of Last Edit: 2020-09-29 22:57:12
|
To post a message in this thread, you need to log in with your Sierra Chart account: