Support Board
Date/Time: Tue, 22 Apr 2025 03:30:53 +0000
Post From: Count time when bars move 20 points
| [2025-02-08 06:07:22] |
| User488241 - Posts: 41 |
|
Hello, I am using spreadsheet study to try to accomplish the following. add up previous E (last value) column until it reaches 20 or -20. Take the same relative cells in the bar duration value of numbers bars and sum those up. Plot that with a moving average. I'm having an issue with trying to execute the logic of it in spread sheets. ie. if(sum(e3:e(unknown cell value))=or(20,-20), (unknown cell value), 0) take the unknown cell value and use it to sum the time values up. Thank you if you have any tips! |