Support Board
Date/Time: Fri, 07 Feb 2025 18:21:49 +0000
Formula must be too long
View Count: 1700
| [2014-11-09 19:49:00] |
| User28317 - Posts: 149 |
|
Below is an alert I built into color bar based on alert. When I put it into the alert, it is too long and only part of it shows. What is the answer =OR(AND(ID10.SG1>ID10.SG1[-1],ID6.SG1>ID6.SG1[-1],OR(ID10.SG1[-2]>ID10.SG1[-1],ID6.SG1[-2]>ID6.SG1[-1])),AND(ID10.SG1<ID10.SG1[-1],ID6.SG1<ID6.SG1[-1],OR(ID10.SG1[-2]<ID10.SG1[-1],ID6.SG1[-2]<ID6.SG1[-1])),AND(ID10.SG1>ID10.SG1[-1],ID4.SG1>ID4.SG1[-1],OR(ID10.SG1[-2]>ID10.SG1[-1],ID4.SG1[-2]>ID4.SG1[-1])),AND(ID10.SG1<ID10.SG1[-1],ID4.SG1<ID4.SG1[-1],OR(ID10.SG1[-2]<ID10.SG1[-1],ID4.SG1[-2]<ID4.SG1[-1])),AND(ID6.SG1>ID6.SG1[-1],ID4.SG1>ID4.SG1[-1],OR(ID6.SG1[-2]>ID6.SG1[-1],ID4.SG1[-2]>ID4.SG1[-1])),AND(ID6.SG1<ID6.SG1[-1],ID4.SG1<ID4.SG1[-1],OR(ID6.SG1[-2]<ID6.SG1[-1],ID4.SG1[-2]<ID4.SG1[-1]))) |
| [2014-11-09 23:38:34] |
| moonmist - Posts: 127 |
|
Hi, I encountered similar problem in January. One of the solutions was to use spreadsheet: Spreadsheet and ---Color Bar Based on Alert Condition--- study Date Time Of Last Edit: 2014-11-09 23:40:02
|
| [2014-11-10 02:03:45] |
| User28317 - Posts: 149 |
|
Moonmist, I tried it in the spreadsheet and had the same issue. I used copy and paste and only part of it showed up in the spreadsheet alert. |
| [2014-11-10 03:11:42] |
| |
|
In this particular case you need to use the Spreadsheet System/Alert study: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#GeneralInformation You just need to use one of the formula columns which would be K. Set the Draw Style for the K Subgraph/Column to Color Bar. 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 |
| [2014-11-10 03:13:02] |
| moonmist - Posts: 127 |
|
Hi, I tried it on an empty spreadsheet. No problem for the cut and paste. But it does give me an error of "Invalid Formula". |
| [2014-11-10 03:27:45] |
| |
|
You need to enter the formula on the Spreadsheet itself. You would not add it to the Alerts tab of the Study Settings window for the Spreadsheet System/Alert study. Refer to the documentation we linked to in the prior post. You will have to update the formula to work directly within a Spreadsheet. 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 |
| [2014-11-10 10:47:13] |
| User28317 - Posts: 149 |
|
is there someone I can pay to do that for me the first time? I just don't get it.
|
| [2014-11-10 11:51:48] |
| moonmist - Posts: 127 |
|
I think you can figure it out. Just in case ....... http://sawtoothtrade.com/ |
| [2014-11-10 11:54:20] |
| User28317 - Posts: 149 |
|
I talked to sawtooth and they don't want any more work. My condition is both a buy and sell condition. K in the spreadsheet is for buys so I don't know how to break up the formula to fit the condition on the spreadsheet versus the alerts |
| [2014-11-10 13:14:11] |
| moonmist - Posts: 127 |
|
Just in case you have not figured it out: a) You do not need to break up the alert condition formula. Just choose the same DrawStyle for column K as the one you choose in "Color Bar Based on Alert Condition". b) The major difference between the formula in the alert box and Spreadsheet is the way you reference the studies: In alert box, it is StudyID.SubgraphID[integer], where integer is usually not great than 0. In spreadsheet, it is ColumnNumberRowNumber, where RowNumber is an integer greater than 2. Just make the corresponding changes in referencing. Good Luck. PS: You do need to break up the alert formula into BUY and SELL section, if you intend to use the Spreadsheet for automated trading. Date Time Of Last Edit: 2014-11-10 13:35:15
|
To post a message in this thread, you need to log in with your Sierra Chart account: