Support Board
Date/Time: Sun, 24 Nov 2024 03:55:19 +0000
Automated Trading Question
View Count: 1471
[2013-09-19 15:23:02] |
Richard Reyes - Posts: 98 |
I am running an Excel spreadsheet automated trading system. How do I "flatten" (cell j29) or "cancel" (cell j27) all working orders when "cummulative closed profit/loss" (cell j11) reaches a certain figure (+10000), while simultaneously "disabling auto trading" (cell j28)? Many Thanks
|
[2013-09-19 16:48:11] |
Sierra Chart Engineering - Posts: 104368 |
What you can do is check the Position quantity is 0 and the Cumulative Closed Profit/Loss is equal to or over a certain amount in a formula used in: "disabling auto trading" (cell j28).
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 |
[2013-09-19 19:07:14] |
Richard Reyes - Posts: 98 |
I have entered the following formula in "Disable Auto Trading" (cell J28) ... =(F11>=10000) and the trading system keeps trading well past 10000. I am trading GBP/CHF. I do not understand what I need to do with cell J8, "Position Quantity" as this cell is "read only." Please advise.
|
[2013-09-19 22:43:56] |
Sierra Chart Engineering - Posts: 104368 |
Use: =AND(J11>=10000,J8=0) 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: