Support Board
Date/Time: Wed, 05 Feb 2025 11:45:00 +0000
Show data from spreadsheet on chart
View Count: 2439
| [2018-02-18 23:34:30] |
| User98657 - Posts: 330 |
|
I'm working with a spreadsheet and i've generated a value based on certain parameters. I'd like to see that value on my chart. The value is represented as a percentage (%). I'd simply like to display that value from Column O, Row 3 (O3) on my chart. I thought color bar on alert condition might work by setting Based On: input to my spreadsheet then setting Input 4 to Use Input Data, Input 6 to column O and draw style of the subgraph to Text or Custom Text, but i couldn't seem to make that work. Suggestions? |
| [2018-02-19 02:23:39] |
| |
|
The way this is done is through the Spreadsheet Study: http://www.sierrachart.com/index.php?page=doc/UsingTheSpreadsheetStudy.php You just need to set the Subgraph for column O to have a visible Draw Style. Although you will only see the numbers and not the text. 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 |
| [2018-02-19 15:14:44] |
| User98657 - Posts: 330 |
|
Thank you, but is there a specific draw style i would need to use to plot this value? I've tried Text and Custom Value at Y, but i'm not seeing the number appear on the chart anywhere. And i'm assuming to see the value from O3 on the chart. |
| [2018-02-19 15:44:59] |
| User98657 - Posts: 330 |
|
I got it. At least i got it to display, not sure if its the most efficient way, but I was able to use Text Display for Chart. It's not displayed as a percentage however. Is there a way to display the value as a percentage?
|
| [2018-02-20 18:23:35] |
| |
|
You could use this particular Draw Style: Chart Studies: Value on High (ACSIL: DRAWSTYLE_VALUE_ON_HIGH) Not sure what you mean by display the value as a percentage. You could add a % to the front of it through the Prefix Text for Display Value Input when using the Text Display for Chart study. 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 |
| [2018-02-20 19:42:40] |
| User98657 - Posts: 330 |
|
The problem with that approach appears to be that the value is plotted at the value of the value. in other words, my current value is 7.74 and that number is being plotted to the chart at the level of 7.74 while current market level is 6822. Text Display for Study seems to be working well. To display the value as a percentage I simply multiplied my value by 100 to get number that can be called a "%", then added the % sign to the Prefix Text for Display Value input. Crude, but it works. |
| [2020-03-06 15:54:02] |
| User917679 - Posts: 76 |
|
The way this is done is through the Spreadsheet Study:
http://www.sierrachart.com/index.php?page=doc/UsingTheSpreadsheetStudy.php You just need to set the Subgraph for column O to have a visible Draw Style. Although you will only see the numbers and not the text. I've encountered a problem where when I make a draw line in the subgraph area to "skip zeros", it still graphs the zeros when I replay the chart... Is there a way to fix this? Edit: Alright I fixed it nevermind - what was displaying were small negative numbers that I mistook as zeros(!) Date Time Of Last Edit: 2020-03-06 16:37:29
|
To post a message in this thread, you need to log in with your Sierra Chart account: