Support Board
Date/Time: Wed, 25 Dec 2024 07:07:52 +0000
Post From: Moving average formula help
| [2015-11-11 23:54:24] |
| Sawtooth - Posts: 4142 |
|
=OFFSET(ID11.SG1@63,122,0) would reference 122 rows(bars) earlier than row 63. (The spreadsheet array is in descending order by time). On a 1 second chart: To reference the first second of the previous minute from the current first second of the current minute (in row 3), the offset is 60: =OFFSET(ID11.SG1@3,60,0) If the current first second of the current minute (in row 3) is 09:34:00 then =OFFSET(ID11.SG1@3,60,0) references the 09:33:00 bar. =OFFSET(ID11.SG1@63,60,0) would reference the 09:32:00 bar. =OFFSET(ID11.SG1@63,120,0) would reference the 09:31:00 bar. This assumes there is a bar printed each second. To assure this, go to Chart Settings >> Advanced Settings and check 'Include Columns With No Data'. |