Login Page - Create Account

Support Board


Date/Time: Mon, 13 May 2024 05:58:43 +0000



spreadsheet trading

View Count: 1314

[2018-10-13 11:57:10]
stephane1 - Posts: 110
Hi,

I have a problem, I use "spreadsheet automated trading" and I've an sell order that appears but the cell M3=0, L3=0????????
best
SR

MY trade service log is OK but an sell order is send !!!!!

Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Sell Entry | Signal ignored because current Alert Condition formula is FALSE | Cell: M3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Sell Exit (Buy) | Signal ignored because current Alert Condition formula is FALSE | Cell: N3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Buy Entry | Signal ignored because current Alert Condition formula is FALSE | Cell: K3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Buy Exit (Sell) | Signal ignored because current Alert Condition formula is FALSE | Cell: L3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Sell Entry | Signal ignored because current Alert Condition formula is FALSE | Cell: M3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Spreadsheet System - Replay 1.00X: ESZ8-CME [CB] 1 Min #9 | Spreadsheet: ESbot | Sell Exit (Buy) | Signal ignored because current Alert Condition formula is FALSE | Cell: N3 | Bar start date-time: 2018-10-12 17:47:00 | 2018-10-13 14:19:37
Date Time Of Last Edit: 2018-10-13 12:21:35
[2018-10-13 21:05:09]
Sierra Chart Engineering - Posts: 104368
This is explained here:
Spreadsheet Systems, Alerts and Automated Trading: Disappearing Arrows or Signals
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
[2018-10-14 16:21:25]
stephane1 - Posts: 110
Hi,
Thanks for the last "post" but doesn't work. I don't understand. For explain, I 'v post Screenshot below. My setup is an orange vertical line on Footprint. At 18:36 an Order SELL entry was sent, it's correct, but at 18:37 an other order was sent, that's not correct !

Signal Only On Bar Close (Columns K,M) / (Columns L,N-Z) Input to Yes, OK.

Where is the bug ?

bests
SR



http://www.sierrachart.com/image.php?Image=1539533580487.png
Date Time Of Last Edit: 2018-10-14 16:24:54
Private File
[2018-10-15 18:41:28]
Sierra Chart Engineering - Posts: 104368
While this is not related to the problem we see you are running an older version. We want you to update following the instructions here:
Software Download: Fast Update

From Documentation:
In summary, the standard Up and Down arrows on a chart displayed by these Spreadsheet studies and the result of formulas in cells K3, L3, M3, N3 (or at row 4), indicate the present state of the formulas. During the formation of a bar or after new bars are added to the chart, a formula could go from TRUE (1) to FALSE (0) based upon the logic of the formula and changing data in the cells that it references. It is up to you to determine specifically what is happening and why.

To actually see where the trades were made, you need to display Order Fills on the chart. You can also refer to the Trade Activity Log.

It might help to use Strict Evaluate on Bar Close:
Spreadsheet Systems, Alerts and Automated Trading: Strict Signal Only On Bar Close Evaluation
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: 2018-10-15 18:44:27
[2018-10-15 21:24:29]
stephane1 - Posts: 110
HI
Sorry but doesn't work.....after set yes "strict signal.....

http://www.sierrachart.com/image.php?Image=1539638404525.png

bests
SR
[2018-10-16 20:27:31]
Sierra Chart Engineering - Posts: 104368
We can only refer you to this documentation here:
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, *change* to 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:

Login

Login Page - Create Account