SawtoothTrade
  • Home
  • Examples
  • Tips
  • Free Stuff
  • Links
  • Blog
  • Services
  • Contact
Picture
 SawtoothTrade

Picture

Understanding Alerts within spreadsheet studies

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 
  • Home
  • Examples
  • Tips
  • Free Stuff
  • Links
  • Blog
  • Services
  • Contact