Support Board
Date/Time: Tue, 22 Apr 2025 02:36:33 +0000
Swing high and low. amount of points between swing highs and lows on chart
View Count: 78
[2025-02-12 16:18:12] |
Owen_Jay - Posts: 9 |
Hi, I have the Swing high and Low indicator on my charts. Is it possible to have the amount of points between the swing highs and lows marked on the chart? I am trying to record the average amount of points between the swing highs and lows. If I could have them marked on the chart, it would be much quickedr than me manually using the chart calculator. Thanks for your help appreciated. Regards Owen |
[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 |
To post a message in this thread, you need to log in with your Sierra Chart account: