Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 04:56:10 +0000



Post From: Chart Background Coloring

[2023-09-29 14:49:49]
Sawtooth - Posts: 4120
It would be great to get further info about how to do it.
Put both the attached files in your Sierra Chart \Data folder.

Apply the Study Collection to your chart, and choose No when asked 'Clear Existing Studies On Chart?'.
Analysis >> 10bar background coloring+

Note: You must have both files in the \Data folder so that the proper settings are applied.

For an understanding of how this works, notice Spreadsheet Study study's settings.

The formula in cell K3 on Sheet1 can be edited as needed. Currently it is comparing the current Close with the previous Close.
Row 3 is the current bar; previous bars are in rows below.
You must use an absolute reference ($) so that all 10 bars color together.
The final 'else' of the IF statements must reference K4.

When you apply this Study Collection to more than one chart in the same chartbook, each chart will have its own Sheet# matching its chart#, but the formula in K3 on Sheet1 will affect all charts/sheets equally.
If you want unique formulas for each chart, set the Formula Source Sheet Number setting to match its chart#, and edit K3 on its respective sheet#.
Date Time Of Last Edit: 2023-09-29 14:53:16
attachment10bar background coloring.scss - Attached On 2023-09-29 14:49:30 UTC - Size: 7.03 KB - 254 views
attachment10bar background coloring+.StdyCollct - Attached On 2023-09-29 14:49:39 UTC - Size: 19.09 KB - 188 views