Support Board

Date/Time: Sat, 20 Apr 2024 06:48:04 +0000

[User Discussion] - Spreadsheet Question

[2014-10-02 16:22:17] #1 [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

To post a message in this thread, you need to log in with your Sierra Chart account: