Support Board
Date/Time: Thu, 02 Jan 2025 00:50:54 +0000
Post From: Spreadsheet reset at start of new day
| [2015-07-04 02:02:58] |
| Sawtooth - Posts: 4144 |
|
Try this: Put this in K3: =IF(INT(A3)>INT(A4),1,0)
This will identify the first bar of the day with a 1.Put this in L3: =MEDIAN(B3:INDEX(B3:B1002,MATCH(1,K3:K1002,0),1),C3:INDEX(C3:C1002,MATCH(1,K3:K1002,0),1),D3:INDEX(D3:D1002,MATCH(1,K3:K1002,0),1),E3:INDEX(E3:E1002,MATCH(1,K3:K1002,0),1))
This will give you the OHLC median, resetting on the first bar of the day.In the spreadsheet settings, set the Number of Rows to 1000. You no longer need to limit the rows to the number of bars per day. |