Support Board
Date/Time: Thu, 31 Oct 2024 12:17:49 +0000
Is there a way to show me at what time the daily low was in a spreadsheet study?
View Count: 137
[2024-10-28 17:03:51] |
TraderBake - Posts: 16 |
So that I get the time when a daily high or daily low occured.
|
[2024-10-28 20:03:19] |
John - SC Support - Posts: 35639 |
In order to get the time for a Daily High or Daily Low, you would need to use the "Daily OHLC" study and set the Input for "Graph High and Low Historically" to "Yes". We are not sure what you are looking for in terms of the time, but to get the time for the most recent High (for instance), you would use the following formulas in a Spreadsheet Study after you have added the "Daily OHLC" to the chart: - Cell K3: =IF(ID1.SG2@3 <> ID1.SG2@4, A3, 0) - Cell L3: =MOSTRECENTNONZEROVALUE(K$3:K$2000) Where ID1 is the ID of the "Daily OHLC" study, SG2 is the High subgraph of the "Daily OHLC" study, @3 specifies row 3 of the spreadsheet. Cell L3 will then give the time of when the most recent high was made. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-28 20:42:24] |
TraderBake - Posts: 16 |
Thank you very much for your help. But I get "#SYNTAX!" in k3 and also in L3. What am I doing wrong? |
[2024-10-28 22:51:11] |
John - SC Support - Posts: 35639 |
You have to adjust the formula for your specific situation. So if your Daily OHLC is not ID1, you need to change that. Otherwise, if you copy the formula exactly, you should not get a #SYNTAX error. If you get a Syntax error in K3, you will also get it in L3, that makes sense. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-29 05:30:28] |
TraderBake - Posts: 16 |
ID1 is Daily OHLC, are there any other numbers that I need to adjust?
|
[2024-10-29 15:18:52] |
John - SC Support - Posts: 35639 |
Please copy and paste the formulas from cells K3 and L3 to this thread. Do not modify anything, just paste them as they are so we can take a look.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-29 18:21:06] |
TraderBake - Posts: 16 |
=IF(ID1.SG2@3 <> ID1.SG2@4, A3, 0) =MOSTRECENTNONZEROVALUE(K$3:K$2000) I changed nothing. |
[2024-10-29 18:31:45] |
John - SC Support - Posts: 35639 |
And you are entering the following formula in cell K3 of the "Spreadsheet Study for Trading", correct? =IF(ID1.SG2@3 <> ID1.SG2@4, A3, 0) You should not be getting a #SYNTAX error with the above formula. If you are, then select the button for "Details" in the upper right corner of the spreadsheet window and then get us a screenshot of what it shows in the area that shows up after you select the "Details" button. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-29 20:44:21] |
TraderBake - Posts: 16 |
I entered it in k3 of "Spreadsheet Study". You mean "Spreadsheet System for Trading"? |
Attachment Deleted. Sierra Chart.jpg / V - Attached On 2024-10-29 20:19:24 UTC - Size: 173.43 KB - 5 views |
[2024-10-29 23:36:09] |
John - SC Support - Posts: 35639 |
You do not need the "Spreadsheet System for Trading" for this. The "Spreadsheet Study" is fine. Unless you want to use the Spreadsheet System for Trading for some reason, that is also OK, but you do not want to use cell K3 in that case, as that is the Buy Entry column. There is no reason for you to be getting the #SYNTAX error that is showing. This is very odd. Do you have the "Daily OHLC" study on the chart? If so, what is the ID of that study? That study should be showing in Column AA (or right by there, depending on how you have a few different things setup for your Spreadsheet Study). Is the data for that study showing there? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-30 05:35:31] |
TraderBake - Posts: 16 |
You can see both the chart with daily OHLC and the spreadsheet in the attached files now. Maybe you can now see what I did wrong? |
Sierra Chart Daily OHLC.jpg / V - Attached On 2024-10-30 05:33:08 UTC - Size: 908.32 KB - 4 views Sierra Chart Spreadsheet.jpg / V - Attached On 2024-10-30 05:33:23 UTC - Size: 2.63 MB - 5 views |
[2024-10-30 05:42:07] |
TraderBake - Posts: 16 |
One thing I can see. In the study settings of the spreadsheet it says that its "formula source sheet name" is sheet6. But when the spreadsheet opens it is sheet9. Does that matter? But the values in the spreadsheet seem the correct ones from the chart. |
[2024-10-30 15:40:08] |
John - SC Support - Posts: 35639 |
The Formula Sheet being different is definitely a problem. Is that Spreadsheet being used for any other purpose? If not, then we recommend removing the Spreadsheet Study from the chart and then deleting that spreadsheet file by selecting "File >> Open Spreadsheet", finding the name of that spreadsheet in the list that comes up and selecting it, then select the "Delete Files" button to remove it. Then add the Spreadsheet Study back on that chart and you should be fine. But, make sure the Input for "Formula Source Sheet Number" is the same as the Chart Number. You can also force this by setting the Input for "Always Set Formula Source Sheet To Chart Data Output Sheet" to "Yes". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-30 17:15:00] |
TraderBake - Posts: 16 |
What helped was a second installation of Sierra Chart on D. There is no error now but it is not really the result I wanted. You can see it in the attached file. |
sierra chart spreadsheet new installation.jpg / V - Attached On 2024-10-30 17:13:48 UTC - Size: 2.79 MB - 4 views |
[2024-10-30 18:18:02] |
John - SC Support - Posts: 35639 |
That is the Date/Time as a Floating Point. Select the L Column and then select "Spreadsheet >> Number Format" and set it to "Date-Time" to see the value as the Date and Time like column A.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2024-10-30 19:11:11] |
TraderBake - Posts: 16 |
Thank you very much, that is what I wanted.
|
To post a message in this thread, you need to log in with your Sierra Chart account: