Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Wed, 08 May 2024 00:35:06 +0000

How to Post a Message for Support

Post From: calculate bars per x time

[2019-05-15 14:44:59]
[Go To First Post]
Sawtooth - Posts: 3993
You could do it with the Spreadsheet Study study.

First round the bar timestamp to the nearest 5 min multiple, e.g in cell O3:
=MROUND(A3,5/1440)
Then count the bars from each 5 min multiple, e.g. in cell P3:
=IF(O3<>O4,1,P4+1)