Login Page - Create Account

Support Board


Date/Time: Thu, 06 Feb 2025 05:59:30 +0000



Post From: Spreadsheet question

[2020-04-12 22:46:35]
Sawtooth - Posts: 4169
Try this in P3:
=IF(AND($P$1>=FRACTIME(A3),$P$1<FRACTIME(A2)),B3,P4)
This will return the persistent Open price of the bar wherein the time in P1 occurred.
Date Time Of Last Edit: 2020-04-12 23:29:46