Support Board

Date/Time: Sat, 28 Sep 2024 10:21:50 +0000

Post From: Spreadsheet reset at start of new day

[2015-07-04 02:02:58] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4092
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.