Login Page - Create Account

Support Board


Date/Time: Tue, 28 May 2024 04:01:04 +0000



Bar colour

View Count: 1043

[2014-03-18 10:39:20]
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]
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]
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]
kirstenjd - Posts: 34
Have you seen my response? Thanks.
[2014-03-19 07:29:53]
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]
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]
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]
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]
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
attachmentSpreadsheetColorBarExample.scwbf - Attached On 2014-03-25 09:11:16 UTC - Size: 27.87 KB - 362 views
attachmentSpreadsheetColorBarExample.StdyCollct - Attached On 2014-03-25 09:11:34 UTC - Size: 18.68 KB - 369 views

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

Login

Login Page - Create Account