Support Board
Date/Time: Tue, 04 Nov 2025 13:39:36 +0000
Spreadsheet study average of zig zag line length
View Count: 1277
| [2020-02-13 14:12:39] |
| grantx - Posts: 244 |
|
The zigzag study shows me the length of each swing. I can see these numbers plotted in the spreadsheet study in the AF column. I want to get an average of the last 10 swings. The problem is that there are a lot of zeros before a new swing prints. See attached. How do I create a formula to put into the K column, which only gives me an average of numbers that are not zero? I just want a single cell to display the average and not copied down the entire spreadsheet. |
1.png| [2020-02-14 04:12:21] |
| |
|
Refer to the following to help you with this: Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values Also refer to: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#AVERAGE_IGNOREZEROS_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2020-02-14 04:49:33
|
To post a message in this thread, you need to log in with your Sierra Chart account: