Support Board
Date/Time: Sat, 19 Apr 2025 10:12:45 +0000
Post From: How can I create automatically a horizontal line at time from yesterday
| [2025-03-26 21:47:49] |
| John - SC Support - Posts: 39362 |
|
Probably the "easiest" way to do this would be to use the Spreadsheet Study. To place a line at the Open for the previous day from the bar at 10:30:00, you would enter the following: Cell K3: =IF(AND(WEEKDAY(A3) = WEEKDAY($A$3) - 1, FRACTIME(A3) = TIME(10, 30, 00)), B3, 0) Cell L3: =MOSTRECENTNONZEROVALUE($K3:$K2000) L3 then has the line you want to display. Note that the above will work for any day but Monday. If you need to do this for Monday and show the data from Friday, then you will need to modify the K3 formula. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |