When programming an alert in a column on a spreadsheet study, here are some things to remember:
1) The Draw Style cannot be Ignore.
2) If you are using the Spreadsheet Study study, you’ll need to put a formula on the Alerts tab to get an alert when a row 3 cell goes TRUE or >0, like this for K3:
In order for the price graph to be unaffected, you’ll also need to use a formula in a row 3 cell on the spreadsheet like this:
3) If you are using the Spreadsheet System/Alert study or the Spreadsheet System for Trading study, the alert is set in the study settings (the Alerts tab is rendered non-functional for these two studies).
Alerts for columns V-BR are combined with the setting labeled Column V-Z Alert. If you want to segregate alerts in individual columns V-BR, you’ll need to:
-set the V-Z Alert to No Alert.
-Include the ID# of the spreadsheet study in a formula on the Alerts tab of any other study (not the spreadsheet study), or on the Alerts tab in Chart Settings.
-like this for BR3: