Support Board
Date/Time: Fri, 04 Jul 2025 23:01:58 +0000
Post From: Spradshet Formula Study
| [2020-05-06 13:29:34] |
| Sawtooth - Posts: 4232 |
|
The Spreadsheet Formula study uses Simple Alert syntax, despite its name. Here is the documentation for that format: Study/Chart Alerts And Scanning: Alert Condition Formula Format You'll need to create a persistent value of the Last price at the close of the bar's BARTIME, like this: =IF(BARTIME=TIMEVALUE("09:45:00"),C,ID2.SG1[-1]) where ID2 is the Spreadsheet Formula study. If you want the value of a study subgraph at the close of the bar's BARTIME: =IF(BARTIME=TIMEVALUE("09:45:00"),ID1.SG1,ID2.SG1[-1]) where the study and its subgraph are ID1.SG1 Date Time Of Last Edit: 2020-05-06 19:38:12
|