Support Board
Date/Time: Sun, 06 Jul 2025 07:42:22 +0000
Post From: Offset formula in spreadsheet
| [2024-04-30 17:16:32] |
| Sawtooth - Posts: 4235 |
|
Your H5 formula is missing a comma; use this instead: =MAX(INDEX(F$3:F$1002,MATCH($H$4,Z$3:Z$1002,-1),1):INDEX(F$3:F$1002,MATCH($H$3,Z$3:Z$1002,-1),1)) Also, the current Z3 formula returns a #CREF!, so do this instead: Put this in Y1: =MAX(Y3:Y1002) Then use this formula in Z3: =IF(Y3=$Y$1,FRACTIME(A3),0) Also, the time values in H3/H4 need to exist in the Z3:Z1002 range. This might not happen if the bar duration is very short, because the Number of Rows might not include enough range. [Note: https://www.sawtoothtrade.com/example-10.html updated.] Date Time Of Last Edit: 2024-04-30 17:26:47
|