Support Board
Date/Time: Thu, 26 Jun 2025 09:09:28 +0000
Post From: Spreadsheet programming question - FRACTIME
| [2021-12-04 22:34:52] |
| Sawtooth - Posts: 4231 |
|
Column A is the bar's Open timestamp, so on a 5 min chart, the difference is always going to be 5 min. 0.003472222222222222 is 5 min (300 sec) in SerialDateTime 5/1440 = 0.003472222222222222 300/86400 = 0.003472222222222222 If you want to compare the current bar's Open time to the current intrabar time, use J41: =FRACTIME($J$41)-FRACTIME(A3) Or you could use the Bar Time Duration study. |