Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 13:48:50 +0000

How to Post a Message for Support

Post From: Spreadsheet Question

[2014-10-02 16:22:17]
[Go To First Post]
George - Posts: 60
Once there is a chart with the ZigZag Study, with Additional Output to Spreadsheets, applied and a Spreadsheet Study applied. Is there a way to take an average of the ZigZag data for the last 5 or 10 ZigZags? Maybe in in Column H?

I found the answer here: https://www.sierrachart.com/supportboard/showthread.php?t=36406&highlight=indirect+function.

It works very well.

Next, I take a 5 row average of the ZigZag data in column H. The next question is: Is there a way to re-match the 5 row average data back to the rows of the original ZigZags?
Date Time Of Last Edit: 2014-10-02 23:36:50