Support Board
Date/Time: Fri, 31 Oct 2025 06:26:57 +0000
[User Discussion] - Count time when bars move 20 points
View Count: 304
| [2025-02-08 06:07:22] |
| User488241 - Posts: 42 |
|
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! |
| [2025-02-08 06:08:32] |
| User488241 - Posts: 42 |
|
Oh i wanted to clarify that i use volume bars and not time bars.
|
| [2025-02-08 20:03:38] |
| User488241 - Posts: 42 |
|
figured out a ghetto way around it. Made a 20pt range chart and am plotting the bar duration.
|
To post a message in this thread, you need to log in with your Sierra Chart account: