Support Board
Date/Time: Tue, 26 Nov 2024 02:02:49 +0000
Post From: Study- Automatic Previous Day/Week/Month High,Low,Close Horizontal line
| [2022-12-27 21:30:08] |
| John - SC Support - Posts: 36286 |
|
To go back 2 weeks (or so some specific point in time that is not the current period or the prior period) you would need to use the Spreadsheet Study to do this and then use a combination of Date/Time checks along wit the SMALL() and LARGE() functions to get the Highest High and Lowest Low within the period. For example, to find the High within a period of November 14 through November 18 you would enter the following formulas in the Spreadsheet Study: K3: =IF(AND(A3 >= DATE(2022, 11, 14), A3 <= DATE(2022, 11, 18)), B3, 0) L3: =LARGE(K3:K2000, 1) Column L will display that High. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |