Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 07:58:45 +0000

How to Post a Message for Support

Post From: Spreadsheets, Substitute Row # with Reference

[2017-03-14 01:33:14]
[Go To First Post]
Sawtooth - Posts: 4000
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.