Support Board
Date/Time: Tue, 04 Nov 2025 22:49:09 +0000
Change timing study based on T-1hr
View Count: 563
| [2021-07-27 20:04:36] |
| Ben A - Posts: 123 |
|
Hi, I wish to run a bands study on the price as it was 1 hour ago and overlay this on my normal chart. How can I accomplish this please? Thank you for your advice. Date Time Of Last Edit: 2021-07-27 20:16:28
|
| [2021-07-27 21:03:47] |
| John - SC Support - Posts: 42772 |
|
If we are understanding you correctly, you want to display the Bands from 1 hour previously. To do this, put the Bands study on your chart and hide it. Then add the Spreadsheet Formula to the chart and enter the following formula: =ID1.SG1[-60] Where ID1 is the actual ID of the Bands Study (adjust as necessary) and SG1 is the Subgraph of the Top Band and -60 is the number of bars back for which you want the data (-60 assumes 1 minute bars, if you were using 15 minute bars it would be -4 to get 1 hour back, etc.). You would then add a second Spreadsheet Formula and use the following formula for the lower band: =ID1.SG2[-60] Make sure that both Spreadsheet Formula studies have their Region set to Region 1. Refer to the following for the Spreadsheet Formula: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-07-27 21:17:31] |
| Ben A - Posts: 123 |
|
I struggled to describe what I meant but yes, exactly what I want, thanks John! :)
|
To post a message in this thread, you need to log in with your Sierra Chart account: