Sierra Chart Alert Formula Question

October 26th, 2020, 01:09 AM

Hi guys,

Noob asking for simple alert formula help.

Say if I want to find out the largest green candle over the last 30 green candles (ignore red candles), what would be the alert formula please? Thank you.

Best,
AJ

October 26th, 2020, 02:42 PM

Try this:

1. Add the Spreadsheet Formula study, Hide the study, set 'Draw Zero Values' to No, and put this formula in the Formula field:
=IF(C>O,H-L,0)
This returns the value of each green bar's range.

2. Add the Color Bar Based On Alert Condition study, and use a formula like this on the the Alerts tab:
=MAX(ID2.SG1[0:-30])=H-L
where the Spreadsheet Formula study is ID2. Edit the ID# as needed.

Here's the relevant documentation:
https://www.sierrachart.com/index.php?page=doc/StudyChartAlertsAndScanning.php
https://www.sierrachart.com/index.php?page=doc/StudyChartAlertsAndScanning.php

Sierra Chart Alert Formula Question

Discussion in Sierra Chart

Sierra Chart Alert Formula Question