Support Board
Date/Time: Tue, 22 Apr 2025 03:30:53 +0000
Post From: Swing high and low. amount of points between swing highs and lows on chart
| [2025-02-12 17:43:12] |
| John - SC Support - Posts: 39395 |
|
You would need to use the Spreadsheet Study to do this. But it can get complicated depending on which Swing High you want to compare to which Swing Low. In order to get the difference in the most recent pair of Swing High and Swing Low based on the existence of a newer Swing High than a Swing Low, then do the following: - Cell K3: =MOSTRECENTNONZEROVALUE(ID1.SG1@3:ID1.SG1@200) - Cell L3: =MOSTRECENTNONZEROVALUE(ID1.SG2@3:ID1.SG2@200) - Cell M3: =IF(K3 <> 0, K3 - L3, 0) Where ID1 is the ID of the Swing High and Low study, SG1 is the Swing High subgraph of this study and SG2 is the Swing Low subgraph of this study. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function 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 |