Support Board
Date/Time: Sun, 29 Jun 2025 23:09:00 +0000
Post From: Offical opening price on historical charts
| [2021-07-03 12:28:13] |
| Sawtooth - Posts: 4231 |
|
If you want to use a spreadsheet formula instead of another study, try this: Assuming you have a chart bar timestamped with 09:30:00, you can use this formula, e.g. in cell U3: =IF(MROUND(FRACTIME(A3),1/86400)=TIMEVALUE("09:30:00"),B3,U4) This rounds the Time of the DateTime to 1 second, then compares it to the timevalue of 09:30:00. If they are equal, it persists the Open price until the next 09:30:00. |