Support Board
Date/Time: Fri, 16 Oct 2026 14:07:29 +0000
moving average, bar time duration study
View Count: 33
| [2026-10-15 23:20:46] |
| daif1029 - Posts: 15 |
|
hi, i had applied a moving avergae to the defualt bar time duration study. what i am trying to formulate is the moving average being <= 00:00:02 |
| [2026-10-16 00:38:32] |
| User719512 - Posts: 505 |
|
Bar Time Duration stores the time as a DateTime/double where the integer portion represents days and the fractional portion represents a fraction of a day. You need to use the Spreadsheet Formula study or Study Subgraph Multiply study to convert the datetime into seconds; multiply by 86400 since there are 86400 seconds in a day. Then you can use a moving average on this "number of seconds" study result. Then you can alert, possibly with Color Bar Based on Alert Condition, when that value is under your threshold. |
To post a message in this thread, you need to log in with your Sierra Chart account: