Support Board
Date/Time: Sun, 06 Jul 2025 07:33:27 +0000
Post From: Offset formula in spreadsheet
| [2024-04-30 20:22:18] |
| User440951 - Posts: 54 |
|
Thank you so much ! So I put these elements : Y1 : =MAX(Y3:Y1002) Y3 : =IF(INT(A3)>INT(A4),Y4+1,Y4) Z3 : =IF(Y3=$Y$1,FRACTIME(A3),0) H3 : 09:30:00 H4 : 09:59:00 H5 : =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)) H3 : 09:30:00 H4 : 09:59:00 H5 : =MAX(INDEX(F$3:F$1002,MATCH($H$7,Z$3:Z$1002,-1),1):INDEX(F$3:F$1002,MATCH($H$6,Z$3:Z$1002,-1),1)) Everything works but there is still one small point that I would like to improve. Indeed, I need these calculations for the previous day's session, and the problem is that if I only have one bar from today's session (9:30 a.m. for example) it gives me displayed in H5 #N/A as in H8 And as soon as all the bars from 9:30 a.m. to 10:00 a.m. are closed in H5 I have the correct maximum volume and in H8 always #N/A. I understand the logic of this problem but I don't see how to recover the calculation from the previous session and ignore the current day. I guess you need to include a day -1 variable but how can I do that ? Date Time Of Last Edit: 2024-04-30 20:36:18
|