Support Board
Date/Time: Thu, 02 May 2024 14:41:07 +0000
Spreadsheet study average of zig zag line length
View Count: 926
[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. |
[2020-02-14 04:12:21] |
Sierra Chart Engineering - Posts: 104368 |
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: