Support Board

Date/Time: Fri, 03 May 2024 20:57:20 +0000

Post From: Spreadsheet System for trading: can it be used for alert only?

[2014-12-11 00:05:54] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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.