Support Board

Date/Time: Thu, 02 May 2024 16:43:01 +0000

Post From: Change timing study based on T-1hr

[2021-07-27 21:03:47] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 31315
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