Support Board

Date/Time: Tue, 18 Jun 2024 10:18:04 +0000

Post From: Offset formula in spreadsheet

[2024-04-29 17:36:18] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 32414
The problem is that you are using relative references to the cells. So for Row 3 everything works fine, but for Row 4 the calculation in M4 would be the following: =IF(K4=1,MAX(ID2.SG13@4:ID2.SG13@63),0) And so on, so you are not viewing just the data from the one period of time. You would have to change these to be absolute references in order to get the correct data. So you would want to enter the following for M3 (for example): =IF(K$3=1,MAX(ID2.SG13@$3:ID2.SG13@$62),0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing