Support Board
Date/Time: Thu, 03 Jul 2025 13:24:46 +0000
Post From: percent change previous days RTH last (close) to current intraday last price
| [2020-04-17 14:48:51] |
| Sawtooth - Posts: 4231 |
|
any suggestions on how I hold the C[-1] constant at previous days RTH (close) last?
This is what I use on a 5 min chart:=IF(AND(MROUND(BARTIME[-1],1/86400)<TIMEVALUE("16:14:00"),MROUND(BARTIME,1/86400)>=TIMEVALUE("16:15:00")),C[-1],ID1.SG1[-1]) where ID1 is the Spreadsheet Formula study. This assumes chart bars are timebased. It returns a persistent price at the close of the 16:10 bar. Date Time Of Last Edit: 2020-04-17 16:22:25
|