Support Board
Date/Time: Fri, 07 Feb 2025 14:47:45 +0000
value for Close for first 30 mins (Pivot Points)
View Count: 876
| [2020-12-08 18:10:36] |
| User968625 - Posts: 260 |
|
Hello, I hope someone can help with how to get the value for the first 30 mins closes. I am doing a simple pivot (H+L+C/3) for the first 30mins only (don't need it except for that as I can get the high/Low from high/Low study). All I can do with the current PP study is to have it for all periods. I really appreciate the help. Thank you |
| [2020-12-08 19:32:36] |
| John - SC Support - Posts: 37808 |
|
The easiest way would be to use the Spreadsheet Study so that you can put in an IF statement that checks the bar time and only performs the calculation within the window. You could also use the Color Bar Based on Alert Condition with the Pivot Point study and put in the time range for the alert. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-12-09 04:15:01] |
| |
|
Have you looked at this study: https://www.sierrachart.com/index.php?page=doc/PivotPoints.html#s223 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-12-09 12:37:58] |
| User968625 - Posts: 260 |
|
Yes, Thank you. I just wanted the PP for the first 30 mins as an input to other studies but I found a way around it. thank you both
|
| [2020-12-10 15:38:17] |
| User968625 - Posts: 260 |
|
@John, One question. How do you make a study apply to only a specific time range using the spreadsheet formula
|
| [2020-12-10 17:39:25] |
| John - SC Support - Posts: 37808 |
|
Refer to these available functions: Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables For example, if you want the value of ID1.SG1 when the time is greater than 09:00, otherwise a 0, then you would use the following formula: = IF(BARTIME > TIME(9,0,0), ID1.SG1, 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-12-10 19:36:32] |
| User968625 - Posts: 260 |
|
thank you, I will play with that and see. Thanks again for all the amazing input
|
To post a message in this thread, you need to log in with your Sierra Chart account: