Support Board
Date/Time: Mon, 25 Nov 2024 03:28:51 +0000
Post From: Rolling display of the values of a candle
| [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 |