Support Board
Date/Time: Wed, 27 Nov 2024 18:43:28 +0000
[User Discussion] - Spreadsheet question
View Count: 960
| [2014-09-25 15:39:49] |
| George - Posts: 60 |
|
Is there a way to reference the time of the close, i.e. the last bar of a 5 minute intraday chart, in a formula? For example, in column K, =If(A3=12:55,E3,0). This is for accumulating intraday numbers from the ZigZag study, applying formulas to the ZigZag numbers, and taking a total at the close.
|
| [2014-09-25 16:19:21] |
| Sawtooth - Posts: 4120 |
|
Try this: =IF(MROUND(A3-INT(A3),1/86400)=TIMEVALUE("12:55:00"),E3,0) The INT function removes the Date from the SerialDateTime, leaving only the Time. The MROUND function rounds the Time to the second, removing floating point errors. The TIMEVALUE function converts the text to a spreadsheet SerialDateTime value. Date Time Of Last Edit: 2014-09-25 16:20:07
|
To post a message in this thread, you need to log in with your Sierra Chart account: