Support Board
Date/Time: Fri, 28 Feb 2025 04:12:58 +0000
Post From: Change timing study based on T-1hr
| [2021-07-27 21:03:47] |
| John - SC Support - Posts: 38259 |
|
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 |