Support Board
Date/Time: Thu, 26 Sep 2024 23:21:41 +0000
Post From: Offset formula in spreadsheet
[2024-04-29 10:46:15] |
User440951 - Posts: 50 |
Hello everyone, I have a problem with a spreadsheet, here are the formulas in the different columns and ID2.SG13 corresponds to the total volume of the bar. K: Period variable (time) =AND(FRACTIME(A3)>=TIME(9,30,0),FRACTIME(A3)<TIME(9,59,59)) L: Period variable (time) =AND(FRACTIME(A3)>=TIME(15,30,0),FRACTIME(A3)<TIME(16,59,59)) M: Maximum volume calculation period 9:30 a.m.-10:00 a.m. =IF(K3=1,MAX(ID2.SG13@3:ID2.SG13@62),0) M: Maximum volume calculation period 3:30 p.m.-4:00 p.m. =IF(L3=1,MAX(ID2.SG13@3:ID2.SG13@62),0) My chart is set in a session 9:30 a.m. - 9:59:59 a.m. and with an evening session 3:30 p.m. - 3:59:59 p.m. (see capture). My goal is to obtain the maximum volume between 9:30 a.m. and 10 a.m. on one column and on the other between 3:30 p.m. and 4:00 p.m. The problem is that there is a gap, it takes into account the previous candle. That is to say that here on column M (bottom), the maximum volume between 9:30 and 10:00 should be 7401 and not 8299. I don't understand where the problem could come from. Someone would have any idea ? |
2024-04-29 11_39_22.png / V - Attached On 2024-04-29 10:46:00 UTC - Size: 178.91 KB - 43 views |