Login Page - Create Account

Support Board


Date/Time: Sat, 21 Nov 2026 11:04:05 +0000



Post From: Spreadsheet study: Direct A3 result alignment between two sheets

[2020-10-13 11:48:39]
Sawtooth - Posts: 4362
If I understand you correctly, this might work for you:
=FLOOR(A3,15/1440)

This will return the DateTime of the 15min bar corresponding to each of the 1TickRange bars.