Support Board
Date/Time: Mon, 12 May 2025 22:00:13 +0000
Post From: Spreadsheet System for trading: can it be used for alert only?
| [2014-12-11 00:05:54] |
| Sawtooth - Posts: 4214 |
|
With 2&3, it's probably not necessary, buy I would leave K,L,M,N empty only as an extra precaution. You can use your formula in any Formula Column O-U, then set the Alert for that column in the Spreadsheet Study settings. If you also want an arrow, use this formula, e.g. a long entry: =IF(AND(AE3>AB3,E3>B3,AT3>AU3,E3>AI3,E3>AJ3),D3,0) then set the Draw Style for that column subgraph to Arrow Up. A non-zero value will also trigger an alert. |