Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 15:56:51 +0000
[User Discussion] - Spreadsheet study formula
View Count: 910
| [2015-02-15 22:01:11] |
| User48557 - Posts: 138 |
|
=IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("17:00:00"),A3-INT(A3)>=TIMEVALUE("17:00:00")),B3,K4) That formula is for a horizontal line that starts every Sunday open. I'd like to know if there is a similar formula for Fridays closing price. I'd like the horizontal line to start on Friday's close and be drawn up to next Fridays close. |
| [2015-02-16 00:49:59] |
| Sawtooth - Posts: 4000 |
|
Use 6 for Friday, edit the timevalue to Friday's final bar time, and change B3 to E3, e.g.: =IF(AND(WEEKDAY(A3)=6,A4-INT(A4)<TIMEVALUE("16:00:00"),A3-INT(A3)>=TIMEVALUE("16:00:00")),E3,K4) Date Time Of Last Edit: 2015-02-16 04:07:25
|
To post a message in this thread, you need to log in with your Sierra Chart account: