Support Board
Date/Time: Mon, 25 Nov 2024 08:01:19 +0000
Post From: Time value in Spreadsheet study
| [2024-03-22 14:55:41] |
| John - SC Support - Posts: 36238 |
|
You can display the values as Time in your chart, but you can only be displaying Subgraphs from the Spreadsheet Study that are Time items, any other Subgraph has to be Hidden or Ignored. For instance, if you want to display column AO as time, then set the "Draw Style" to "Value of Subgraph" and set the "Size/Width" to something you will be able to read (start around 10) and set all other subgraphs to either "Ignore" or "Hidden". Then on the "Settings and Inputs" tab of the study settings window set the "Value Format" to "Time". You will be able to view the values for the subgraph as time in the chart. We are not sure what exactly you are asking in terms of "but only one per time line". If you just want to display the time from a cell for the most current bar (i.e. the value in Row 3 of the spreadsheet) then use the "Text Display for Study" to do this, and use the same theory as above - that is, reference the Spreadsheet Study and the Column/Subgraph you want and then set the "Value Format" to "Time". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |