Support Board
Date/Time: Sun, 24 Nov 2024 14:53:51 +0000
Testing Spreadsheet System functionality - simple solution
View Count: 300
| [2024-05-16 16:58:22] |
| gambotage - Posts: 16 |
|
Hi guys, What's the deal with the Spreadsheet System for trading. There are parameters to "Signal on bar close" in about 12 different places. I've spent 3 days trying to get a simple Color Background on Alert Condition to fire only ONCE on bar close, and I can't get it to fire ONCE to matter what I do. I've poured over the documentation ad nauseam about Signalling options. Look, I literally just want a market order once the bar closes. Not at the beginning of the bar, and not the next bar. Just the bar that closes. Signal Only Once Per Bar is set to Yes (uses row 4, I know) and Strict Signal Only On Bar Close Evaluation is also set to Yes, Evaluate On Bar Close is checked (set to Yes). Firing twice should be a strict impossibility. What's going on? Thanks If I use (reference) row 4 and turn off Strict Signal Only On Bar Close Evaluation then I get the two entries as shown in the screenshot. Also there are moving drawings all over my charts. You guys gotta fix this. |
 Screenshot 2024-05-15 at 7.47.43 PM.png / V - Attached On 2024-05-16 16:58:16 UTC - Size: 596.24 KB - 51 views |
| [2024-05-16 17:05:19] |
| John - SC Support - Posts: 36238 |
|
We need to deal with one issue at a time. What exactly is the issue with the "Color Bar Based on Alert Condition"? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-05-17 18:20:47] |
| gambotage - Posts: 16 |
|
Hi John, Thanks for your time and support in responding. The movement of drawings issue SC has known about for years. I literally Locked drawings on a chart today and they bounced a large distance from where they were set after successive bars were printed. Not sure how old the platform is but it would appear to me that that specific & simple issue is not solvable within the current architecture. I went through all possibilities of the following signalling options that I thought would affect entry behavior using Range bars & Allow Multiple Positions in Spreadsheet System for Trading (SSFT). Source Alert. Evaluate on Bar Close, CHECKED/UNCHECKED Trading System Setting. Signal Only Once Per Bar, YES/NO Trading System Setting. Strict Signal only on bar Close Eval, YES/NO Row Reference on SSFT. Row 3/Row 4 All (16) combinations were parsed on Replay using the Calculate as Realtime option and all Charts in Chartbook included in Replay. I got to 25 combinations before stopping because I believe I've covered all possibilities with the most logical parameters that would affect behavior (aforementioned). I can also provide an exhaustive list of how they all behave. The original screenshot shows the signal fires twice. Again, having tried the aforementioned I have no idea why I cannot get it to function as it should. Also noteworthy is that I am not referencing whether other present Alert signals are = 1 as a constituent of the signal I'm attempting to execute with (which I wouldn't think would matter but wanted to mention); this is a standalone signal that references multiple subgraphs & checks for certain conditions in order to fire in a very typical manner. I'm simply looking for what parameter settings are needed in order to have it function as it should or else be told definitively that the functionality I am looking for does not currently exist & that logically I would be in the camp of hiring an ACSIL programmer for project work. I hope this has provided clarification to the topics considered above. Thanks! Date Time Of Last Edit: 2024-05-17 20:10:20
|
| [2024-05-17 19:51:38] |
| Sierra_Chart Engineering - Posts: 17156 |
|
There is no issue here at all. Sierra Chart is up-to-date. You are creating the problem yourself and expecting the impossible. You should understand what you are doing.: The movement of drawings issue SC has known about for years. I literally Locked drawings on a chart today and they bounced a large distance from where they were set after successive bars were printed. Not sure how old the platform is but it would appear to me that that specific & simple issue is not solvable within the current architecture.
You cannot accomplish an impossibility. You are creating the problem by drawing a line into an invalid time space. Please do not comment on this further. Refer to: Lines/Rays or Other Chart Drawings Move After Drawing Them Regarding analyzing your automated trading system, refer to: Automated Trading Management: Troubleshooting Automated Trading System Behavior 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 Date Time Of Last Edit: 2024-05-17 19:57:15
|
| [2024-05-17 20:18:12] |
| gambotage - Posts: 16 |
|
My apologies for continuing to comment. I'd like to acknowledge the response and the logic at hand while it may be common on other platforms I understand the rationale of this behavior here. I think Extend Right would be a solution going forward. If there was a forum page that described this already, again my mistake for not coming across it prior to writing in. Second, with the Troubleshooting for Automated Trading resource. There are some suggestions indeed but it looks like the page is largely a disclaimer which also makes sense because SC has no idea what is running on a chart, what are its settings, studies, alerts, etc. The simple scenario I described above appears to have no solution and after clarifying it, it appears that there is no answer or support for it. A shame because it should be a very simple problem to solve. In fact it should be a non-issue for using SSFT study as a solution to execute the automation of a signal, on bar close, when the signal is finally evaluated. |
| [2024-05-17 20:34:55] |
| Sawtooth - Posts: 4118 |
|
The simple scenario I described above appears to have no solution and after clarifying it, it appears that there is no answer or support for it.[
It is very likely there is a solution to this issue.Direct Message me if you would like to pursue a solution. Date Time Of Last Edit: 2024-05-17 20:35:19
|
To post a message in this thread, you need to log in with your Sierra Chart account: