Support Board
Date/Time: Wed, 15 Jan 2025 21:53:33 +0000
Reliability of Trading vie Spreadsheet
View Count: 1554
| [2017-09-18 20:01:59] |
| User39772 - Posts: 311 |
|
Hello, it seems that the calculations in the spreadsheet are not correct. Example for Buy Exit (Sell) I use: =OR(E3<J48-0.3,E3>J48+0.5) When J48 was 187.80 the system exit was at 187.67, i.e. a 13 cent stop loss instead of a 30 cent stop loss. Are there any known problems regarding such issues. |
| [2017-09-18 20:14:23] |
| |
|
You cannot make the conclusion that you are. A spreadsheet formula does not control the fill price of an order. 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 |
| [2017-09-25 16:40:51] |
| User39772 - Posts: 311 |
|
Hello, it is not my intention to control the fill price, but how is it possible if I use the following command for a short exit: =OR(J12>(J48+0.3),J14<(J48-0.6)) that an exit is executed after the price moved 3 Cent against me ? The exit should be no earlier than 30 cent. |
| [2017-09-25 17:05:44] |
| |
|
Analyzing this is not within the scope of our support. In the case of simulated trading, refer to: http://www.sierrachart.com/index.php?page=doc/TradeSimulation.php#HowOrdersAreFilled 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 |
| [2017-09-25 17:49:24] |
| Sawtooth - Posts: 4153 |
|
If your formula is in cell N3, you'll want to use absolute references when referencing non-repeating cells: =OR($J$12>($J$48+0.3),$J$14<($J$48-0.6)) |
To post a message in this thread, you need to log in with your Sierra Chart account: