Support Board
Date/Time: Wed, 22 Jan 2025 20:58:12 +0000
spreadsheet trading
View Count: 1530
| [2018-10-13 11:57:10] |
| stephane1 - Posts: 112 |
|
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] |
| |
|
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: 112 |
|
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] |
| |
|
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: 112 |
|
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] |
| |
|
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: