Login Page - Create Account

Support Board


Date/Time: Fri, 19 Dec 2025 10:48:54 +0000



Post From: Need Help for Formula - Study

[2016-01-24 18:06:34]
Sawtooth - Posts: 4300
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.
attachmentNickTrader.scss - Attached On 2016-01-24 18:01:08 UTC - Size: 72.67 KB - 477 views