Support Board
Date/Time: Wed, 12 Feb 2025 10:59:19 +0000
Post From: How to Reference Time in Spreadsheet for Trading
| [2020-10-17 20:58:43] |
| Sawtooth - Posts: 4173 |
|
Try this in K3/M3: =FRACTIME(MROUND(A3,1/86400))=TIMEVALUE("12:55:00") This assumes your chart is set to Pacific time. 'Signal Only On Bar Close (K,M)' will need to be set to No. Sierra's bar timestamp is at the Open. FRACTIME removes the Date from the DateTime. MROUND is used to round the Time to the second, to remove any floating point errors. (There are 86400 seconds in 24 hours.) TIMEVALUE converts text of the time to the Time in SerialDateTime format. Spreadsheet Functions: Available Functions |