Support Board
Date/Time: Wed, 05 Mar 2025 01:46:09 +0000
Post From: OFFSET Function in Spreadsheet
| [2021-12-31 16:47:42] |
| User265682 - Posts: 17 |
|
Hi Tom, Thanks for your reply. I have tested this, but am getting the same issue. The formula I am using is; =SUM(OFFSET(BC3,0,0,0,Z3)) I have to reference another cell for the width as it's a dynamic number that updates dependent on the POC location. This number is usually positive although, at times it's a 0 so I'll need to find a way around that at a later stage as this will result in an error. I have also tried swapping the Z3 cell in the formula for a number, but I get the same issue. For reference what I'm trying to do is get an average delta figure for above and below the POC so need to count the price levels from the high / low to the POC. If you know of a study that does this already please let me know haha..! Thanks, Edd Date Time Of Last Edit: 2021-12-31 17:33:20
|