Support Board
Date/Time: Fri, 16 Oct 2026 14:06:34 +0000
Post From: moving average, bar time duration study
| [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. |