Support Board
Date/Time: Mon, 25 Nov 2024 13:17:08 +0000
Period High and Low
View Count: 192
| [2024-02-28 19:27:27] |
| Delta Tango Foxtrot - Posts: 32 |
|
Hi, I'm attempting to mark out the highs and lows of the Asia, London, NY, and PM sessions of each day. I have used the High / Low for Time Period - Extended study to accomplish this. Is there a way to hide the lines for periods where the study is not applicable? For example: Asia > 18:00:00 - 23:59:59 showing until 16:59:59 London > 00:00:00 - 05:59:59 showing until 16:59:59 What I'm trying solve is seeing the London lines from the previous day (before 16:59:59) while the study is not applicable (until 00:00:00). Is there a way to hide these lines during that period? Thank you. |
| [2024-02-28 20:57:34] |
| John - SC Support - Posts: 36238 |
|
The easiest way to do this is to use the Spreadsheet Study and use an IF() statement to check the time and if it is not in the time you want output a zero (0). For instance, to only show the values between 00:00:00 and 16:59:59 you would enter the following in cell K3: =IF(AND(FRACTIME(A3) >= TIME(00, 00, 00), FRACTIME(A3) < TIME(16, 59, 59)), ID1.SG1@3, 0) Where ID1 is the ID of the High/Low for time period study and SG1 is one of the Subgraphs. Refer to the following for an explanation of the notation ID1.SG1@3: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2024-02-28 20:59:37
|
To post a message in this thread, you need to log in with your Sierra Chart account: