Login Page - Create Account

Support Board


Date/Time: Fri, 19 Dec 2025 23:44:58 +0000



Post From: Spreadsheet question

[2020-04-12 22:46:35]
Sawtooth - Posts: 4300
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