Home >> Support Board

Support Board

Date/Time: Thu, 16 Jan 2025 16:49:14 +0000

How to Post a Message for Support

Post From: Spreadsheet Formula Question and Testing Help

[2017-11-09 09:00:06] Link To Thread - Link To Post [Go To First Post]
Sierra Chart Engineering - Posts: 104368
SC software and spreadsheets is the most aggravating application and auto trading method I have every had to deal with. If it does not meet your requirements, then use ACSIL instead of this comment. Refer to: Advanced Custom Study Interface and Language (ACSIL) The basic problem is you are probably trying to use Spreadsheet for things that are difficult to accomplish with Spreadsheets. It was no longer placing orders with the K and M cells stuck on "1" and will not enter a trade. No coding changes made or setting changes made. We believe the problem is with your formulas. You have to go through them carefully and also look at the formula expression tree for each one. This is not something that we can analyze for you. I Enable the "Enhanced Auto Trade Signal Related Logging" to see why signals was being ignored No date shows up in the Trade Service Log. This really makes no sense, and we cannot validate what you are saying. No one else is having a problem like this at all. For debugging: I tried setting the"Reset Condition on new bar" to Yes. K and M columns still never switch to back to zero. You are not understanding this. Refer to the documentation here for it: Spreadsheet Systems, Alerts and Automated Trading: Reset Condition On New Bar If the formula results all returning 1 as you are claiming, and that very well could be, then the issue is going to be with the formulas. It is extremely unlikely there is any malfunctioning in the Spreadsheets. If that were the case, then we would have to get your spreadsheet and look into it. But we would have to be convinced of a genuine problem but in your case we are not. I completely removed the formulas from the K and M column and enter a "0". Ran the chart a few bars and placed a "1" in the K column and still no trade placed and no data appears in the Trade Service Log. You must be doing something wrong. Go through the test procedure here: Spreadsheet System for Trading Test Procedure 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 Date Time Of Last Edit: 2017-11-09 09:01:26