Support Board
Date/Time: Wed, 27 Nov 2024 20:44:12 +0000
Post From: Spreadsheet Question
| [2014-10-02 16:22:17] |
| 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
|