Support Board
Date/Time: Sat, 30 Nov 2024 06:49:14 +0000
Post From: High and Low for first trading day of the month.
| [2022-11-30 16:53:08] |
| John - SC Support - Posts: 36350 |
|
To get you started here is what you do: - Add the High/Low for Time Period to your chart and set the times to cover the day as you want it defined. Set this study to be "hidden". - Add the Spreadsheet Study to your chart and set it for Region 1 and in cell K3 enter the following: =IF(DAY(A3) = 1, ID1.SG1@3, 0) Where ID1 is the ID of the High/Low for Time Period study and SG1@3 specifies the High subgraph information at the 3rd row. - If you want the line to display across the full month, then enter the following in the L3 cell: =MOSTRECENTNONZEROVALUE(K3:K2000) Where the range of K3:K2000 will need to change depending on the range of the data that you are displaying in the Spreadsheet study. You will then want to set the subgraph for the K column to Ignore so you will have the L column displayed. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |