Support Board
Date/Time: Sat, 18 Jan 2025 04:54:11 +0000
Spreadsheet - Referencing Previous Rows
View Count: 703
| [2018-01-26 16:20:04] |
| gayer2428 - Posts: 89 |
|
In a spreadsheet, I want to reference the previous bars (rows) as in : AND(OR(AA3 > AB3, CH<>0) (AA4 > AB4, CH<>1), ...) I did try AA3@4, AB3@4; both gave <SYNTAX> errors. Could someone post the correct syntax? Thanks. |
| [2018-01-26 16:37:20] |
| gayer2428 - Posts: 89 |
|
Ok, I got it. Instead of AA3, AB4, etc. I tried ID17.SG1@4, ID18.SG1@4 and so on... |
| [2018-01-26 18:25:46] |
| |
|
For reference, refer to: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: