Support Board
Date/Time: Thu, 01 May 2025 23:24:03 +0000
Post From: Alert on past condition
| [2025-02-20 21:10:59] |
| John - SC Support - Posts: 39605 |
|
In that formula the Low of a bar at some time today would have had to cross the Initial Balance Low line to get a "True" (non-zero) result. Did that occur at all today? Keep in mind that this could apply to the overnight session as well, so depending on how you have your Initial Balance setup, a crossing of the low of a bar with the IB Low will give a non-zero result that will carry forward until the next day starts and then it waits for that crossover to occur again. If you have the crossing occurring and you are not getting a non-zero value for the Spreadsheet Formula, then we would need to see your chart where this is occurring. We have attached an image of what you should see when this occurs. Note the jump in the Spreadsheet Formula study from zero at 08:51 to one at 08:52 where the crossover occurs. Note that the Crossover is going to give either a -1, 0, or 1 result, depending on whether the crossover is from below, does not occur, or is from above. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSOVER_Function There are other crossing options as noted near the link just give above if you want to only look for a crossing in a certain direction. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
 ESH25-CME[M] 1 Min #1 2025-02-20 15_10_32.997.png / V - Attached On 2025-02-20 21:10:49 UTC - Size: 111.68 KB - 26 views |