Support Board

Date/Time: Thu, 09 May 2024 20:07:13 +0000

Post From: Questions on Spreadsheet_Studies

[2018-07-30 14:17:01] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
5. With the Length set to 4, the price range of the last 4 bars is the difference between AA3 and AA4. To calculate that, use this formula, for example in O3: =ABS(AA3-AA4) However, the preferred way to reference a study's output is to use this syntax: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study =ABS(ID4.SG1@3-ID4.SG2@3) This is the difference in points. To calculate the difference in ticks: =ABS(ID4.SG1@3-ID4.SG2@3)$J$21 To calculate the difference of the previous* previous 4 bars, use the OFFSET function referencing O3, for example in P3: =OFFSET(O3,4,0) Date Time Of Last Edit: 2018-07-30 16:38:39