Support Board
Date/Time: Wed, 29 Oct 2025 21:55:51 +0000
[Programming Help] - spreadsheed by mistake
View Count: 837
| [2020-01-12 13:53:17] |
| User14686603 - Posts: 14 |
|
I use the following formula = AND (((ID0.SG2 @ 3-ID0.SG3 @ 3)> J21 * 10), ((ID0.SG2 @ 3-ID0.SG3 @ 3) <= J21 * 15)) in the system spreadsheed for alerts. Please tell me why errors appear only in lines number 22, 53, 54, 55, 56 74. The screenshot below. thanks in advance |
 по спредшит на форум 12-01-20.png / V - Attached On 2020-01-12 13:51:57 UTC - Size: 164.89 KB - 274 views Attachment Deleted. по спредшит на форум 12-01-20 1.png / V - Attached On 2020-01-12 13:52:22 UTC - Size: 131.16 KB - 271 views |
| [2020-01-12 18:23:31] |
| Sawtooth - Posts: 4281 |
|
In Formula Columns, you must use an absolute reference to J21: = AND (((ID0.SG2@3 - ID0.SG3@3) > $J$21 * 10) , ((ID0.SG2@3 - ID0.SG3@3) <= $J$21 * 15)) You can also use fewer parentheses: = AND (ID0.SG2@3 - ID0.SG3@3 > $J$21 * 10 , ID0.SG2@3 - ID0.SG3@3 <= $J$21 * 15) And you can use direct cell references for OHLC values: = AND (C3 - D3 > $J$21 * 10 , C3 - D3 <= $J$21 * 15) (Note: spaces are only supported in some locations within a formula.) |
To post a message in this thread, you need to log in with your Sierra Chart account: