Support Board
Date/Time: Tue, 26 Nov 2024 02:25:29 +0000
Bar colour
View Count: 1099
| [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] |
| |
|
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] |
| |
|
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] |
| |
|
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] |
| |
|
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 - 1022 views SpreadsheetColorBarExample.StdyCollct - Attached On 2014-03-25 09:11:34 UTC - Size: 18.68 KB - 522 views |
To post a message in this thread, you need to log in with your Sierra Chart account: