Support Board
Date/Time: Fri, 14 Mar 2025 22:36:47 +0000
Crossover Spreadsheet Trading.
View Count: 517
| [2022-07-01 21:23:47] |
| Alex Q - Posts: 112 |
|
Hey guys. I'm trying to backtest a strategy and I'm running into a wall: I'm using the Spreadsheet System for Trading study. I am attempting to test a crossover of High/Low for time period. To achieve this I am using "high low for time period - extended".. This is plotting high and low of first 30 minutes. For this example I am attempting to test an upside breakout of the 30 minute opening range. In the buy entry column I am using the formula =crossfrombelow(C, ID6.SG1@3) ID6.SG1 is the HIGH subgraph of the "high/low for time period - extended" study. There are no syntax errors returned, however I am not getting any trades triggered, even when the last price cross over the high of the designated time period. I have also tried =crossfrombelow(C,Q3) Either way there are no trades being triggered. |
| [2022-07-02 13:39:11] |
| Sawtooth - Posts: 4182 |
|
The CROSSFROMEBELOW and CROSSFROMABOVE functions require a range comparison when used on a spreadsheet; Also, spreadsheet syntax needs to be used. (Bar close is E3, not C.) =CROSSFROMBELOW(E3:E4,ID6.SG1@3:ID6.SG1@4) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMABOVE_Function |
To post a message in this thread, you need to log in with your Sierra Chart account: