Support Board
Date/Time: Tue, 26 Nov 2024 11:52:08 +0000
Post From: How to plot the developing weekly high and low without plotting the prior ones
| [2023-12-12 22:01:39] |
| John - SC Support - Posts: 36286 |
|
One partial solution is to set the Input for "Number of Days to Calculate" to "5" (or 6, depending on how your chart is setup), but this will still give you some of the information in the previous week. The best solution would be to use the Spreadsheet Study to find the first bar for Sunday's trading (or whatever day/time you have set for the first trade for the week) and then use that Row information to get the data from the Period OHLC to specific columns in the Spreadsheet only to that row that you will then display (you would hide the original Period OHLC study). For example, here is a quick test we did for this - you could make this better than what we did, we just wanted to make sure it would work: - Cell K3: =IF(AND(WEEKDAY(A3) = 1, HOUR(A3) = 17, MINUTE(A3) = 0), ROW(A3), 0) - Cell L3: =MOSTRECENTNONZEROVALUE(K3:K2000) - Cell M3: =IF(ROW(A3) <= $L$3, ID1.SG1@3, 0) This will give you the Open for the Period OHLC for just the current week in column M. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |