Support Board
Date/Time: Thu, 13 Feb 2025 22:23:32 +0000
Automated Trading Help
View Count: 522
| [2020-12-28 21:18:52] |
| ershidu - Posts: 4 |
|
Only long, For example: B(Open) C(High) D(Low) E(Last) K(Buy Entry) L(Buy Exit) P barA B3 C3 D3 E3 K3 L3 P3 barB B4 C4 D4 E4 K4 L4 P4 When barA higher than barB, it will trigger a Buy order, so in K3: =E3>E4 I use persistent variables to store the low of barB, so in P3: =IF(K3,D4,P4) I want to exit when the price lower than the low of barB, so in L3: =AND($J$8>0,E3<P3) But it show #CREF！ Where is the wrong? How to modify buy exit (L3)? Anyone can help me? Date Time Of Last Edit: 2020-12-29 02:46:49
|
| [2020-12-29 03:43:29] |
| Sierra_Chart Engineering - Posts: 18429 |
|
Here is the relevant documentation for that error: Working with Spreadsheets: #CREF! This occurs when there is a circular reference. Sierra Chart spreadsheets do not support circular references. So you will need to avoid a circular reference. 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, use 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: