Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 07:58:41 +0000

How to Post a Message for Support

Post From: Missing Open to Close(Last) Range in "High/Low for Time Period" study

[2023-07-24 14:24:30]
[Go To First Post]
Sawtooth - Posts: 4000
Any suggestions on what I'm doing wrong?
You would need to create persistent variables of the Open price at 9:30:00 and of the Close price at 10:29:59.

You could do that with the Spreadsheet Formula study, using formulas like these in their Formula fields:
=IF(AND(BARTIME>=TIME(9,30,0),BARTIME<TIME(9,30,1)),O,ID21.SG1[-1])
=IF(AND(BARTIME>=TIME(10,25,0),BARTIME<TIME(10,25,1)),C,ID22.SG1[-1])
where the Open persistent Spreadsheet Formula study is ID21, and the Close study is ID22.
(the Close study formula assumes a 5 minute chart.)

Then reference these persistent variables' studies instead of C,O