Support Board
Date/Time: Mon, 29 Apr 2024 03:15:17 +0000
Post From: 2 conditions, alerted only once each
[2021-09-23 13:07:16] |
Sawtooth - Posts: 3982 |
Add the Spreadsheet System/Alert study: On the Settings and Inputs tab (not the Alerts tab): - Give it a name in the Spreadsheet Name field. - Check 'Hide Study'. - Set the 'Alert Only Once Per Bar' to Yes. - If required, set 'Reset Condition On New Bar' to Yes. - Set the Column K Alert for the ID9 MA. - Set the Column L Alert for the ID10 MA. Click OK and OK. Formulas on the spreadsheet: Cell H1: Enable alerts: (1/0) Cell H2: 1 Cell K3: =AND($H$2,C3>=ID9.SG1@3,D3<=ID9.SG1@3) Cell L3: =AND($H$2,C3>=ID10.SG1@3,D3<=ID10.SG1@3) To apply this to other charts: - 'Save Single' a Study Collection of this study after checking "Prompt To Remove Existing Studies'. - Apply the Study Collection to each chart, choosing No when asked to remove existing studies. - Then on each chart's sheet, put this formula in H2: =Sheet1!H2 where the original sheet was Sheet1; edit as required. This assumes all charts have MAs at ID9 and ID10. Notes: - H1 is the title for H2. - You only edit H2 on the original sheet#. - To disable all alerts, edit H2 to 0. - Any non-zero value in H2 will enable all alerts. - The original Sheet# will be at the top of the list of sheets in the dropdown in the upper left corner. - By default, the Sheet# corresponds to the Chart#. - Be sure to use the Study Collection you made so that the correct settings are applied to each. - Ignore the default column titles in K2-N2. You can edit these on the original sheet# if you want. Date Time Of Last Edit: 2021-09-23 13:19:07
|