Support Board
Date/Time: Mon, 25 Nov 2024 05:14:41 +0000
Time value in Spreadsheet study
View Count: 420
| [2024-03-20 08:10:30] |
| User642012 - Posts: 52 |
|
Hi How do I use formula to add minutes to the next cell E.g in cell AA3 I entered timevalue(“09:30:00”) and in AB3 I want to add 5 minutes and 8 minutes in AC3 , How can I address it in a formula instead of typing the exact time ? Thanks |
| [2024-03-20 16:09:19] |
| John - SC Support - Posts: 36238 |
|
There are a number of ways to do this. Probably the most straightforward, at least for most people, is to use the "TIME()" function to do what you want. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIME_Function For example, in cell AB3 you would have the following formula to add 5 minutes to the value in AA3: =AA3 + TIME(0, 5, 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-21 03:01:10] |
| User642012 - Posts: 52 |
|
HI i HAVE SET THE FORMULA AS DISCTIBED BUT CAME BACK WITH NUMBERS 0.3888 PLEASE SEE THE ATTACHED SCREEN CAP.Thanks AN AO =timevalue("09:15:00") =AN3+TIME(0,5,0) AN AO 09:15:00 0.3888888888888889 ANY THING MISSING / thanks, |
 Screenshot 03-21-2024 10.52.59.png / V - Attached On 2024-03-21 02:58:36 UTC - Size: 27.72 KB - 54 views Attachment Deleted. Screenshot 03-21-2024 10.52.59.png / V - Attached On 2024-03-21 02:58:58 UTC - Size: 27.72 KB - 50 views |
| [2024-03-21 15:36:39] |
| John - SC Support - Posts: 36238 |
|
That is how the time is stored internally. Select those cells and select "Spreadsheet >> Number Format" and set it to "Time". Refer to the following: Spreadsheet Menu: Spreadsheet >> Number Format For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-22 01:30:18] |
| User642012 - Posts: 52 |
|
HI I TRIED TO DISPLAY THE TIME CREATED ON THE MAIN GRAPH, BUT IT SHOWS A COLOR PATTERN THROUGH OUT THE WHOLE SCREEN, I SET BAR TOP IN SUBGRAPH SETTING, PLEASE ADVISE THANKS A LOT |
| Screenshot 03-22-2024 09.10.36.png / V - Attached On 2024-03-22 01:29:51 UTC - Size: 72.95 KB - 55 views Screenshot 03-22-2024 09.10.36.png / V - Attached On 2024-03-22 01:30:02 UTC - Size: 72.95 KB - 52 views Screenshot 03-22-2024 09.19.53.png / V - Attached On 2024-03-22 01:30:10 UTC - Size: 26.67 KB - 56 views |
| [2024-03-22 03:44:39] |
| Sierra_Chart Engineering - Posts: 17169 |
|
So you want the values of the Subgraph to show as a time text on the chart? Like this 10:15:00? We would probably have to add support for that. We can do that. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2024-03-22 03:45:22
|
| [2024-03-22 05:07:38] |
| User642012 - Posts: 52 |
|
Ok Thanks Please let me know if available Time study can do that , but only one per time line |
| [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 |
| [2024-03-23 01:44:41] |
| User642012 - Posts: 52 |
|
HI I HAVE SET UP A NEW SPREADSHEET INPUT WITH THREE TIME SET DRAW STYLE TO VALUE OF SUBGRAPH, AND STUDY VALUE FROMAT SET TO TIME, BUT i still could see the time appearing on th chart. what am 1 msissing / PEASE ADVISE |
| Screenshot 03-23-2024 09.38.25.png / V - Attached On 2024-03-23 01:43:48 UTC - Size: 84.68 KB - 51 views Screenshot 03-23-2024 09.38.53.png / V - Attached On 2024-03-23 01:43:59 UTC - Size: 108.26 KB - 50 views Screenshot 03-23-2024 09.39.30.png / V - Attached On 2024-03-23 01:44:30 UTC - Size: 82.07 KB - 55 views |
| [2024-03-24 14:37:55] |
| John - SC Support - Posts: 36238 |
|
You are displaying that value in Region 1. Since the Time is a very small value (less than 1) it is trying to display at that level. If you want to display this in Region 1, then you will need to set the Scale to Independent. Also, depending on what the values are like, you may want to have the values be in one line across the graph. To do this, you need to expand the scale for that study so there is a large range of values displayed, which will cause the numbers to appear as a single row. To do this with the scale set to Independent, you would need to add the "Left Side Scale", and then set the Scale for the Spreadsheet Study to enable "Use in Left Side Scale". Then you can adjust the scaling. You can turn off the Left Side Scale once you are done with the adjustment, if you do not want it displayed further. Refer to the following regarding the Left Side Scale: Chart Settings: Use Left Side Scale (Chart >> Chart Settings >> Scale menu) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: