Support Board
Date/Time: Sat, 23 Nov 2024 15:53:32 +0000
Post From: High of Swing Low Bar/Low of Swing High Bar
| [2024-08-23 19:39:36] |
| John - SC Support - Posts: 36238 |
|
With the "Swing High and Low", currently the line extends from the high (if a swing high) or low (if a swing low). Is it possible to extend the low of a swing high and a high of a swing low?
So you are wanting the lowest low of the Swing Highs and the highest high of the Swing Lows? To do this, you would need to use the "Spreadsheet Study" and use the "MINZ()" and "MAX()" functions. The reason you need to do this is that the study "Highest High/Lowest Low for N Bars" will find a value of 0 for the lowest low. You would have the same problem with the MIN() function. In a column in the Spreadsheet system, you would enter the following to the find the lowest low over the recent 1997 bars: =MINZ(ID1.SG1@$3: ID1.SG1@$2000) Where ID1 is the ID of the Swing High/Low study and the references are to cell rows 3 through 2000. You may need to adjust these numbers based on how far back you want to find the lowest low. We leave it to you to work out how to do the MAX for the Highest High. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MINZ_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MAX_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 Date Time Of Last Edit: 2024-08-23 20:32:04
|