Support Board
Date/Time: Sun, 12 Jan 2025 23:51:33 +0000
Post From: Spreadsheets, Substitute Row # with Reference
| [2017-03-14 01:33:14] |
| Sawtooth - Posts: 4149 |
|
I use the OFFSET function to create a dynamic range based on the Number of Rows: =MAX(ID0.SG5@3:OFFSET(ID0.SG5@3,$J$30-1,0)) or =MAX(F3:OFFSET(F3,$J$30-1,0)) This will give you the max volume in all of column F, because the offset is 999 from row 3. You can use OFFSET in formulas like this: =AVERAGE(ID0.SG4@3:OFFSET(ID0.SG4@3,10,0)) or =AVERAGE(E3:OFFSET(E3,10,0)) This will give you a simple moving average of the Last price, with a length of 10. |