Support Board
Date/Time: Wed, 19 Mar 2025 17:56:44 +0000
Post From: Spreadsheet formula help!
| [2022-10-25 13:23:35] |
| Sawtooth - Posts: 4186 |
|
In a Formula Column, create a persistent value of the price when the alert condition is TRUE (AA3<-3000), then in K3 compare it to the current price (E3) Here are some examples of persistent variables for a spreadsheet study: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values ...Like this, in P3: =IF(AlertConditionTrue,E3,IF(ReleaseCondition,0,P4)) then in K3: =AND(YourOtherEntryConditions,E3>P3,P3>0) Notes: -Create the persistent value with an event, then release it with another event, so it's ready for the next signal. -It's not possible to capture an intrabar value, only a close-of-bar value, so the alert condition must be true at close-of-bar. |