Home >> Support Board

Support Board

Date/Time: Sat, 28 Dec 2024 23:14:58 +0000

How to Post a Message for Support

[User Discussion] - Need Help for Formula - Study

View Count: 1136

[2016-01-23 04:52:56] #1 [Go To First Post]
nicktrader - Posts: 722
Hi all, need help to create a working formula (tried a lot but no result). My knowledges concerning programming are limited therefore I'd like to use the Study "Color Bar based on Alert...". Please take a look on the attached file. - it shows the pattern I am looking for. I am Using the following studies: 1. EMA = ID1.SG1 2. Swing High/ Low= ID2 H=SG1, L=SG2 3. PatternFinder ID3 - Engulfing Pattern =SG1(red arrow), Doji Pattern = SG2 (blue arrow) The condition should be: 1. 3 higher lows (in row) 2. Engulfing should follow 3. Doji should follow 4. Low of Doji should cross EMA In that case the Doji is also a lower low. There is no need that there is is lower low. In general. Is it possible to use the Study "Color Bar based on Alert..." for that purpose? Many thanks


Pattern + Studies.png / V - Attached On 2016-01-23 04:25:10 UTC - Size: 14.44 KB - 362 views

[2016-01-23 14:22:02] #2 [Go To First Post]
Sawtooth - Posts: 4143
What you want to do is beyond the capability of Simple Alerts, but it could be done with a spreadsheet study.

[2016-01-24 03:28:29] #3 [Go To First Post]
nicktrader - Posts: 722
Good Morning tomgilb, many thanks for your help. Spreadsheets are beyond my capability. I worked one time with a spreadsheet - a very simple spreadsheet - but in that case I can not imagine how this should work. Many thanks

[2016-01-24 18:06:34] #4 [Go To First Post]
Sawtooth - Posts: 4143
Attached is a spreadsheet file that will do this. Put it in your Sierra Chart \Data folder. Then do this: 1) Add the Spreadsheet System/Alert study -Set the Chart Region to 1 -Click on the Select button next to the Spreadsheet Name field and choose NickTrader -On the Subgraphs tab, set the Draw Style of 'Alert' to Color Bar, set all others to Ignore. The # of consecutive higher lows is set in cell P1 on the spreadsheet. You may minimize the spreadsheet. This setup will color the doji price bars according to your conditions listed in Post #1. You may set audible alerts in the spreadsheet study settings >> Settings and Inputs tab >> Column K Alert. Other alert settings are on the same tab.


NickTrader.scss - Attached On 2016-01-24 18:01:08 UTC - Size: 72.67 KB - 429 views

[2016-01-25 04:17:44] #5 [Go To First Post]
nicktrader - Posts: 722
Many many thanks. Absolutely brilliant. Ii will be also a good base for me to study spreadsheet.

[2016-01-25 14:55:14] #6 [Go To First Post]
nicktrader - Posts: 722
@tomgilb As you can see in the attached file (M1 - FDax) I got an Alert (red arrow). Your spreadsheet is really a good base to study. The formulas are similiar to excel and working with it is known :-) Many many thanks for your help.


Spreadsheet Signal.png / V - Attached On 2016-01-25 14:50:05 UTC - Size: 7.67 KB - 354 views

To post a message in this thread, you need to log in with your Sierra Chart account: