Support Board
Date/Time: Tue, 21 Jan 2025 14:02:01 +0000
Post From: Questions on Spreadsheet_Studies
| [2018-07-30 14:17:01] |
| Sawtooth - Posts: 4157 |
|
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
|