Support Board
Date/Time: Sat, 11 Jan 2025 14:37:42 +0000
charting a formula column values from a spreadsheet
View Count: 1196
| [2016-12-12 12:01:28] |
| User553714 - Posts: 184 |
|
I have produced an offset line in no of ticks from a study attached to a chart by calculating the values of this new line in a "Formula Column" in my spreadsheet and now would like to be able to plot this line in chart region 1. I don't want to use a study like "study subgraph add" to produce the offset as I constantly change the offset line values which may trigger my trade depending on trading conditions so I need to maintain control through my spreadsheet values instead of study settings. Is it possible to chart a column of values in a spreadsheet "forumula column" without having to use ACSIL? Is there a study that does does the charting of the values from a formula column?
|
| [2016-12-12 23:28:24] |
| |
|
Is it possible to chart a column of values in a spreadsheet "forumula column" without having to use ACSIL?
We do not understand the question because this is exactly what the Spreadsheet study does by default: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudy.html 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 |
| [2016-12-12 23:53:32] |
| User553714 - Posts: 184 |
|
I have 42 "formula columns" in my spreadsheet for spreadsheet for trading >> studies >> "no of formula columns"; the studies I have added to me charts start being outputed from column BA, each study thereafter is automatically charted as you say. I am trying to chart a column of values before column BA IE from a list of values I have created. I don't want to use a study like "study subgraph add" to produce the offset as I constantly change the offset line values which may trigger my trade depending on trading conditions so I need to maintain control through my spreadsheet values instead of study settings. Is it possible to chart a column of values in a spreadsheet "forumula column" without having to use ACSIL? Is there a study that does does the charting of the values from a formula column? |
| [2016-12-12 23:56:28] |
| |
|
I am trying to chart a column of values before column BA IE from a list of values I have created.
Why are you having a problem with this? You simply make sure that the Draw Style for the Subgraph for that particular Sheet column is set to a visible draw style. What particular column is it in?We are still very bewildered by the purpose of the question. 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: 2016-12-12 23:56:53
|
To post a message in this thread, you need to log in with your Sierra Chart account: