Support Board
Date/Time: Wed, 27 Nov 2024 17:49:52 +0000
Post From: Missing Open to Close(Last) Range in "High/Low for Time Period" study
| [2023-07-24 14:24:30] |
| Sawtooth - Posts: 4120 |
|
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 |