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: =SG1 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: =IF(YourConditions),E3,0)
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: =ID1.SG60
