Support Board
Date/Time: Fri, 13 Jun 2025 07:41:24 +0000
Post From: study spreadsheet
| [2022-11-08 23:03:37] |
| John - SC Support - Posts: 40407 |
|
So sorry - you did state that you tried the other options. And also sorry that the line options did not work, we thought the Line Extend to Edge would work in this case, but we just tried it and we see that it is not doing what you need. The solution is to use the Spreadsheet Study to do the work for you. In an empty calculation column (K - Z by default) enter the following: ==IF(ISNUMBER(EARLIESTNONZEROVALUE(K3:K200)), EARLIESTNONZEROVALUE(K3:K200), L2) Where K3:K200 is the range of the data in which the data point exists and L is the column in which you are entering this formula. Then set the subgraph for column L (or whatever row you are using) to a Draw Style of Line. This will then give you a straight line across the range of the data in the Spreadsheet Study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |