Login Page - Create Account

Support Board


Date/Time: Mon, 17 Mar 2025 18:25:50 +0000



SpreadSheet Buy Entry not executing on true condition

View Count: 1091

[2022-09-09 20:58:35]
User773081 - Posts: 26
for k3 under Buy entry when the value flashes "1" no order is executed. I've set j71:j74 to market order instead of limit. Where can I start fixing this?

Thank you for your time
Date Time Of Last Edit: 2022-09-09 20:59:07
[2022-09-09 22:43:18]
John - SC Support - Posts: 38711
The main thing is that the Input for the Spreadsheet System for Trading for Send Orders to Trading Service needs to be set to Yes.

Once that is done, then if you still have an issue, then check the Trade >> Trade Service Log to see if there is any information in there about why the order did not go through.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-09-10 02:11:37]
Sawtooth - Posts: 4185
You must also set the Limit prices in J22/J24.
[2022-09-14 15:38:24]
User773081 - Posts: 26
Thank you for the reply

This is specifically for the spreadsheet. Whether simulated or real time when column K3(Buy Entry) flashes "True" / "1" no order is executed. When the column flashes True there isn't a corresponding message log as to why it didn't execute.

a side question to this, would there be a formula for the spreadsheet that says "When the value is triggered, take that current price and hold it" so that i could then use a limit price in place? in the order of trying to solve this problem.
[2022-09-14 15:47:44]
rdh - Posts: 3
Hi, I'm having the same problem.

John - where can I find the option Send Orders to Trading Service?

I can't locate it.
[2022-09-14 16:08:29]
Sierra_Chart Engineering - Posts: 18809

This is specifically for the spreadsheet. Whether simulated or real time when column K3(Buy Entry) flashes "True" / "1" no order is executed. When the column flashes True there isn't a corresponding message log as to why it didn't execute.
Refer to:
Spreadsheet Systems, Alerts and Automated Trading: Ignored Signals With Spreadsheet Systems or Alerts

There is an input for enhanced logging.


No:
would there be a formula for the spreadsheet that says "When the value is triggered, take that current price and hold it" so that i could then use a limit price in place?
For things like this you really need to use ACSIL:
Advanced Custom Study Interface and Language (ACSIL)

where can I find the option Send Orders to Trading Service?
This is a Spreadsheet System for Trading study Input:
Spreadsheet Study Inputs


Refer to:
Automated Trading Management: SendOrdersToTradeService
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: 2022-09-14 16:09:44

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account