Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 11:34:13 +0000

How to Post a Message for Support

Bar colour

View Count: 1031

[2014-03-18 10:39:20] #1 [Go To First Post]
kirstenjd - Posts: 34
I use DefaultWorksheetStudy to colour the Chart Background with the formula =IF((AF3>AF4),1,0) When I select “Bar Colour” and not Background, nothing happens. DefaultWorkshettStudy.ID:3>>Settings>>Subgraphs>>Buy Entry>>Draw Style>>Colour Bar (not Background) I would rather have the OHLC bar colour change and not the background.

[2014-03-18 17:12:28] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We do not see any problem with this. Are there any other studies on the chart? Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2014-03-18 17:26:51] #3 [Go To First Post]
kirstenjd - Posts: 34
Yes. 1. DefaultWorksheetStudy.ID:3 2. CCI. ID:4 3. Moving Avarage-Exp.ID:2 4. Account Balance Text-Ext Service 5. Account Balance Graph-Ext Service All the other Draw Styles seem to work fine e.g. Arrow Up, Star, etc.

[2014-03-19 05:32:00] #4 [Go To First Post]
kirstenjd - Posts: 34
Have you seen my response? Thanks.

[2014-03-19 07:29:53] #5 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
As a test, can you start with no studies other than the Spreadsheet study and just perform a simple test using the Color Bar Draw Style for the K column and set the spreadsheet cell K3 to 1 to see if it colors the bars. We also assume the Spreadsheet study is set to display in Chart Region 1. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2014-03-19 09:25:39] #6 [Go To First Post]
kirstenjd - Posts: 34
I removed all the studies and only left DefaultWorksheetStudy,used Color Bar Draw Style for K column (Buy Entry) set colour to Green and typed 1 in cell K3. Still nothing happens. I tried other Draw Styles and they all work fine. Spreadsheet study is set to display in Chart Region 1 (all the other Draw Styles display in Chart Region 1).

[2014-03-20 05:48:19] #7 [Go To First Post]
kirstenjd - Posts: 34
I did what you mentioned and still no bar color change. See my response. Any advice what to try next?

[2014-03-20 07:04:52] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We need to put together an example. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2014-03-25 09:14:53] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We finally have prepared the example. We have attached both the Study Collection and the Spreadsheet file. Both of these need to be saved to your Sierra Chart Data Files Folder. Here is the general documentation to work with them: https://www.sierrachart.com/index.php?l=doc/doc_DLLUsage.html#SC The bars are colored one color when the close price of a bar is above the moving average and another color when the close price is below the moving average. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-03-25 09:15:53


SpreadsheetColorBarExample.scwbf - Attached On 2014-03-25 09:11:16 UTC - Size: 27.87 KB - 356 views SpreadsheetColorBarExample.StdyCollct - Attached On 2014-03-25 09:11:34 UTC - Size: 18.68 KB - 364 views

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