Support Board
Date/Time: Mon, 25 Nov 2024 03:24:52 +0000
Rolling display of the values of a candle
View Count: 216
| [2024-04-11 09:53:41] |
| User931541 - Posts: 17 |
|
Good morning, I would like to display the candles not according to a time interval (every x minutes a 'blank' candle with new values) but always display the last x seconds/minutes... a rolling display of the values of a candle. Unfortunately, I have not found anything about this in the ChartSettings. Is there a possibility for the NumbersBars study? With the study 'VolumeByPrice' I can do this via the TimePeriod or NumerOfBars, but candles cannot be displayed in this way. Tom |
| [2024-04-11 15:02:13] |
| John - SC Support - Posts: 36238 |
|
We are not understanding what exactly you want to do. Are you only wanting to view the most recent x number of bars? Or are you wanting to view the bars in a different manner (such as values instead of the typical graphical display)? Or something else? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-04-11 17:59:25] |
| User931541 - Posts: 17 |
|
Let me try this with a one-minute chart as an example. In a 'one minute chart', a new candle with new data is always displayed after 60 seconds. I am looking for a display option that always shows the data of the last 60 seconds in a candle. So the newest value replaces the oldest value, the candle always shows 60 seconds. |
| [2024-04-11 18:50:24] |
| John - SC Support - Posts: 36238 |
|
Ok, we think we understand what you are looking for in terms of a rolling candle. There is a way to do this to view a rolling bar, but not an easy way to get advanced items like Bid/Ask data for the bar. Also, the validity of the data will depend on the granularity of the underlying data. Using a smaller bar period will give better results. The idea is to have a chart with a finer granularity from what you want and then find the Open/High/Low/Close over those bars and then have that information continually update. For example, to get a rolling 1 minute bar you could use a 10 second graph and look to the last 6 bars to get what you want. To do this, you will use the Spreadsheet Study and enter the following in the listed cells (the values given are based on the example above of 10 second bars making up a 1 minute rolling bar): K3: =ID0.SG1@8 L3: =MAX(ID0.SG2@3:ID0.SG2@8) M3: =MIN(ID0.SG3@3:ID0.SG3@8) N3: =ID0.SG4@3 On the Inputs for the Spreadsheet Study set the option for "Use Price Graph Style" to "Yes". Then on the Subgraphs tab on the top, enable the option for "Use Chart Graphics Settings for Subgraph Colors" in order to use the colors you have set for the price graph. Doing this will give you the most recent bar displayed for the Spreadsheet Study as the rolling 1 minute bar. Refer to the following: Using the Spreadsheet Study Spreadsheet Study Inputs: Use Price Graph Style https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MIN_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MAX_Function Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-04-12 18:02:48] |
| User931541 - Posts: 17 |
|
Great, thanks for the information, I'll give it a try.
|
To post a message in this thread, you need to log in with your Sierra Chart account: