Support Board
Date/Time: Sat, 01 Mar 2025 12:53:09 +0000
[Programming Help] - Restart Spreadsheet study base on Regular trading Hours (RTH)
View Count: 726
| [2021-09-09 20:45:55] |
| Mario Escalante - Posts: 21 |
|
I'm using the following function: =IF(ISNUMBER(SEARCH("09:30",D1)),"1","0") my problem is that the SEARCH and FIND functions are for text only, so the formula won't return the desired value (1) tried converting the value to text format, does not work Any workaround for this problem? how can I set my spreadsheet study formulas to restart every day at 09:30 am. (RTH open) thank you for the help |
| [2021-09-09 22:23:44] |
| Sawtooth - Posts: 4177 |
|
If you have a bar with the 09:30:00 timestamp, you could use this: =MROUND(FRACTIME(A3),1/86400000)=TIMEVALUE("09:30:00") If the 09:30:00 bar is the first bar of a new day, you could use this: =INT(A3)>INT(A4) |
| [2021-09-13 16:47:38] |
| Mario Escalante - Posts: 21 |
|
Tried #2 post, first suggestion unsuccessfully. RESOLVED USING THE FOLLOWING FORMULA: =IF(FRACTIME(A3)=TIME(09, 30, 00,0),1,0) that will give you a (1) value everyday @ 09:30:00am Thanks. Date Time Of Last Edit: 2021-09-13 16:48:37
|
To post a message in this thread, you need to log in with your Sierra Chart account: